View Single Post
  #2  
Old 10-20-2010, 01:14 AM
csb4623
Sarnak
 
Join Date: Oct 2009
Location: Louisiana
Posts: 62
Default

SELECT nt.name, s2.zone
FROM spawn2 s2
JOIN spawngroup sg
ON sg.id = s2.spawngroupid
JOIN spawnentry se
ON se.spawngroupid = sg.id
JOIN npc_types nt
ON nt.id = se.npcid
WHERE s2.zone = 'crushbone';
Reply With Quote