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 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