select mime_type from cr_revisions where revision_id = :version_id select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select pathtofile as file_href from ims_cp_files where file_id = :file_id and res_id = :res_id select filename as file_name from ims_cp_files where file_id = :file_id and res_id = :res_id select href as res_href from ims_cp_resources where res_id = :res_id