select cp.course_name,cp.fs_package_id from ims_cp_manifests cp where cp.man_id = :man_id and cp.parent_man_id = 0 select ims_item_id as imsitem_id, coalesce(acs_object__name(object_id), 'Item '||object_id) as last_page_viewed from views_views v, ims_cp_items i, ims_cp_organizations o where v.viewer_id = :user_id and v.object_id = i.ims_item_id and i.org_id = o.org_id and o.man_id = :man_id order by v.last_viewed desc limit 1 select i.ims_item_id from ims_cp_items i, ims_cp_organizations o where o.man_id = :man_id and i.org_id = o.org_id select v.object_id from views_views v where v.viewer_id = :user_id and v.object_id in ([join $all_items ,]) select count(*) from lorsm_student_track where community_id = :community_id and course_id = :man_id and user_id = :user_id