prestashop: clean database

DELETE w
FROM
product_shop w
LEFT JOIN product e ON w.id_product = e.id_product
WHERE
e.id_product IS NULL

 

DELETE w
FROM
product_lang w
LEFT JOIN product e ON w.id_product = e.id_product
WHERE
e.id_product IS NULL

Leave a Reply

Your email address will not be published. Required fields are marked *