SELECT name
FROM npc
WHERE id
IN (

SELECT npc_templateid
FROM spawnlist
)
AND (
id NOT
IN (

SELECT npcid
FROM npcskills
WHERE skillid =4084
)
)