select title as section_title from cr_revisions where revision_id = :section_id select i.as_item_id, cr.title, i.definition from as_items i, cr_revisions cr where cr.revision_id = i.as_item_id and i.as_item_id in ([join $as_item_id ,]) order by i.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 + :item_count where section_id = :new_section_id and sort_order > :after insert into as_item_section_map (as_item_id, section_id, sort_order) values (:as_item_id, :new_section_id, :after)