channelsreport

SELECT channel.mgm_id,

    channel.channel_id,

    channel.label AS channel_label,

    channel.name AS channel_name,

    count(channelpackage.channel_id) AS number_of_packages,

    channel.organization,

    channel.synced_date

   FROM (channel

     LEFT JOIN channelpackage ON (((channel.mgm_id = channelpackage.mgm_id) AND (channel.channel_id = channelpackage.channel_id))))

  GROUP BY channel.mgm_id, channel.channel_id, channel.label, channel.name, channel.organization, channel.synced_date

  ORDER BY channel.mgm_id, channel.channel_id;