USE [SRO_VT_SHARD]
UPDATE dbo._RefObjCommon SET Rarity=0 WHERE CodeName128 LIKE 'ITEM_CH%RARE'
UPDATE dbo._RefObjCommon SET Rarity=0 WHERE CodeName128 LIKE 'ITEM_EU%RARE'
UPDATE dbo._RefObjCommon SET Rarity=0 WHERE CodeName128 LIKE 'ITEM_CH%RARE%'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'