ALEGE MASINA

marca:

model:

motorizare:

CATEGORII COMPLEMENTARE

Suport ax / Lonjeron sasiu
Suport ax
Corp ax

http://catalog.polcar.com NOU ! CATALOG POLCAR
Ca alternativa , poti cauta piesa de care ai nevoie in CATALOGUL POLCAR , de unde trebuie retinut codul piesei din catalog si completat la rubrica ”CAUTARE DUPA COD” , amplasata in partea dreapta , pentru a vedea preturi.

PRODUSE UNIVERSALE

ACUMULATOARE Vehicule Lubrifianti Autoturisme

SUPORT AX pentru AUDI 100 (44, 44Q, C3) 2.0 KAT

« INAPOI LA LISTA DE CATEGORII

core_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 (2508779,2508779) AND