select title as item_title from cr_revisions where revision_id = :as_item_id update as_assessment_section_map set section_id = :new_section_id where assessment_id = :new_assessment_rev_id and section_id = :section_id select sort_order from as_item_section_map where section_id = :new_section_id and as_item_id = :as_item_id delete from as_item_section_map where section_id = :new_section_id and as_item_id = :as_item_id update as_item_section_map set sort_order = sort_order-1 where section_id = :new_section_id and sort_order > :sort_order