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 )