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