Consulta complicada

[korshack]

He añadido el group by para que me muestre solo 1 vez pero me coge la imagen con orden 1 no la mas grande, que raro.

SELECT *
FROM autos A
INNER JOIN marcas M ON A.id_marca = M.id_marca
INNER JOIN imagenes I ON I.id_vehiculo = A.id
WHERE I.ID_VEHICULO IN (
SELECT A.id_Vehiculo FROM (
SELECT id_Vehiculo, max(orden) AS ORD
FROM Imagenes
GROUP BY id_vehiculo) AS A)
GROUP BY A.id