1
SELECT channel.mgm_id,
2
channel.channel_id,
3
channel.label AS channel_label,
4
channel.name AS channel_name,
5
count(channelpackage.channel_id) AS number_of_packages,
6
channel.organization,
7
channel.synced_date
8
FROM (channel
9
LEFT JOIN channelpackage ON (((channel.mgm_id = channelpackage.mgm_id) AND (channel.channel_id = channelpackage.channel_id))))
10
GROUP BY channel.mgm_id, channel.channel_id, channel.label, channel.name, channel.organization, channel.synced_date
11
ORDER BY channel.mgm_id, channel.channel_id;