1
SELECT errata.mgm_id,
2
errata.errata_id,
3
errata.advisory_name,
4
errata.advisory_type,
5
errata.cve,
6
errata.synopsis,
7
errata.issue_date,
8
errata.update_date,
9
count(systemerrata.system_id) AS affected_systems,
10
errata.synced_date
11
FROM (errata
12
LEFT JOIN systemerrata ON (((errata.mgm_id = systemerrata.mgm_id) AND (errata.errata_id = systemerrata.errata_id))))
13
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
14
ORDER BY errata.mgm_id, errata.advisory_name;