select
cp.man_id,
cp.course_name,
cp.identifier,
cp.version,
cp.fs_package_id,
case when cp.fs_package_id is null then 't'
else 'f'
end as lorsm_p,
cp.folder_id,
acs.creation_user,
acs.creation_date,
pf.folder_name,
pf.format_name,
acs.context_id,
cpmc.community_id,
cpmc.lorsm_instance_id
from
ims_cp_manifests cp,
acs_objects acs,
ims_cp_manifest_class cpmc,
lorsm_course_presentation_formats pf
where
cp.man_id = acs.object_id
and
cp.man_id = cpmc.man_id
and
cpmc.lorsm_instance_id = :package
$extra_query
and
cpmc.isenabled = 't'
and
pf.format_id = cp.course_presentation_format
order by acs.creation_date desc
select v.last_viewed
from 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 v
where v.viewer_id = :user_id
and v.object_id in ([join $all_items ,])
select
item_id
from
cr_revisions
where
revision_id = :man_id