QRY:SELECT a.ID, HEX(a.name) as name, a.last_cc, s.rating, s.games, s.wins, s.losses, s.draws, s.streak_highest, s.kills, s.deaths, s.assists, s.disconnects FROM g1.stats s, client_accounts a WHERE s.roomid=20 AND s.uid = a.ID ORDER BY s.rating DESC