select distinct item_type
from as_item_types_map
select latest_revision as as_item_id
from cr_items
where item_id = :as_item_id
update cr_items
set name = :name
where latest_revision = :as_item_id
delete from as_item_rels
where item_rev_id = :as_item_id
and rel_type = 'as_item_content_rel'