select item_id from cr_revisions where revision_id = :version_id select (case when live_revision is null then 1 else 0 end) from cr_items where item_id = :item_id select parent_id from cr_items where item_id = :item_id select title from cr_revisions where revision_id = :version_id