select r.title as item_title, r.title, r.description, i.field_name from cr_revisions r, as_items i where r.revision_id = i.as_item_id and i.as_item_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 update as_item_section_map set sort_order = sort_order+1 where section_id = :new_section_id and sort_order > :after insert into as_item_section_map (as_item_id, section_id, required_p, max_time_to_complete, sort_order, fixed_position, points) (select :new_item_id as as_item_id, :new_section_id as section_id, required_p, max_time_to_complete, :after as sort_order, fixed_position, points from as_item_section_map where as_item_id = :as_item_id and section_id = :section_id)