I'm using this:

SELECT * FROM manufacturers LEFT JOIN products ON manufacturers.manufacturers_id = products.manufacturers_id WHERE products.manufacturers_id IS NULL
How can I delete the records returned?