select max (sort_order) from ims_cp_items where org_id = :org_id select sort_order as order, ims_item_id as reorder_item_id from ims_cp_items where org_id = :org_id and sort_order >= :sort_order update ims_cp_items set sort_order = :new_sort where ims_item_id = :reorder_item_id select item_title from ims_cp_items where ims_item_id = :ims_item_id select item_id from cr_items where name = :course_name and parent_id = :root_folder select item_id from cr_items where name = :course_name and parent_id = :items_root_folder select item_id from cr_items where name = :course_name and parent_id = :root_ims_folder select r.res_id from ims_cp_items_to_resources i, ims_cp_resources r where i.ims_item_id = :the_ims_item_id and r.man_id = :item_man_id and r.res_id = i.res_id select identifier from ims_cp_resources where res_id = :res_id