some help .. thx

[adora5]

hello guy's
need query to remove all mobs in my privte server
.. thx for help

[Zodiao]

Well..

USE SRO_VT_SHARD
DELETE FROM TAB_REFNEST WHERE DWTACTICSID IN(SELECT DWTACTICSID
FROM TAB_REFTACTICS WHERE DWOBJID IN(SELECT ID FROM _REFOBJCOMMON WHERE CODENAME128 LIKE '%MOB%'))

[adora5]

ty

haven't query ?.. or that's query