SELECT * FROM `product` WHERE product_manufacturer_id not in (SELECT id from product_manufacturer)