vSro Paylaşım vSRO Haritadaki Canavar Spawn Sayılarını Listeleme

USE [SRO_VT_SHARD]
GO

-- ===================================================================
-- CANAVAR SPAWN ANALİZİ VE SAYIM RAPORU
-- ===================================================================
SELECT 
    d.CodeName128 AS [Canavar Kodu],
    e.Lvl AS [Seviye],
    CASE d.Rarity
        WHEN 0 THEN 'Normal'
        WHEN 1 THEN 'Champion'
        WHEN 3 THEN 'Unique'
        WHEN 6 THEN 'Giant'
        WHEN 7 THEN 'Titan'
        WHEN 8 THEN 'Elite'
        ELSE 'Diger'
    END AS [Canavar Turu],
    COUNT(a.dwNestID) AS [Toplam Slot/Yuva Sayisi],
    SUM(a.dwMaxTotalCount) AS [Maksimum Canli Mob Sayisi]
FROM dbo.Tab_RefNest a WITH (NOLOCK)
INNER JOIN dbo.Tab_RefTactics b WITH (NOLOCK) ON a.dwTacticsID = b.dwTacticsID
INNER JOIN dbo.Tab_RefHive c WITH (NOLOCK) ON a.dwHiveID = c.dwHiveID
INNER JOIN dbo._RefObjCommon d WITH (NOLOCK) ON b.dwObjID = d.ID
INNER JOIN dbo._RefObjChar e WITH (NOLOCK) ON d.Link = e.ID
INNER JOIN dbo._RefRegion f WITH (NOLOCK) ON a.nRegionDBID = f.wRegionID
WHERE 
    d.Service = 1 
    AND d.CodeName128 LIKE 'MOB_%'
    AND d.CodeName128 NOT LIKE 'MOB_GOD_%' -- Dimension Pillar türevlerini hariç tut
    AND f.ContinentName NOT LIKE 'GOD_TOGUI' -- Etkinlik zindanlarını hariç tut
    -- FILTRE: (Normal ve Giant moblar için: IN (0, 6) | Sadece Unique için: = 3)
    AND d.Rarity IN (0, 6)
GROUP BY 
    d.CodeName128, 
    e.Lvl, 
    d.Rarity
ORDER BY 
    e.Lvl ASC, 
    [Maksimum Canli Mob Sayisi] DESC