Script para activar productos en opencart

[sysme]

Ejecuta estos scripts uno a uno:

delete from opencart_comg;
insert into opencart_comg (id_opencart,id_complementog) select 1,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 2,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 3,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 4,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 5,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 6,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 7,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 8,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 9,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 10,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";
insert into opencart_comg (id_opencart,id_complementog) select 1,id_complementog from complementog where cafeteria = "S" and sincopencart = "Y";