Problem with ORDER BY

[Martin Venuš]

Hi,

I have a big problem with ordering records.

SQL QUERY:
SELECT sum(
CASE WHEN hodnota =1
THEN allxx
ELSE 0
END ) AS hodnotaxxx, (
sum( allxx ) + sum( allx )
) AS complete, number
FROM tablex
WHERE hodnota <=4
AND (
number =95
OR number =58
)
GROUP BY number
ORDER BY complete, hodnotaxxx, number

and result:
http://www.gymck.cz/~venus/mysql/ (here you can see table properties and data)

The problem is that it sort data only by first argument (in this - only by complete) and the second argument (in this - hodnotaxxx) is ignore. I don´t know why.

Thank you for your help.

Martin