[CLUB]
[/CLUB]
Kod:
USE SRO_VT_SHARD
UPDATE Tab_RefNest
SET dwMaxTotalCount = 0
WHERE nRegionDBID IN (
SELECT DISTINCT a.wRegionID
FROM _RefRegion a
JOIN Tab_RefNest b ON a.wRegionID = b.nRegionDBID
JOIN Tab_RefTactics c ON b.dwTacticsID = c.dwTacticsID
JOIN _RefObjCommon d ON c.dwObjID = d.ID
WHERE a.ContinentName IN ('Pharaoh', 'Pharaoh')
AND d.Rarity IN (8, 8)
);