postgresql7.1
select content_template__get_root_folder()
select content_item__get_id(:url, :content_root, 'f') as item_id
select i.ims_item_id as imsitem_id from ims_cp_items_to_resources i, ims_cp_files f where f.file_id=:file_id and i.res_id=f.res_id;