UPDATE CREATED DATE AND USER para ACTAS y otros

update node n
inner join content_type_acta cta
on n.nid = cta.nid and n.vid = cta.vid
SET n.created = unix_timestamp(field_fecha_value)
WHERE type = 'acta';

update node n
inner join content_field_acta cfa
on n.nid = cfa.nid inner join node a
on a.nid = cfa.field_acta_nid
SET n.created = a.created;

update node n set uid = 51 where type in ('acta','leccion','sintesis','margen');

  [node:read-more:link]