my $query = " SELECT count(g.spec_id) AS 'contador',g.spec_id,c.name,c.class, CASE c.class WHEN 'Warrior' THEN '#C79C6E' WHEN 'Paladin' THEN '#F58CBA' WHEN 'Hunter' THEN '#ABD473' WHEN 'Rogue' THEN '#FFF569' WHEN 'Priest' THEN '#FFFFFF' WHEN 'Death Knight' THEN '#C41F3B' WHEN 'Shaman' THEN '#0070DE' WHEN 'Mage' THEN '#69CCF0' WHEN 'Warlock' THEN '#9482C9' WHEN 'Monk' THEN '#00FF96' WHEN 'Druid' THEN '#FF7D0A' WHEN 'Demon Hunter' THEN '#A330C9' END AS 'class_color' FROM wow_eu_leadder_rbg g INNER JOIN wow_specs c on (g.spec_id = c.id) WHERE spec_id in (71, 72, 73, 70, 255, 259, 260, 261, 250, 251, 252, 263, 269, 103, 104, 577, 581) GROUP BY g.spec_id ORDER BY count(g.spec_id) DESC ";