select publish_status from cr_items where item_id = :item_id 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 mime_type from cr_content_mime_type_map where content_type = :content_type and lower(mime_type) like 'text/%' select content_type from cr_items where item_id = :item_id select item_id from cr_revisions where revision_id = :revision_id select content_type from cr_items where item_id = :item_id select live_revision from cr_items where item_id = :item_id select m.mime_type, m.file_extension from cr_mime_types m, cr_revisions r where r.mime_type = m.mime_type and r.revision_id = $revision_id update cr_items set publish_status = :publish_status where item_id = :item_id