aggregate functions not allowed in order by clause on some dbmses

SELECT new com.atlassian.bamboo.utils.Pair(tcr.testCase.id, count) FROM TestCaseResultImpl tcr
WHERE tcr.testCase.testClass.plan = :plan
AND tcr.state = 'FAILED'
group by tcr.testCase.id
order by count desc

This query fails on MySQL 4.1, it does not allow count in "order by" clause. All possibly affected queries have to be converted.