top3.sql

SELECT
    me.wins, rel_user.nick
FROM
    users_games me
JOIN
    users rel_user ON rel_user.id = me.user
WHERE
    me.game=1
    AND ( wins IN ( SELECT me.wins FROM users_games me WHERE me.game=1 GROUP BY me.wins ORDER BY wins DESC LIMIT 3 ) )
ORDER BY
    wins DESC

wins        nick      
----------  ----------
2           grifferz  
1           zuzak     
1           popey     
1           dave2     
0           dominic   
0           ziphy     
0           tolien    
0           tommy     
0           dutchie   
0           plett     
0           daviey    
0           prando    
0           dg        
0           filbert   
0           paul      
0           taras     

SELECT
    me.wins, rel_user.nick
FROM
    users_games me
JOIN
    users rel_user ON rel_user.id = me.user
WHERE
    me.game=1
    AND ( wins IN ( SELECT me.wins FROM users_games me WHERE me.game=1 ORDER BY wins DESC LIMIT 3 ) )
ORDER BY
    wins DESC

wins        nick      
----------  ----------
2           grifferz  
1           zuzak     
1           popey     
1           dave2