select publish_date, data
from cr_revisionsi
where revision_id = :object_id
select s.node_id
from site_nodes s, site_nodes s1, cr_revisions r, cr_items i
where r.revision_id = :object_id
and i.item_id = r.item_id
and s1.object_id = i.parent_id
and s.node_id = s1.parent_id