select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select 1 from ims_cp_files where file_id = :clipboard_object_id and res_id = :ims_res_id select href as res_href from ims_cp_resources where res_id = :ims_res_id select parent_item from ims_cp_items where ims_item_id = :ims_item_id select distinct filename from ims_cp_files where file_id = :new_file_id select distinct pathtofile from ims_cp_files where file_id = :new_file_id select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select parent_item from ims_cp_items where ims_item_id = :ims_item_id