Složité řazení

<?php

include("db.php");

$connect = MySQL_PConnect($cfg['MySQL_Server'], $cfg['MySQL_User'], $cfg['MySQL_Passwd']);
if (!$connect)
{
    print 'Pripojen? k MySQL se nezdarilo!!';
    exit;
}
MySQL_Select_DB($cfg['MySQL_DB']);
@mysql_query("SET NAMES utf8");
 
$chr_tmp = "CREATE temporary TABLE chr_tmp AS
  SELECT chr.user_id,
         chr.exercise_id,
         CASE
           WHEN e.type = 'number' THEN Cast(chr.value AS SIGNED INTEGER)
           WHEN e.type = 'float' THEN Cast(REPLACE(chr.value, ',', '.') AS SIGNED)
           WHEN e.type = 'time' THEN Time_to_sec(Cast(chr.value AS time))
         END * CASE
                 WHEN e.order_num = 'ASC' THEN -1
                 WHEN e.order_num = 'DESC' THEN 1
               END value
  FROM   challenge_result chr
         JOIN registration reg
           ON chr.user_id = reg.user_id
              AND reg.category_id = 11
         JOIN exercise e
           ON chr.exercise_id = e.id
  WHERE  exercise_id IN ( 32 )";  
  
$vysledek = mysql_query($chr_tmp) or die(mysql_error());  
 
$chr_tmp2 = "CREATE temporary TABLE chr_tmp2
  (INDEX pomocny_index (exercise_id, value)) AS
  SELECT * FROM chr_tmp";
$vysledek = mysql_query($chr_tmp2) or die(mysql_error());    
 
$query = mysql_query("SELECT t3.*,
       users.first_name
FROM   (SELECT user_id,
               Sum(poradi) soucet,
               Count(*)    kategorii
        FROM   (SELECT t1.user_id,
                       exercise_id,
                       (SELECT Count(*) + 1
                        FROM   chr_tmp2 t2
                        WHERE  t2.exercise_id = t1.exercise_id
                               AND t2.value < t1.value) poradi
                FROM   chr_tmp t1) r
        GROUP  BY user_id) t3
       JOIN users
         ON t3.user_id = users.id
ORDER  BY soucet,
          kategorii DESC"); 
          
$vysledek = mysql_query($query)or die(mysql_error());    
          

 ?>