问mysql:查询返回分数，按特定用户排列。

EN

rank userid score
---- ------ -----
 1   |455   |10
 2   |435   |9
 3   |354   |8
 4   |342   |7
 5   |343   |6
 6   |123   |5
 7   |125   |4
 8   |128   |3
 9   |5     |2
10   |6     |1

@rank:=0;

select @rank:=@rank+1 as rank,userid,score from (
select * from (
   select game_log_gameid as gameid,
   game_log_userid as userid,
(select max(game_score_log_score)
        from game_score_log where game_score_log_logid=game_log_id) as score,
        (select game_score_log_timestamp as time from
            game_score_log where game_score_log_logid=game_log_id and
            game_score_log_score = score order by game_score_log_timestamp desc)
            as time from game_log
where game_log_gameid=620
order by score desc,time
) as a group by gameid,userid ) as b order by score desc,time