use SRO_VT_SHARD delete from Tab_RefHive where dwHiveID = ( select dwHiveID from Tab_RefNest where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'NPC_AVATARN_'))) delete from Tab_RefNest where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'NPC_AVATARN_')) delete from Tab_RefTactics where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'NPC_AVATARN_')) delete from _RefObjChar where ID = ( select Link from _RefObjCommon where CodeName128 like 'NPC_AVATARN_' ) delete from _RefObjCommon where CodeName128 Like '%AVATARN_' delete from _RefShop where CodeName128 like '%AVATARN_' delete from _RefShopGroup where CodeName128 like '%AVATARN_' delete from _RefShopItemGroup where CodeName128 like '%AVATARN_' delete from _RefShopTab where CodeName128 like '%AVATARN_' delete from _RefShopTabGroup where CodeName128 like '%AVATARN_' delete from _RefMappingShopGroup where RefShopCodeName like '%AVATARN_' delete from _RefMappingShopWithTab where RefShopCodeName like '%AVATARN_'
