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 = '5' AND t1.tipo = '61' AND t1.es_desguace = '0' AND t2.comprobado=1

101 Results

CFBK

--

France

--

ABG

--

France

--

CFBK

--

France

--

CFBK

--

France

--

Metso/Nordberg

2014

Italy

155.000 €

SVEDALA

2014

Netherlands

--

Sandvik Aubema

2008

Germany

--

SVEDALA

2005

Romania

100.000 €

KRUPP

2001

Germany

--

SVEDALA

1999

Germany

--

METSO

2008

Germany

62.000 €

KRUPP

1985

Germany

--

NORDBERG

2008

Germany

--

SYMONS

1990

Portugal

--

1970

Germany

--

METSO

1980

Germany

--

METSO

1991

Germany

--

SVEDALA

1993

Netherlands

--

SVEDALA

1992

Netherlands

--

SYMONS

1998

United States

60.748 €

Allis-Chalmers

1990

United States

31.064 €

Allis-Chalmers

1990

United States

31.064 €

Refine your search

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

Place an advert