sql

SELECT * FROM oc_product p LEFT JOIN oc_product_to_category p2c ON p.product_id = p2c.product_id WHERE p2c.product_id IS NULL