Differences

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

--- dbquery:naxxramas10n [2025/03/13 00:32] – ramza
+++ dbquery:naxxramas10n [2025/03/13 02:18] (current) – ramza
@@ Line 1: / Line 1: @@
-==== Naxxramas 10-man Normal - Alliance ====
+<code sql>select b.name
-<code sql>select b.name as charactername
  , case b.race
- when 1 then 'Human' when 2 then 'Orc' when 3 then 'Dwarf' when 4 then 'Night Elf'
+ 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 'Blood Elf' when 11 then 'Draenei' else 'Unknown'
+ 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 'Death Knight' when 7 then 'Shaman' when 8 then 'Mage'
+ 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
-,, 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 as faction
 from acore_custom.playerbots_avail_raiders as a
 inner join acore_characters.characters as b
@@ Line 26: / Line 19: @@
  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, charactername;</code>
+order by class, b.name;</code>