Freelancer:
DurEAyat
MYSQL query
SELECT *, MAX(time) FROM Positions a WHERE a.speed > 5 GROUP BY a.vehicle_id HI, it's hard to test query without data. But I request you please test this query. I hope it returns the same results you want