There are no meaningful natural matches between npc_types and spawn2, it's probably joining on random columns with matching 1s and 0s and such in the first one or something.
NPCIDs are associated with spawn2's by way of spawnentry's, so maybe something like this:
Code:
SELECT npc_types.name, spawn2.enabled, spawn2.id
FROM npc_types
JOIN spawnentry ON spawnentry.npcID = npc_types.id
JOIN spawn2 ON spawn2.spawngroupID = spawnentry.spawngroupID
WHERE npc_types.name LIKE '%Fabled%';