select live_revision from cr_items where item_id = :ims_item_id
select mime_type from cr_revisions
where revision_id = :revision_id
select content_type from cr_items
where item_id = :item_id
select table_name from acs_object_types
where object_type = :content_type
, content as text
select x.*, :content_type as content_type
$text_sql
from cr_revisions r,
${table_name}x x
where r.revision_id = :revision_id
and x.revision_id = r.revision_id
select live_revision
from cr_items
where item_id = :ims_item_id
select folder_id
from cr_folders
where label = 'LORSM Root Folder'
select track_id
from lorsm_student_track
where user_id = :user_id
select community_id
from lorsm_student_bookmark
where user_id = :user_id
update lorsm_student_track
set user_id = :to_user_id
where user_id = :from_user_id
update lorsm_student_bookmark
set user_id = :to_user_id
where user_id = :from_user_id
select key
from fs_folders
where folder_id = :folder_id
select course_name
from ims_cp_manifests
where man_id = :manifest_id
select key
from fs_folders
where folder_id = :folder_id
select org.org_id,
org.org_title as org_title,
org.hasmetadata,
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 i.parent_item, i.ims_item_id, i.item_title as item_title
from acs_objects o, ims_cp_items i, cr_items cr
where o.object_type = 'ims_item_object'
and i.org_id = :org_id
and o.object_id = i.ims_item_id
and cr.live_revision=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')
and not exists (select 1
from lorsm_custom_pages
where page_id=cr.item_id
and man_id=:man_id)
order by i.sort_order, o.object_id, cr.tree_sortkey
select fs_package_id, folder_id
from ims_cp_manifests
where man_id = :man_id
select key
from fs_folders
where folder_id = :folder_id
select href
from ims_cp_resources r, ims_cp_items_to_resources ir
where ir.ims_item_id = :item_id
and ir.res_id = r.res_id
select item_title
from ims_cp_items
where ims_item_id = :item_id
select folder_id
from cr_folders
where label = 'LORSM Root Folder'
select folder_id
from cr_folders
where label = :name
select count(ims_item_id)
from ims_cp_items, cr_items cr
where ims_item_id = live_revision
and org_id = :org_id $exclude_where
select ims_item_id
from ims_cp_items
where parent_item = :org_id
and org_id = :org_id
$exclude_where
select ims_item_id
from ims_cp_items
where parent_item = :item_id
and org_id = :org_id
$exclude_where
select dotlrn_community_applets.package_id
from dotlrn_community_applets
join apm_packages on (dotlrn_community_applets.package_id=apm_packages.package_id)
where community_id = :community_id
and package_key='lorsm'
select 1
from lorsm_custom_pages
where man_id=:man_id
and type=:type
insert into lorsm_custom_pages
(man_id,page_id,type)
values
(:man_id,:item_id,:type)
update lorsm_custom_pages
set man_id=:man_id,
page_id=:item_id,
type=:type
select live_revision
from cr_items, lorsm_custom_pages
where page_id=item_id
and man_id=:man_id
and type=:type