softwareheritage=> select target, discovery_date from raw_extrinsic_metadata rem where not exists (select 1 from raw_extrinsic_metadata_new remn where date_trunc('second', remn.discovery_date) = date_trunc('second', rem.discovery_date) and remn.target = case when rem.target LIKE 'swh:1:%' then rem.target else 'swh:1:ori:' || encode(digest(rem.target, 'sha1'), 'hex') end) order by target;