Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT atm.arenaTeamId, atm.guid, atm.weekGames, atm.weekWins, atm.seasonGames, atm.seasonWins, ate.type, c.name, c.class, personalRating, ate.name, cs.rating
- FROM custom_arena_season_team_member atm
- INNER JOIN arena_team ate ON atm.arenaTeamId = ate.arenaTeamId
- LEFT JOIN characters AS c ON atm.guid = c.guid
- LEFT JOIN custom_character_arena_season_stats AS cu ON atm.guid = cu.guid
- INNER JOIN custom_arena_season_team_stats cs ON atm.arenaTeamId = cs.arenaTeamId
- WHERE atm.season = 1 AND ate.type = 2
- ORDER BY cs.rating
- DESC LIMIT 50;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement