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'