[CLUB]
[/CLUB]
Kod:
USE SRO_VT_SHARD
UPDATE Tab_RefNest
SET dwMaxTotalCount = 5,
dwDelayTimeMin = 1,
dwDelayTimeMax = 2
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 ('Am', 'Ca')
AND d.Rarity IN (0, 0)
);