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 select live_revision from cr_items where item_id = :item_id