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

28 查询结果

OTROS/OTHER/ANDERE

1991

Germany

--

MaKinor

2014

Spain

--

JOHN DEERE

1987

France

--

New Holland

2002

Germany

--

KUBOTA

--

United States

--

KUBOTA

--

United States

--

JOHN DEERE

--

United States

--

JOHN DEERE

1998

United States

--

JOHN DEERE

1998

United States

--

JOHN DEERE

2001

United States

--

JOHN DEERE

2003

United States

--

CUBA DE CEMENTO

2003

United States

--

CUBA DE CEMENTO

2007

United States

--

CUBA DE CEMENTO

2008

United States

--

CUBA DE CEMENTO

2005

United States

--

CUBA DE CEMENTO

2008

United States

--

CUBA DE CEMENTO

2000

United States

--

CUBA DE CEMENTO

1998

United States

--

TORO

2007

United States

--

JOHN DEERE

2007

United States

--

JOHN DEERE

1998

United States

--

JOHN DEERE

1998

United States

--

优化您的搜索

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

放置广告