select item_id
from cr_revisions
where revision_id = :version_id
select (case when live_revision = 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