erratalistreport

SELECT errata.mgm_id,

    errata.errata_id,

    errata.advisory_name,

    errata.advisory_type,

    errata.cve,

    errata.synopsis,

    errata.issue_date,

    errata.update_date,

    count(systemerrata.system_id) AS affected_systems,

    errata.synced_date

   FROM (errata

     LEFT JOIN systemerrata ON (((errata.mgm_id = systemerrata.mgm_id) AND (errata.errata_id = systemerrata.errata_id))))

  GROUP BY errata.mgm_id, errata.errata_id, errata.advisory_name, errata.advisory_type, errata.cve, errata.synopsis, errata.issue_date, errata.update_date, errata.synced_date

  ORDER BY errata.mgm_id, errata.advisory_name;