IMPORTANT! Pentru a îmbunătăţi relaţia cu tine acest site foloseşte cookie-uri (eng. cookies).
Pentru mai multe detalii apasă aici. Dacă esti de acord cu acest lucru atunci poti [x] închide acest avertisment.

Filtre

Producător

FK Automotive (4)

SCHROTH Racing (4)

Listă produse

Centuri

Set PAD-uri pentru Centuri FK Rosii

[FKGP023]

Set PAD-uri pentru Centuri FK Rosii

Set PAD-uri pentru Centuri FK Rosii more comfortable to drive despite high security great look Color: racing red

34,41 lei

livrare 5-7 zile

-38%

Set PAD-uri pentru Centuri FK Albastre

REDUCERE

[FKGP019]

Set PAD-uri pentru Centuri FK Albastre

Set PAD-uri pentru Centuri FK Albastre more comfortable to drive despite high security great look Color: blue racing

31,00 lei

19,12 lei

in stoc

Centura FK Universala in 3 puncte

[FKHTR 011007/011009/011011]

Centura FK Universala in 3 puncte

Centura FK Universala in 3 puncte No matter how much you love your car, when it comes on track, the most important thing is nothing but still you, the driver! For increased safety and better driving comfort, we recommend our racing and harness belts. Its useless when the car is doing the best performance in the asphalt and sleek curves, but the driver doesnt feel any sense of secu[...]

184,80 lei

livrare 5-7 zile

Centura FK UNIVERSALA in 4 puncte

[FKHTR 011001/011005]

Centura FK UNIVERSALA in 4 puncte

Centura FK Universala in 4 puncte No matter how much you love your car, when it comes on track, the most important thing is nothing but still you, the driver! For increased safety and better driving comfort, we recommend our racing and harness belts. Its useless when the car is doing the best performance in the asphalt and sleek curves, but the driver doesnt feel any sense of secu[...]

184,80 lei

livrare 5-7 zile

SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=262 )

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=263 )

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=192 )

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=238 )

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=262 ) AND ( nou=1)

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=262 ) AND ( promotional=1)

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=262 ) AND ( lichidare_stoc=1)

;