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;