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 (t1.marca = '1374' OR t1.marca = '8793' OR t1.marca = '9268' OR t1.marca = '9274' OR t1.marca = '9961' OR t1.marca = '12245' OR t1.marca = '23873' OR t1.marca = '23875' OR t1.marca = '248735' OR t1.marca = '250415' OR t1.marca = '251618' OR t1.marca = '251652') AND t1.es_desguace = '0' AND t2.comprobado=1

53 Results

METSO

--

Netherlands

--

METSO

--

Netherlands

--

METSO

--

Netherlands

--

METSO

--

Netherlands

--

METSO

--

Netherlands

--

METSO

--

Netherlands

--

METSO

--

Netherlands

--

METSO

--

Netherlands

--

METSO

2019

Germany

--

METSO

2019

Germany

--

Metso/Nordberg

2014

Italy

155.000 €

Metso/Faço

1997

Germany

--

METSO

2008

Germany

62.000 €

METSO

1995

France

--

METSO

2004

United Kingdom

--

METSO

2007

United Kingdom

--

METSO

2006

United Kingdom

--

METSO

2006

United Kingdom

--

METSO

2005

United Kingdom

--

METSO

2005

United Kingdom

--

METSO

1980

Germany

--

METSO

1980

Germany

--

Refine your search

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

Place an advert