# Pastebin vsNJdPxJ
SELECT gid
     FROM recording r
LEFT JOIN mapping.mbid_mapping mm ON r.gid = mm.recording_mbid
LEFT JOIN mapping.canonical_recording cr ON r.gid = cr.recording_mbid
    WHERE mm.recording_mbid IS NULL
      AND cr.recording_mbid IS NULL;