Differences

This shows you the differences between two versions of the page.

--- dbquery:naxxramas10n [2025/03/13 00:29] – created ramza
+++ dbquery:naxxramas10n [2025/03/13 02:18] (current) – ramza
@@ Line 1: / Line 1: @@
-==== Naxxramas 10-man Normal - Alliance ====
+<code sql>select b.name
+ , case b.race
-<code sql>call acore_custom.GetPBotRaidersAvail ('Naxxramas', '10-man Normal', 'Alliance', '');</code>
+ when 1 then 'Human' when 2 then 'Orc' when 3 then 'Dwarf' when 4 then 'NightElf'
+ when 5 then 'Undead' when 6 then 'Tauren' when 7 then 'Gnome' when 8 then 'Troll'
+ when 10 then 'BloodElf' when 11 then 'Draenei' else 'Unknown'
+ end as race
+, case b.class
+ when 1 then 'Warrior' when 2 then 'Paladin' when 3 then 'Hunter' when 4 then 'Rogue'
+ when 5 then 'Priest' when 6 then 'DeathKnight' when 7 then 'Shaman' when 8 then 'Mage'
+ when 9 then 'Warlock' when 11 then 'Druid'  else 'Unknown'
+ end as class
+, b.level
+from acore_custom.playerbots_avail_raiders as a
+inner join acore_characters.characters as b
+on a.guid  = b.guid
+where raidinstance = 'Naxxramas'
+and difficulty = '10-man Normal'
+and (case when b.race = 1 or b.race = 3 or b.race = 4 or b.race = 7 or b.race = 11 then 'Alliance'
+ when b.race = 2 or b.race = 5 or b.race = 6 or b.race = 8 or b.race = 10 then 'Horde'
+ else 'Unknown' end) = 'Alliance'
+order by class, b.name;</code>