SELECT DISTINCT
                                count(ost_ticket.ticket_id) as cuenta,ost_help_topic.topic_id ,
                                CASE
                                    WHEN ost_help_topic.topic_id = 24 || ost_help_topic.topic_id = 25 THEN "Agenda Médica(Caso - V.2)"
                                    WHEN ost_help_topic.topic_id = 35 || ost_help_topic.topic_id = 29 THEN "Stock y Recetas"
                                    WHEN ost_help_topic.topic_id = 20 || ost_help_topic.topic_id = 85 || ost_help_topic.topic_id = 83 THEN "Administrativos"
                                    WHEN ost_help_topic.topic_id = 71 || ost_help_topic.topic_id = 79 THEN "RCE - RCO"
                                    WHEN ost_help_topic.topic_id = 63 || ost_help_topic.topic_id = 33 THEN "Tele"
                                    WHEN ost_help_topic.topic_id = 30 THEN "Urgencia"
                                    WHEN ost_help_topic.topic_id = 72 || ost_help_topic.topic_id = 28 THEN "Reportería y DataWH"
                                    WHEN ost_help_topic.topic_id = 21 || ost_help_topic.topic_id = 75 THEN "Manager"
                                    WHEN ost_help_topic.topic_id = 27 THEN "Interconsulta"
                                    WHEN ost_help_topic.topic_id = 34 || ost_help_topic.topic_id = 46 THEN "Archivos (Fichas)"
                                END
                                AS topic,
                                CASE
                                    WHEN ost_help_topic.topic_id = 24 || ost_help_topic.topic_id = 25 THEN 1
                                    WHEN ost_help_topic.topic_id = 35 || ost_help_topic.topic_id = 29 THEN 2
                                    WHEN ost_help_topic.topic_id = 20 || ost_help_topic.topic_id = 85 || ost_help_topic.topic_id = 83 THEN 3
                                    WHEN ost_help_topic.topic_id = 71 || ost_help_topic.topic_id = 79 THEN 4
                                    WHEN ost_help_topic.topic_id = 63 || ost_help_topic.topic_id = 33 THEN 5
                                    WHEN ost_help_topic.topic_id = 30 THEN 6
                                    WHEN ost_help_topic.topic_id = 72 || ost_help_topic.topic_id = 28 THEN 7
                                    WHEN ost_help_topic.topic_id = 21 || ost_help_topic.topic_id = 75 THEN 8
                                    WHEN ost_help_topic.topic_id = 27 THEN 9
                                    WHEN ost_help_topic.topic_id = 34 || ost_help_topic.topic_id = 46 THEN 10
                                END as topic_id_alias

                                FROM
                                ost_ticket
                                right OUTER JOIN ost_help_topic ON ost_ticket.topic_id = ost_help_topic.topic_id
                                AND ost_help_topic.dept_id = 10 AND ost_ticket.status_id = 1
                                GROUP BY
                                topic
                                ORDER BY
                                topic asc