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;