Q&A for administrators, end users, developers and designers for Craft CMS
SELECT ph.Name, Count(*) From ReviewTaskResults r LEFT JOIN ReviewTaskResultTypes ph ON ph.Id = r.ReviewTaskResultTypeId Group by ph.Name