Con este code, podemos eliminar el tipo de Npc de nuestra base de datos; en este caso todos los de lvl 90 e inferior.
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND npc.TYPE='L2Monster';
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND npc.TYPE='L2FestivalMonster';
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND npc.TYPE='L2Minion';
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND npc.TYPE='L2Chest';
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND npc.TYPE='L2FeedableBeast';
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND npc.TYPE='L2RiftInvader';
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND npc.TYPE='L2RaidBoss';
By KingBorracho69