select item_id from cr_revisions where revision_id = :section_id select cr.item_id as section_item_id, cr.title, cr.description, s.instructions, s.feedback_text, s.max_time_to_complete, s.display_type_id, s.points from cr_revisions cr, as_sections s where cr.revision_id = :section_id and s.section_id = cr.revision_id select cr.title, cr.description, s.instructions, s.feedback_text, s.max_time_to_complete, s.display_type_id, s.points from cr_revisions cr, as_sections s where cr.revision_id = :section_id and s.section_id = cr.revision_id insert into as_item_section_map (select as_item_id, :new_section_id, required_p, max_time_to_complete, sort_order, fixed_position, points from as_item_section_map where section_id = :section_id)