select key from fs_folders where folder_id = :folder_id select course_name from ims_cp_manifests where man_id = :manifest_id select key from fs_folders where folder_id = :folder_id select i.parent_item, i.ims_item_id, i.item_title as item_title from acs_objects o, ims_cp_items i, cr_items cr where o.object_type = 'ims_item_object' and i.org_id = :org_id and o.object_id = i.ims_item_id and cr.item_id = ( select item_id from cr_revisions where revision_id = i.ims_item_id) and exists (select 1 from acs_object_party_privilege_map p where p.object_id = i.ims_item_id and p.party_id = :user_id and p.privilege = 'read') order by i.sort_order, o.object_id --, cr.tree_sortkey select fs_package_id, folder_id from ims_cp_manifests where man_id = :man_id select key from fs_folders where folder_id = :folder_id select href from ims_cp_resources r, ims_cp_items_to_resources ir where ir.ims_item_id = :item_id and ir.res_id = r.res_id select item_title from ims_cp_items where ims_item_id = :item_id select live_revision from cr_items where item_id = :ims_item_id select mime_type from cr_revisions where revision_id = :revision_id select content_type from cr_items where item_id = :item_id select table_name from acs_object_types where object_type = :content_type , content as text select x.*, :content_type as content_type $text_sql from cr_revisions r, ${table_name}x x where r.revision_id = :revision_id and x.revision_id = r.revision_id select live_revision from cr_items where item_id = :item_id select content_type from cr_items where item_id=:item_id select item_id, content_type from cr_items where item_id = :item_id select folder_id from cr_folders where label = 'LORSM Root Folder' select folder_id from cr_folders where label = :name select count(ims_item_id) from ims_cp_items where ims_item_id in ( select live_revision from cr_items where content_type = 'ims_item_object') and org_id = :org_id select ims_item_id from ims_cp_items where parent_item = :org_id and org_id = :org_id select ims_item_id from ims_cp_items where parent_item = :item_id and org_id = :org_id select track_id from lorsm_student_track where user_id = :user_id select community_id from lorsm_student_bookmark where user_id = :user_id update lorsm_student_track set user_id = :to_user_id where user_id = :from_user_id update lorsm_student_bookmark set user_id = :to_user_id where user_id = :from_user_id select dotlrn_community_applets.package_id from dotlrn_community_applets, apm_packages where dotlrn_community_applets.package_id=apm_packages.package_id and community_id = :community_id and package_key='lorsm'