INSERT INTO guild_top10 (guild_name,guild_realm,guild_region,guild_faction,guild_score)
SELECT v1.character_guild,v1.character_realm,v1.character_region,v1.character_faction
, SUM(v1.character_level) total
FROM (
SELECT t1.character_name
, t1.character_faction
, t1.character_realm
, t1.character_region
, t1.character_guild
, t1.character_level
, COUNT(t2.character_hash) cnt
FROM armory_ranking t1
LEFT JOIN armory_ranking t2
ON (t1.character_level,t1.character_hash) <= (t2.character_level,t2.character_hash)
AND t1.character_guild = t2.character_guild
WHERE t1.character_guild <> ''
GROUP BY t1.character_hash
HAVING cnt <= 25
) v1
GROUP BY v1.character_guild
ORDER BY total DESC
LIMIT 10