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.

Autocolante / Design

-55%

Mopar

REDUCERE

[5KC94GX9AA]

Mopar "Sport" Decal for Jeep Vehicles

Mopar "Sport" Decal for Jeep Vehicles

723,00 lei

327,25 lei

in stoc

-46%

Mopar

REDUCERE

[55397276AA]

Mopar "Sahara" Decal for Jeep Vehicles

Mopar "Sahara" Decal for Jeep Vehicles

605,00 lei

327,25 lei

in stoc

-47%

Mopar Jeep Lettering for 97-06 Jeep Wrangler TJ & Unlimited

REDUCERE

[5FC84HA9AB]

Mopar Jeep Lettering for 97-06 Jeep Wrangler TJ & Unlimited

Mopar Jeep Lettering for 97-06 Jeep Wrangler TJ & Unlimited

509,00 lei

267,75 lei

in stoc

-53%

Mopar

REDUCERE

[1FN59GX9AC]

Mopar "Wrangler Unlimited" Decal for Jeep Vehicles

Mopar "Wrangler Unlimited" Decal for Jeep Vehicles

382,00 lei

178,50 lei

in stoc

-25%

Mopar

REDUCERE

[5JC82CA1AA]

Mopar "Rubicon" Hood Decal for 07-18 Jeep Wrangler JK

Mopar "Rubicon" Hood Decal for 07-18 Jeep Wrangler JK

459,00 lei

345,10 lei

in stoc

-50%

REDUCERE

[12999.18]

Sticker Decal, Alloy USA Logo

Decal, Alloy USA Logo These custom vinyl decals have the Alloy USA logo and can be applied to any clean smooth surface for the perfect look. Main Features This vinyl decal is custom cut with the Alloy USA logo. These custom vinyl decals have the Rugged Ridge logo and can be applied to any clean smooth surface for the perfect look. Black Vinyl Easy to apply[...]

12,00 lei

5,95 lei

in stoc

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("565", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=166 )

; 
	
	
	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("565", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=181 )

; 
	
	
	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("565", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=187 )

; 
	
	
	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("565", 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("565", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=238 OR p.cod_producator=181 )   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("565", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=238 OR p.cod_producator=181 )   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("565", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=238 OR p.cod_producator=181 )   AND ( lichidare_stoc=1)

;