thumann

SELECT character_guild,character_realm,character_region,sum(character_level) as guild_totalFROM `armory_ranking`WHERE character_guild != ''GROUP BY character_guildORDER BY guild_total DESCLIMIT 10