FROM t1 LEFT JOIN _marcas m on (t1.marca = m.id) LEFT JOIN _tipos t ON (t1.tipo = t.id) LEFT JOIN _categorias c ON (t.categoria = c.id ), t2 LEFT JOIN _paises p ON (t2.pais = p.id)
WHERE t1.online = 1 AND t1.activar = 1 AND t2.activar = 1 AND t1.es_desguace = '0' AND t2.id=t1.proveedor AND t.categoria = '3' AND t1.tipo = '13' AND t2.Pais = '199' AND t1.es_desguace = '0' AND t2.comprobado=1

54 Results

DYNAPAC

2005

Spain

--

CATERPILLAR

1999

Spain

--

Tampo

1990

Spain

--

INGERSOLL-RAND

2006

Spain

--

INTENSUS

2007

Spain

--

DYNAPAC

--

Spain

--

CATERPILLAR

2008

Spain

--

CATERPILLAR

2006

Spain

--

BOMAG

2006

Spain

--

SAKAI

2002

Spain

--

SAKAI

2002

Spain

--

SAKAI

2002

Spain

--

WACKER

2009

Spain

--

DYNAPAC

2006

Spain

--

CATERPILLAR

2010

Spain

--

CATERPILLAR

2013

Spain

--

CATERPILLAR

2013

Spain

--

CATERPILLAR

2012

Spain

--

HAMM

2015

Spain

--

HAMM

2015

Spain

--

HAMM

2009

Spain

--

HAMM

2009

Spain

--

Refine your search

Advertise free your used equipment, used trucks, trailers or your used farm equipment at MinuteMachine Inc.

Place an advert