[Праведник]

SELECT at.name, ats.rating

FROM arena_team at

INNER JOIN arena_team_stats ats ON at.arenateamid = ats.arenateamid

ORDER BY ats.rating DESC 

LIMIT 0  5