customchannelsreport

WITH repositories AS (

         SELECT channelrepository.mgm_id,

            channelrepository.channel_id,

            string_agg(((channelrepository.repository_id || ' - '::text) || (channelrepository.repository_label)::text), ';'::text) AS channel_repositories

           FROM channelrepository

          GROUP BY channelrepository.mgm_id, channelrepository.channel_id

        )

 SELECT channel.mgm_id,

    channel.organization,

    channel.channel_id,

    channel.label,

    channel.name,

    channel.summary,

    channel.description,

    channel.parent_channel_label,

    channel.arch,

    channel.checksum_type,

    repositories.channel_repositories,

    channel.synced_date

   FROM (channel

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

  WHERE (channel.organization IS NOT NULL)

  ORDER BY channel.mgm_id, channel.organization, channel.channel_id;