[SQL] pobierz, plaintext 
SELECT contest_mic.id_robot, contest_mic.time_round_1, contest_mic.time_round_2, contest_mic.time_round_3, MIN(contest_mic.time_round_1) AS min_time, MIN(contest_mic.time_round_2) AS min_time, MIN(contest_mic.time_round_3) AS min_time, robots.name FROM `contest_mic` INNER JOIN `robots` ON robots.id = contest_mic.id_robot WHERE `time_round_1` != "00:00:00" OR `time_round_2` != "00:00:00" OR `time_round_3` != "00:00:00" AND EXISTS (SELECT `id` FROM `robots` WHERE robots.id = contest_mic.id_robot AND `status`=1) GROUP BY contest_mic.id_robot ORDER BY `min_time` DESC
[SQL] pobierz, plaintext