[HIDE]
[/HIDE]
Kod:
USE SRO_VT_SHARD
SELECT
a.nRegionDBID AS 'Region ID',
f.ContinentName AS 'Continent Name',
d.CodeName128 AS 'Monster Code',
e.Lvl AS 'Level',
d.Rarity AS 'Rarity',
SUM(a.dwMaxTotalCount) AS 'Max Spawn',
a.dwMaxTotalCount AS 'Total Max Count',
a.nRadius AS 'Spawn Radius',
a.nGenerateRadius AS 'Generate Radius',
a.dwDelayTimeMin AS 'Min Respawn Time',
a.dwDelayTimeMax AS 'Max Respawn Time'
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)
AND f.ContinentName NOT LIKE 'GOD_TOGUI'
AND (d.[Service] = 1 AND d.Codename128 LIKE 'MOB_%' AND d.Codename128 NOT LIKE 'MOB_GOD_%')
GROUP BY a.nRegionDBID, f.ContinentName, d.CodeName128, e.Lvl, d.Rarity, a.nRadius, a.nGenerateRadius, a.dwMaxTotalCount, a.dwDelayTimeMin, a.dwDelayTimeMax
HAVING e.Lvl <= 250
ORDER BY e.Lvl ASC;