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