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