CODE EXAMPLE FOR SQL

mysql delete if not in another table

DELETE b FROM BLOB b 
  LEFT JOIN FILES f ON f.id = b.fileid 
      WHERE f.id IS NULL