select i.item_id, i.name, i.parent_id, i.live_revision, i.latest_revision, i.content_type, i.storage_type, i.publish_status $addtnl_select from cr_items i $addtnl_from where i.item_id = :item_id $addtnl_where update cr_items set name = :name where item_id = :item_id select content_type from cr_items where item_id = :item_id select table_name from acs_object_types where object_type = :content_type select keyword_id as category_id from cr_item_keyword_map where item_id = :item_id