[c0ncrete]

This will help get you started.

This query lists info on what Fabled NPCs are currently in the database. If there is no loottable_id listed, the NPC in question has no loot unless it's scripted. If there is no spawngroupID listed, the NPC in question can only spawn from scripts. If there is no NPC listed... that should be self-explanatory.

SELECT
  npc_types.id,
  npc_types.name,
  npc_types.loottable_id,
  spawnentry.spawngroupID
FROM
  npc_types
LEFT JOIN
  spawnentry
ON
  spawnentry.npcID = npc_types.id
WHERE
  npc_types.name
LIKE
  '%Fabled%';

Caveat: Just because there is a loottable or spawngroup ID does not mean the NPC will have loot or spawn. There are additional database tables involved in populating both spawns and loot.