ALEGE MASINA
marca:
model:
motorizare:
CATEGORII COMPLEMENTARE
Kit de conversie ambreajLimitator de varfuri de cupluri ambreiaj
Scule
Carcasa ambreiaj
Garnituri/set garnituri
amortizor torsiune
Ambreiaj automat
Filtru hidraulic ambreiaj
Comanda ambreiaj
Rulment priza directa
Volanta
Rulment de presiune ambreiaj
Disc ambreiaj
Placa de presiune ambreiaj
Set reparatie amreiaj complet
PRODUSE UNIVERSALE
SET REPARATIE AMBREIAJ COMPLET pentru SEAT IBIZA V ST (6J8, 6P8) 1.2
« INAPOI LA LISTA DE CATEGORIIcore_mysql (error no: 1064) : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
SELECT *,`art_id`, `art_sup_id`, `art_des_id`, `art_complete_des_id`, IFNULL((SELECT `arl_search_number` FROM `tecdoc_tof_art_lookup` WHERE `arl_art_id` = `art_id` AND `arl_kind` = "3" LIMIT 1), "") AS `oe`, IFNULL((SELECT GROUP_CONCAT(DISTINCT `arl_search_number` SEPARATOR ", ") FROM `tecdoc_tof_art_lookup` WHERE `arl_art_id` = `art_id` AND `arl_kind` = "3"), "") AS `oeFull` FROM `tecdoc_tof_articles` l, `piese-masinaro`.sh_products s WHERE s.productId = l.art_id AND `art_id` IN (68,68,68,68,68,68) AND