This query just for one mob :
PHP Code:
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_SD%'))
MOB_SD=it will remove alexandria mobs..
And this is for all mobs spawn :
PHP Code:
update Tab_RefNest set dwMaxTotalCount=0 where dwTacticsID in (select dwTacticsID from Tab_RefTactics where dwObjID not in (select id from _RefObjCommon where link in (select id from _refobjchar where Lvl >101)))
Atention!! once you use this query or any query make Backup before use it