search

xackery / eqcleanup

Cleans up PEQ database to go to certain progressions
GNU General Public License v3.0
6 stars 3 forks source link

Take out soulbinders #1

Closed xackery closed 8 years ago

xackery commented 8 years ago

SELECT sg.id, nt.name FROM npc_types nt INNER JOIN spawnentry se ON se.npcid = nt.id INNER JOIN spawngroup sg ON sg.id = se.spawngroupid WHERE nt.name LIKE '%soulbinder%';