[devn00b]

This is fixed on my test server. I've checked it twice now so here is the code. This should remove most of the spawns, leaving their npctype (spawn, confusing I know) behind.

Code:

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%familiar%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%mercenary%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%spirit companion%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%minion%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%earthen avatar%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%rotting thrall%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%diseased servant%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Split%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%warder%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%undying adherent%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet gorg%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Twin%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%warder%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Elemental Dominance%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Shift%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Possessed Essence%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%tellurian soldier%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%igneous apprentice%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%shadowy stalker%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%tellurian recruit%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim spellbinder%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet gazer");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim sorcerer%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%kitten.%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%undead knight%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%dedicated jack-o-lanterne%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Duplicate%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Master Tinkerer's Companion%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Reflection%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%aery outrider%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%cognatic bixie bopper%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%nightshade%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Warrior of Zek%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Servant of Vazaelle%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%slimy slug friend%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Valiant Beast");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Underfoot Attendant%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%fiery magician%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%aquatic warder%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%lizard");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%tellurian myrmidon");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%dreadnought%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%tellurian champion");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%wisp");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%squire%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%igneous adept%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim terror%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim heretic%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%pet monkey%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim thulian%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet goblin runt%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Mirror%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%aery hunter%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%attack hawk%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%frostpaw kitten%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%void beast%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%slimy slug friend%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Pariah of Bertoxxulous");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%icy companion%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%orc priest%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Minion of Thule");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Minion of Ro");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Minion of Hate");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%inferno golem%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pack pony%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%servant%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%water elemancer%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%igneous savant%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%siren%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet goblin runt%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Healing Companion");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%sacrament%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Gavel of Justice");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%feline friend");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Friend of Growth");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%wind sensei%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%animated dagger%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Child of Karana");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Beloved of Bristlebane");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%shadowy assassin%");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%A magical puppet");
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "<%'s%Mercenary%>");