All pastes #53696 Raw Edit

Mine

public text v1 · immutable
#53696 ·published 2006-05-05 09:32 UTC
rendered paste body
SELECT name
FROM npc
WHERE id
IN (

SELECT npc_templateid
FROM spawnlist
)
AND (
id NOT
IN (

SELECT npcid
FROM npcskills
WHERE skillid =4084
)
)