390081 FAAC Kit collegamento luci asta 615
zoom_out_map
chevron_left chevron_right

SPEDIZIONE GRATUITA PER ORDINI
SUPERIORI A 500E IVA INCLUSA

TUTTI I PRODOTTI SONO ORIGINALI 
 ASSISTENZA TECNICA DEDICATA

RISPARMIA KM E TEMPO
ORDINA ONLINE E RITIRA IN UNA
DELLE NOSTRE FILIALI

390081 FAAC Kit collegamento luci asta 615

Kit collegamento luci asta 615

SELECT gi.* FROM `inte_groupinc_configuration` gi WHERE (date_from <= "2024-06-20" OR CAST(date_from AS CHAR(20)) = "0000-00-00 00:00:00") AND (date_to >= "2024-06-20" OR CAST(date_to AS CHAR(20)) = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1 AND show_on_sale = 1 AND (gi.groups = "" OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.manufacturers = "" OR FIND_IN_SET(7, REPLACE(gi.manufacturers, ";", ",")) > 0) AND (gi.suppliers = "" OR FIND_IN_SET(2, REPLACE(gi.suppliers, ";", ",")) > 0) AND (gi.currencies = "" OR FIND_IN_SET(2, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(2, REPLACE(gi.languages, ";", ",")) > 0); SELECT gi.* FROM `inte_groupinc_configuration` gi WHERE (date_from <= "2024-06-20" OR CAST(date_from AS CHAR(20)) = "0000-00-00 00:00:00") AND (date_to >= "2024-06-20" OR CAST(date_to AS CHAR(20)) = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1 AND show_on_sale = 1 AND (gi.groups = "" OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.manufacturers = "" OR FIND_IN_SET(7, REPLACE(gi.manufacturers, ";", ",")) > 0) AND (gi.suppliers = "" OR FIND_IN_SET(2, REPLACE(gi.suppliers, ";", ",")) > 0) AND (gi.currencies = "" OR FIND_IN_SET(2, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(2, REPLACE(gi.languages, ";", ",")) > 0);

SCARICA L'APP SIA PER

IPHONE CHE ANDROID

Descrizione

Kit collegamento luci asta 615

Scheda tecnica

390081
Scheda tecnica
Tipo Articolo
FAAC_ST1

Accessori