select title as section_title
from cr_revisions
where revision_id = :section_id
select i.as_item_id, i.subtext, cr.title, i.field_name, i.required_p,
i.max_time_to_complete, i.points, cr.description
from as_items i, cr_revisions cr, cr_items ci
where ci.item_id = cr.item_id
and 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, required_p, sort_order, max_time_to_complete,
fixed_position, points)
(select :as_item_id as as_item_id, :new_section_id as section_id,
required_p, :after as sort_order, max_time_to_complete,
0 as fixed_position, points
from as_items
where as_item_id = :as_item_id
and not exists (select 1
from as_item_section_map
where as_item_id = :as_item_id
and section_id = :new_section_id))