select cri.content_type, cri.name from cr_items cri, cr_revisions crr where cri.item_id = crr.item_id and crr.revision_id = :revision_id select crf.folder_id from cr_folders crf where crf.label = :content_type||'_'||:package_id