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