select item_id from cr_revisions where revision_id = :revision_id
select content_type from cr_items where
item_id = :item_id
select mime_type from cr_content_mime_type_map
where content_type = :content_type
and lower(mime_type) like 'text/%'
select table_name from acs_object_types
where object_type = :content_type
select
x.*,
:item_id as item_id $text_sql,
:content_type as content_type
from
cr_revisions r, ${table_name}x x
where
r.revision_id = :revision_id
and
x.revision_id = r.revision_id
select publish_status from cr_items where item_id = :item_id