I found below query in another forum:
Code:
/*
* Count total monster spawn categorized by level
* Witchy Moo, 20150622
*/
use sro_vt_shard
SELECT d.CodeName128 AS 'Monster Code', e.Lvl AS 'Level', SUM(a.dwMaxTotalCount) AS 'Max Spawn'
FROM Tab_RefNest a
INNER JOIN Tab_RefTactics b ON a.dwTacticsID = b.dwTacticsID
JOIN Tab_RefHive c ON a.dwHiveID = c.dwHiveID
JOIN _RefObjCommon d ON b.dwObjID = d.ID
JOIN _RefObjChar e ON d.Link = e.ID
JOIN _RefRegion f ON a.nRegionDBID = f.wRegionID
WHERE d.Rarity IN (0,6) -- Only select Regular and Elite, add 3,8 for uniques
AND f.ContinentName NOT LIKE 'GOD_TOGUI' -- Not including FGW monsters
AND (d.[Service] = 1 AND d.Codename128 LIKE 'MOB_%' AND d.Codename128 NOT LIKE 'MOB_GOD_%') -- Not including FGW monsters
GROUP BY d.CodeName128, e.Lvl, d.Rarity ORDER BY e.Lvl ASC
You can copy the result into excel and calculate mobs as you need. With my test database I got:
Code:
3506 4003 4436 524 3768 5851 1967 1171 1575 3722 5225 2319 6248 2303 46618
AM CA CH DH EU JU KK KT OA RM SD TK TQ WC