select distinct crftd.path, crftd.storage_area_key from cr_files_to_delete crftd where not exists (select 1 from cr_revisions r where r.content = crftd.path) delete from cr_files_to_delete