Vous avez sélectionné le véhicule suivant :
Citroen C4 Berline (LC/LD) 5 portes
(11/2004 - 10/2010) 1.6 HDi 16_V 92 Kat. (90 cv) Diesel
 
Référence :
Descriptif
Descriptif

€ TTC
Quantité souhaitée :  
SELECT TOP 1 PX.*, LCLASS1.Remark AS desc1, LCLASS1.Carcode, LCLASS1.Refnumber, LCLASS1.suppliercode, prt.frp, prt.groepcode, sup.sup, prt.partcode, sup.supcode , clssup.supcode, clssup.tri80, clssup.active80 FROM PX INNER JOIN LCLASS1 ON PX.PX_CODE = LCLASS1.Refnumber AND PX.PX_MARQUE = LCLASS1.SupplierCode INNER JOIN sup ON PX.PX_MARQUE = sup.supcode INNER JOIN prt ON PX.PX_SSALDOC = prt.partcode INNER JOIN clssup ON clssup.supcode = sup.supcode WHERE (sup.Actif = '1') AND (LCLASS1.Carcode='18336') AND (PX.PX_MARQUE = 574) AND (PX.PX_CODE = '0445110239') AND (clssup.active80<>1)
Pieces autos
Sofinco

Logo PayPal standard
Pieces autos