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;