[HIDE]
WITH SpawnSummary AS (
SELECT
SUM(a.dwMaxTotalCount) AS TotalSpawnCount
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_%')
)
SELECT
MAX(s.TotalSpawnCount) AS TotalSpawnCount,
CASE
WHEN MAX(s.TotalSpawnCount) < 40000 THEN 1
WHEN MAX(s.TotalSpawnCount) < 80000 THEN 2
WHEN MAX(s.TotalSpawnCount) < 120000 THEN 3
WHEN MAX(s.TotalSpawnCount) < 160000 THEN 4
WHEN MAX(s.TotalSpawnCount) < 200000 THEN 5
ELSE 6
END AS NumberOfGameServers
FROM SpawnSummary s;
[/HIDE]
WITH SpawnSummary AS (
SELECT
SUM(a.dwMaxTotalCount) AS TotalSpawnCount
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_%')
)
SELECT
MAX(s.TotalSpawnCount) AS TotalSpawnCount,
CASE
WHEN MAX(s.TotalSpawnCount) < 40000 THEN 1
WHEN MAX(s.TotalSpawnCount) < 80000 THEN 2
WHEN MAX(s.TotalSpawnCount) < 120000 THEN 3
WHEN MAX(s.TotalSpawnCount) < 160000 THEN 4
WHEN MAX(s.TotalSpawnCount) < 200000 THEN 5
ELSE 6
END AS NumberOfGameServers
FROM SpawnSummary s;
[/HIDE]
