Сортировка значений в указанном временном диапазоне

SELECT cc.rank_cmd, cc.value_cmd_time, cc.rank_ct, cc.value_ct_time, cc.rank_t, cc.value_t_time FROM 
(
    SELECT @i:=@i+1 as rank_cmd, value_cmd_time, rank_ct, value_ct_time, rank_t, value_t_time, steamid FROM 
    (
        SELECT * FROM 
        (
            SELECT value_cmd_time, @j:=@j+1 as rank_ct, value_ct_time, rank_t, value_t_time, steamid FROM
            (
                SELECT * FROM 
                (
                    SELECT value_cmd_time, value_ct_time, @k:=@k+1 as rank_t, value_t_time, c.steamid FROM
                    (   
                        SELECT steamid, SUM(cmd_time) value_cmd_time, SUM(ct_time) value_ct_time, SUM(t_time) value_t_time
                        FROM `227_27015`
                        GROUP BY steamid
                        ORDER BY 4 DESC
                    ) c,(select @i:=0, @j:=0, @k:=0) AS z
                ) c2
                    ORDER BY c2.value_ct_time DESC
            ) c3
        ) c4
            ORDER BY c4.value_cmd_time DESC
    ) c5
) cc
WHERE cc.steamid='[U:1:389529288]'