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)