.png.022b5452a8f28f552bc9430097a16da2.png)
-- insert ignore into ps_category_shop
select c.id_category, s.id_shop, 1
from ps_category c
inner join ps_shop s on 1=1
where c.id_parent != 0
NON testé, FAIRE un BACKUP de la table avant
Edit History
-- insert ignore into ps_category_shop
select c.id_category, s.id_shop, 1
from ps_category c
inner join ps_shop s on 1=1
where c.parent != 0
NON testé, FAIRE un BACKUP de la table avant