Differences

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

--- dbquery:naxxramas25n [2025/03/13 01:44] – created ramza
+++ dbquery:naxxramas25n [2025/03/13 02:18] (current) – ramza
@@ Line 1: / Line 1: @@
 <code sql>select b.name
  , 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