Edit History

On 4/21/2020 at 12:11 AM, Gipielle said:

Hello, this query is for all prestashop versions ?

I ps 1.7 replace ps_ by miib_

DELETE FROM`miib_category`  WHERE   `id_category` != 1   and  id_category not in    (SELECT cp.id_category from  miib_category_product cp ) ;
DELETE FROM `miib_category_lang` where id_category not in (select id_category from miib_category);
DELETE FROM `miib_category_group` where id_category not in (select id_category from miib_category);
DELETE FROM `miib_category_shop` where id_category not in (select id_category from miib_category);