Ordenar por:
SELECT c.id id,c.descripcion descripcion, i.src image FROM cars c INNER JOIN images i ON c.id = i.car_id WHERE c.eliminado = 0 AND ((c.condicion = "nuevo" AND i.main = 1) OR (c.condicion = "usado" AND i.main_used = 1)) ORDER BY c.id desc LIMIT 0, 18

Hyundai Creta 2018 0km

Llego a Motorland la Maxima Potencia y Fuerza! Amarok V6!

FORD RANGER LIMITED FULL 0KM

FORD RANGER LIMITED FULL 0KM

PEUGEOT 3008 ACTIVE OKM AUT DIESEL

PEUGEOT 208 MEC NAFTERO 0KM

LA PEUGEOT DEL MOMENTO

VW AMAROK POTENCIA CONFORT Y ECONOMÍA

ECOSPORT AUT 2018