ORDER BY Problem

[Thomas Rushworth]

The column duration in the reports table is type = time. The following query produces the results below it. My question is why does the 9th entry appear where it does? Or better yet, How can I get it to sort "correctly?" That's "correctly" by my understanding, not necessarily SQL's. :)


SELECT a.pilot_num AS Pilot,
sec_to_time(sum(time_to_sec(b.duration))) AS Duration
FROM pilots AS a, reports AS b
WHERE a.pilot_id = b.pilot_id AND month(now())=month(b.date) AND year(now()) = year(b.date)
GROUP BY Pilot
ORDER BY Duration DESC
LIMIT 10


Pilot Duration
CAA165 79:27:00
CAA148 65:53:00
CAA001 31:07:00
CAA170 19:13:00
CAA131 16:29:00
CAA142 14:56:00
CAA183 14:37:00
CAA156 12:06:00
CAA161 115:06:00
CAA071 10:50:00