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

Smittybilt (3)

Listă produse

Kit-uri Supravietuire / Truse Prim Ajutor

[SB2833]

Maceta SMITTYBILT - 48 cm

Maceta SMITTYBILT - 48 cm Trail machete SMITTYBILT blade lenght: 35cm overall lenght: 48cm stainless steel blade finished in electric black oxide composite plastic TPR non-slip handle saw for cutting wood black nylon sheath roll bar straps for mounting to roll bar

301,86 lei

in stoc

Vezi detalii

[SB2829]

Set Multi Tool 10-in-1 SMITTYBILT

Set Multi Tool 10-IN-1 SMITTYBILT Multi Pliers Smittybilt 10 in 1, multi Compact tool made of stainless steel heat treated Steel blade this tool has everything you need while you are camping or offroading ballistic Nylon carrying case included

191,00 lei

in stoc

Vezi detalii

[SB2828]

Topor / Tomahawk Multifunctional cu Kit Supravietuire si Busola SMITTYBILT

Topor / Tomahawk Multifunctional cu Kit Supravietuire si Busola SMITTYBILT Tomahawk - Trail Axe multifunction Smittybilt stainless blade blade sheath tool to adjust trail jack tool to adjust bumper shackles compass built into the handle medical patch, needle, thread built into into the handle

388,53 lei

in stoc

Vezi detalii

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

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

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

AND ( lichidare_stoc=1)

;