SELECT character_guild,character_realm,character_region,sum(character_level) as guild_total
FROM `armory_ranking`
WHERE character_guild != ''
GROUP BY character_guild
ORDER BY guild_total DESC
LIMIT 10