Report Analysis

SELECT COUNT(s.report_id) AS total, t.type_name, group_concat(s.content_id) as content_ids
FROM rpt_content_main s
LEFT JOIN rpt_content_type t ON t.type_id = s.report_type_id
GROUP BY s.report_type_id