[HIDE]
[/HIDE]
SQL:
USE [SRO_VT_SHARD]
GO
UPDATE g
SET g.Service = 0
FROM dbo._RefGachaItemSet g
JOIN dbo._RefObjCommon o ON g.RefItemID = o.ID
WHERE o.CodeName128 LIKE 'ITEM_CH_%_12_%_RARE';
SQL:
USE [SRO_VT_SHARD]
GO
SELECT g.GachaID, g.Service, g.RefItemID, o.CodeName128, o.ID
FROM dbo._RefGachaItemSet g
JOIN dbo._RefObjCommon o ON g.RefItemID = o.ID
WHERE o.CodeName128 LIKE 'ITEM_CH_%_12_%_RARE';
