Skip to content

Instantly share code, notes, and snippets.

@nazwadi

nazwadi/select_npc_zone.sql

Created January 20, 2023 05:41
Show Gist options
  • Save nazwadi/9d30b5250c71a9b97e59dcc4c6ef63c1 to your computer and use it in GitHub Desktop.
Save nazwadi/9d30b5250c71a9b97e59dcc4c6ef63c1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_npc_zone.sql
SELECT DISTINCT s2.npcID, n.id, n.name, n.MR from spawn2 sp
INNER JOIN spawngroup s ON sp.spawngroupID = s.id
INNER JOIN spawnentry s2 ON s2.spawngroupID = s.id
INNER JOIN npc_types n ON n.id = s2.npcID
WHERE sp.zone = 'sebilis';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment