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 = '46' OR t1.marca = '74' OR t1.marca = '507' OR t1.marca = '531' OR t1.marca = '606' OR t1.marca = '7082' OR t1.marca = '7727' OR t1.marca = '7875' OR t1.marca = '7925' OR t1.marca = '7952' OR t1.marca = '8119' OR t1.marca = '8788' OR t1.marca = '9247' OR t1.marca = '9589' OR t1.marca = '9670' OR t1.marca = '9718' OR t1.marca = '9727' OR t1.marca = '9744' OR t1.marca = '10058' OR t1.marca = '10102' OR t1.marca = '10378' OR t1.marca = '10519' OR t1.marca = '10983' OR t1.marca = '11002' OR t1.marca = '11372' OR t1.marca = '11449' OR t1.marca = '11571' OR t1.marca = '11746' OR t1.marca = '12402' OR t1.marca = '12599' OR t1.marca = '12608' OR t1.marca = '23671' OR t1.marca = '24100' OR t1.marca = '24184' OR t1.marca = '24277' OR t1.marca = '244150' OR t1.marca = '244152' OR t1.marca = '244539' OR t1.marca = '244546' OR t1.marca = '244958' OR t1.marca = '244977' OR t1.marca = '245108' OR t1.marca = '245139' OR t1.marca = '245262' OR t1.marca = '245267' OR t1.marca = '245825' OR t1.marca = '246874' OR t1.marca = '247977' OR t1.marca = '247991' OR t1.marca = '248010' OR t1.marca = '248018' OR t1.marca = '248136' OR t1.marca = '248202' OR t1.marca = '248238' OR t1.marca = '248245' OR t1.marca = '248557' OR t1.marca = '248686' OR t1.marca = '248704' OR t1.marca = '248740' OR t1.marca = '248827' OR t1.marca = '248846' OR t1.marca = '248940' OR t1.marca = '248996' OR t1.marca = '249173' OR t1.marca = '249344' OR t1.marca = '249393' OR t1.marca = '249647' OR t1.marca = '249733' OR t1.marca = '250065' OR t1.marca = '250070' OR t1.marca = '250071' OR t1.marca = '250176' OR t1.marca = '250211' OR t1.marca = '250219' OR t1.marca = '250227' OR t1.marca = '250273' OR t1.marca = '250596' OR t1.marca = '250685' OR t1.marca = '250705' OR t1.marca = '250715' OR t1.marca = '250837' OR t1.marca = '250918' OR t1.marca = '250999' OR t1.marca = '251048' OR t1.marca = '251112' OR t1.marca = '251132' OR t1.marca = '251215' OR t1.marca = '251305' OR t1.marca = '251475' OR t1.marca = '251557' OR t1.marca = '251596') AND t1.es_desguace = '0' AND t2.comprobado=1

300 查询结果

TEREX

2003

Spain

--

BENFORD-TEREX

2000

United Kingdom

--

TEREX

1996

United Kingdom

--

BENFORD-TEREX

2002

United Kingdom

16 €

BENFORD-TEREX

1998

United Kingdom

4.682 €

TEREX

2005

Germany

5.100 €

Terex

2007

United Arab Emirates

5.500 €

BENFORD-TEREX

2000

United Kingdom

8.212 €

TEREX

2004

Spain

8.900 €

BENFORD-TEREX

2003

Spain

9.500 €

TEREX

2004

Spain

10.000 €

TEREX

2004

Spain

11.000 €

TEREX

2005

Spain

12.000 €

BENFORD-TEREX

2005

Spain

12.000 €

TEREX

2005

Spain

12.000 €

TEREX

1998

Italy

12.800 €

TEREX

2004

Ireland

16.000 €

TEREX

2004

Ireland

16.000 €

优化您的搜索

在MinuteMachine公布您的设备,运输车和/或农业设备

放置广告