select folder_id
from cr_folders
where label = :folder_part
select parent_id
from cr_items
where item_id = :folder
select item_id
from cr_revisions
where revision_id = :revision_id
select folder_id
from ims_cp_manifests
where man_id = :man_id
select name
from cr_items
where item_id = :folder_id
select item_id
from cr_items
where name = :name
and parent_id = :parent_id
select href
from ims_cp_resources r, ims_cp_items_to_resources ir
where ir.ims_item_id = :ims_item_id
and ir.res_id = r.res_id
select item_title
from ims_cp_items
where ims_item_id = :ims_item_id
select res_id
from ims_cp_items_to_resources
where ims_item_id = :ims_item_id
select file_id
from ims_cp_files
where res_id = :res_id
select revision_id
from cr_revisions
where item_id = :item_id
and revision_id in ( select f.file_id
from ims_cp_files f, ims_cp_resources r, ims_cp_items_to_resources ir
where f.res_id = r.res_id
and r.res_id = ir.res_id
and ir.ims_item_id = :ims_item_id )