SELECT * FROM oc_product p
LEFT JOIN oc_product_to_store p2c ON (p.product_id = p2c.product_id and p2c.store_id=0)
WHERE p2c.product_id IS NULL
SELECT * FROM oc_product p
LEFT JOIN oc_product_to_store p2c ON (p.product_id = p2c.product_id and p2c.store_id=0)
WHERE p2c.product_id IS NULL