ALEGE MASINA
marca:
model:
motorizare:
CATEGORII COMPLEMENTARE
Traductor de presiuneScule
Generator gaze
Supape/Ansamblu supape
Unitate de control
Senzor / Sonda
Comutator/ Releu
Set reparatie
Debitmetru aer
Control mers in gol
conducta combustibil / conducta distrib. aliment. / aliment.
Pompa injectie combustibil, pompa inalta presiune
Cabluri/Legaturi
Pedala acceleratie
Componente injector/ Diuze
injector / duza injectie / tija injector
Pompa de injectie
acumulator de presiune
Clapeta de trecere / Conducte combustibil / Conducta vacuum
Garnitur pompa apa
Parghie oprire
PRODUSE UNIVERSALE
SENZOR / SONDA pentru RENAULT 19 I Chamade (L53_) 1.7 (L53C)
« 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 (3185725,3185725) AND