<code sql>select b.name
 , case b.race
 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 = 'Icecrown Citadel'
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) = 'Horde'
order by class, b.name;</code>