SELECT id, SUM(Debates) AS Debates FROM (SELECT participants.pro_debater AS id, COUNT(*) AS Debates FROM results GROUP BY participants.pro_debater UNION ALL SELECT participants.con_debater AS id, COUNT(*) AS Debates FROM results GROUP BY participants.con_debater) GROUP BY id ORDER BY Debates DESC;