Mám takýto sql príkaz:
Kód: Vybrať všetko
SELECT ride.date AS date, ride.time AS time, ride.time_tenth AS time_tenth, ride.speed AS speed, model.name AS model, producer.name AS name, user.user AS user, ride.id AS ride_id, ride.user_id AS user_id, ride.vehicle_id AS vehicle_id, ride.length AS length, ride.length_id AS length_id
FROM `rides` AS ride
JOIN `vehicles` AS vehicle ON vehicle.id = ride.vehicle_id
JOIN `vehicles_producers` AS producer ON producer.id = vehicle.producer
JOIN `vehicles_models` AS model ON model.id = vehicle.model
JOIN `users` AS user ON ride.user_id = user.id
GROUP BY ride.user_id, ride.vehicle_id, ride.length, ride.length_id
ORDER BY ride.`time` ASC, ride.`time_tenth` ASCVďaka
