select org_id from ims_cp_organizations where man_id = :man_id select org.org_id, org.org_title as org_title, org.hasmetadata, man_id, tree_level(o.tree_sortkey) as indent from ims_cp_organizations org, acs_objects o where org.org_id = o.object_id and man_id = :man_id order by org_id select fs_package_id from ims_cp_manifests where man_id = :man_id 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 -- (tree_level(ci.tree_sortkey) - :indent ) as indent, i.parent_item, i.ims_item_id, i.item_title as item_title, i.prerequisites_s as prerequisites, cr.mime_type from acs_objects o, ims_cp_items i, cr_items ci, cr_revisions cr, ims_cp_manifest_class im where o.object_type = 'ims_item_object' and i.org_id = :org_id and o.object_id = i.ims_item_id and im.man_id=:man_id and im.isenabled='t' and im.community_id=:community_id and ci.item_id=cr.item_id and cr.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, ci.tree_sortkey select res_id from ims_cp_items_to_resources where ims_item_id= $item_id limit 1 select lorsm.track_id as track_id, cmi.lesson_status as lesson_status from lorsm_student_track lorsm, lorsm_cmi_core cmi where lorsm.user_id = $user_id and lorsm.community_id = $community_id and lorsm.course_id = $man_id and lorsm.track_id = cmi.track_id and cmi.man_id = $man_id and cmi.item_id = $item_id order by lorsm.track_id desc limit 1 select i.ims_item_id as id_from_ref from ims_cp_items i, ims_cp_manifest_class im, ims_cp_organizations o where i.identifier=:prer and o.org_id = i.org_id and o.man_id = :man_id and im.man_id= :man_id and im.isenabled='t' and im.community_id=:community_id select lorsm.track_id as track_id, cmi.lesson_status as lex_status from lorsm_student_track lorsm, lorsm_cmi_core cmi where lorsm.user_id = $user_id and lorsm.community_id = $community_id and lorsm.course_id = $man_id and lorsm.track_id = cmi.track_id and cmi.man_id = $man_id and cmi.item_id = $id_from_ref order by lorsm.track_id desc select lorsm.track_id as track_id, cmi.lesson_status as lesson_status from lorsm_student_track lorsm, lorsm_cmi_core cmi where lorsm.user_id = $user_id and lorsm.community_id = $community_id and lorsm.course_id = $man_id and lorsm.track_id = cmi.track_id and cmi.man_id = $man_id and cmi.item_id = $item_id order by lorsm.track_id desc