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 = '94' OR t1.marca = '587' OR t1.marca = '604' OR t1.marca = '6964' OR t1.marca = '7086' OR t1.marca = '7235' OR t1.marca = '7412' OR t1.marca = '9199' OR t1.marca = '9293' OR t1.marca = '9479' OR t1.marca = '9526' OR t1.marca = '9666' OR t1.marca = '9787' OR t1.marca = '9788' OR t1.marca = '9790' OR t1.marca = '9792' OR t1.marca = '9793' OR t1.marca = '9794' OR t1.marca = '9800' OR t1.marca = '9801' OR t1.marca = '9803' OR t1.marca = '9805' OR t1.marca = '9809' OR t1.marca = '9851' OR t1.marca = '9922' OR t1.marca = '9933' OR t1.marca = '9934' OR t1.marca = '9936' OR t1.marca = '9953' OR t1.marca = '9954' OR t1.marca = '9955' OR t1.marca = '10006' OR t1.marca = '10025' OR t1.marca = '10067' OR t1.marca = '10153' OR t1.marca = '10160' OR t1.marca = '10216' OR t1.marca = '10310' OR t1.marca = '10484' OR t1.marca = '10488' OR t1.marca = '10543' OR t1.marca = '10565' OR t1.marca = '10643' OR t1.marca = '10645' OR t1.marca = '10646' OR t1.marca = '10652' OR t1.marca = '10679' OR t1.marca = '10680' OR t1.marca = '10851' OR t1.marca = '10926' OR t1.marca = '10932' OR t1.marca = '10933' OR t1.marca = '11003' OR t1.marca = '11005' OR t1.marca = '11014' OR t1.marca = '11018' OR t1.marca = '11033' OR t1.marca = '11034' OR t1.marca = '11035' OR t1.marca = '11059' OR t1.marca = '11060' OR t1.marca = '11062' OR t1.marca = '11070' OR t1.marca = '11071' OR t1.marca = '11083' OR t1.marca = '11222' OR t1.marca = '11240' OR t1.marca = '11290' OR t1.marca = '11319' OR t1.marca = '11575' OR t1.marca = '11829' OR t1.marca = '11869' OR t1.marca = '12195' OR t1.marca = '12202' OR t1.marca = '12203' OR t1.marca = '12344' OR t1.marca = '12398' OR t1.marca = '12407' OR t1.marca = '12426' OR t1.marca = '12428' OR t1.marca = '12468' OR t1.marca = '12471' OR t1.marca = '12475' OR t1.marca = '12476' OR t1.marca = '12485' OR t1.marca = '12497' OR t1.marca = '12631' OR t1.marca = '23759' OR t1.marca = '23761' OR t1.marca = '23762' OR t1.marca = '23764' OR t1.marca = '23808' OR t1.marca = '23845' OR t1.marca = '23848' OR t1.marca = '23854' OR t1.marca = '23855' OR t1.marca = '23856' OR t1.marca = '23858' OR t1.marca = '23928' OR t1.marca = '23980' OR t1.marca = '24030' OR t1.marca = '24059' OR t1.marca = '24106' OR t1.marca = '24172' OR t1.marca = '24202' OR t1.marca = '24265' OR t1.marca = '24296' OR t1.marca = '24331' OR t1.marca = '243930' OR t1.marca = '243933' OR t1.marca = '243945' OR t1.marca = '243980' OR t1.marca = '243987' OR t1.marca = '243988' OR t1.marca = '243989' OR t1.marca = '243990' OR t1.marca = '243992' OR t1.marca = '243994' OR t1.marca = '244070' OR t1.marca = '244468' OR t1.marca = '244499' OR t1.marca = '244519' OR t1.marca = '244525' OR t1.marca = '244535' OR t1.marca = '244593' OR t1.marca = '244616' OR t1.marca = '244620' OR t1.marca = '244623' OR t1.marca = '244624' OR t1.marca = '244955' OR t1.marca = '245074' OR t1.marca = '245778' OR t1.marca = '245836' OR t1.marca = '248023' OR t1.marca = '248055' OR t1.marca = '248266' OR t1.marca = '248423' OR t1.marca = '248968' OR t1.marca = '250110' OR t1.marca = '250111' OR t1.marca = '250112' OR t1.marca = '250756' OR t1.marca = '251004' OR t1.marca = '251335' OR t1.marca = '251338' OR t1.marca = '251380' OR t1.marca = '251440' OR t1.marca = '251558') AND t1.es_desguace = '0' AND t2.comprobado=1
SQL MáQUINAS: SELECT STRAIGHT_JOIN t1.fecha, t1.idExt, t1.actualiza_maq, t1.promo_2,t1.promo_1,t1.proveedor,t1.id, t.txt_13 AS tipo, t1.tipo2, m.txt_int AS marca, t1.modelo, LEFT(ROUND(CONCAT(t1.año, RIGHT(t1.matriculacion, 4))),4) AS año, ROUND(t1.precio*1, 2) AS precio, t1.imagen AS imagen, t2.rutaimg, t.imagen AS imgtipo, p.id AS idpais, p.isoalpha3 AS pais, p.txt_13 AS pais_txt1, p.txt_4 AS pais_txt2, t1.es_desguace, RIGHT(t1.imagen, 1) as imagen_ord, c.subdom_13 AS subdom_cat, t.subdom_13 AS subdom_tipo, p.isoalpha2, (promo_1 OR promo_2 OR proveedor = 95) AS destacada 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 = '94' OR t1.marca = '587' OR t1.marca = '604' OR t1.marca = '6964' OR t1.marca = '7086' OR t1.marca = '7235' OR t1.marca = '7412' OR t1.marca = '9199' OR t1.marca = '9293' OR t1.marca = '9479' OR t1.marca = '9526' OR t1.marca = '9666' OR t1.marca = '9787' OR t1.marca = '9788' OR t1.marca = '9790' OR t1.marca = '9792' OR t1.marca = '9793' OR t1.marca = '9794' OR t1.marca = '9800' OR t1.marca = '9801' OR t1.marca = '9803' OR t1.marca = '9805' OR t1.marca = '9809' OR t1.marca = '9851' OR t1.marca = '9922' OR t1.marca = '9933' OR t1.marca = '9934' OR t1.marca = '9936' OR t1.marca = '9953' OR t1.marca = '9954' OR t1.marca = '9955' OR t1.marca = '10006' OR t1.marca = '10025' OR t1.marca = '10067' OR t1.marca = '10153' OR t1.marca = '10160' OR t1.marca = '10216' OR t1.marca = '10310' OR t1.marca = '10484' OR t1.marca = '10488' OR t1.marca = '10543' OR t1.marca = '10565' OR t1.marca = '10643' OR t1.marca = '10645' OR t1.marca = '10646' OR t1.marca = '10652' OR t1.marca = '10679' OR t1.marca = '10680' OR t1.marca = '10851' OR t1.marca = '10926' OR t1.marca = '10932' OR t1.marca = '10933' OR t1.marca = '11003' OR t1.marca = '11005' OR t1.marca = '11014' OR t1.marca = '11018' OR t1.marca = '11033' OR t1.marca = '11034' OR t1.marca = '11035' OR t1.marca = '11059' OR t1.marca = '11060' OR t1.marca = '11062' OR t1.marca = '11070' OR t1.marca = '11071' OR t1.marca = '11083' OR t1.marca = '11222' OR t1.marca = '11240' OR t1.marca = '11290' OR t1.marca = '11319' OR t1.marca = '11575' OR t1.marca = '11829' OR t1.marca = '11869' OR t1.marca = '12195' OR t1.marca = '12202' OR t1.marca = '12203' OR t1.marca = '12344' OR t1.marca = '12398' OR t1.marca = '12407' OR t1.marca = '12426' OR t1.marca = '12428' OR t1.marca = '12468' OR t1.marca = '12471' OR t1.marca = '12475' OR t1.marca = '12476' OR t1.marca = '12485' OR t1.marca = '12497' OR t1.marca = '12631' OR t1.marca = '23759' OR t1.marca = '23761' OR t1.marca = '23762' OR t1.marca = '23764' OR t1.marca = '23808' OR t1.marca = '23845' OR t1.marca = '23848' OR t1.marca = '23854' OR t1.marca = '23855' OR t1.marca = '23856' OR t1.marca = '23858' OR t1.marca = '23928' OR t1.marca = '23980' OR t1.marca = '24030' OR t1.marca = '24059' OR t1.marca = '24106' OR t1.marca = '24172' OR t1.marca = '24202' OR t1.marca = '24265' OR t1.marca = '24296' OR t1.marca = '24331' OR t1.marca = '243930' OR t1.marca = '243933' OR t1.marca = '243945' OR t1.marca = '243980' OR t1.marca = '243987' OR t1.marca = '243988' OR t1.marca = '243989' OR t1.marca = '243990' OR t1.marca = '243992' OR t1.marca = '243994' OR t1.marca = '244070' OR t1.marca = '244468' OR t1.marca = '244499' OR t1.marca = '244519' OR t1.marca = '244525' OR t1.marca = '244535' OR t1.marca = '244593' OR t1.marca = '244616' OR t1.marca = '244620' OR t1.marca = '244623' OR t1.marca = '244624' OR t1.marca = '244955' OR t1.marca = '245074' OR t1.marca = '245778' OR t1.marca = '245836' OR t1.marca = '248023' OR t1.marca = '248055' OR t1.marca = '248266' OR t1.marca = '248423' OR t1.marca = '248968' OR t1.marca = '250110' OR t1.marca = '250111' OR t1.marca = '250112' OR t1.marca = '250756' OR t1.marca = '251004' OR t1.marca = '251335' OR t1.marca = '251338' OR t1.marca = '251380' OR t1.marca = '251440' OR t1.marca = '251558') AND t1.es_desguace = '0' AND t2.comprobado=1 ORDER BY destacada DESC, modelo ASC, t1.activar DESC, t2.id = 95 DESC, actualiza_maq DESC, fecha DESC, t2.comprobado DESC, imagen_ord DESC, t1.promo_1 DESC, t2.conADT DESC, t1.id DESC LIMIT 0, 22

2561 النتائج

IVECO

2011

Spain

--

IVECO

2007

Spain

--

IVECO

2001

Spain

--

IVECO

2001

Spain

--

IVECO

1997

Spain

--

IVECO

2001

Spain

--

IVECO

2005

Spain

--

IVECO

2004

Spain

--

IVECO

2004

Spain

--

بحث أكثر تفصيلا

قم بالدعاية لماكيناتك، شاحناتك و/ أو تجهيزاتك الزراعية مجاناً في MinuteMachine

ضع إعلانك