Consulta complicada

[Heimish2000]

Algo así

Código MySQL:

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)