/* Selects scan table entries where there is no hit. NORMAL condition */
USE setine5_seti
SELECT * FROM scans WHERE NOT EXISTS (SELECT * FROM hits WHERE hits.Scan_ID = scans.Scan_ID  )