channelpackagesreport

SELECT channel.mgm_id,

    channel.label AS channel_label,

    channel.name AS channel_name,

    package.name,

    package.version,

    package.release,

    package.epoch,

    package.arch,

    (((((((

        CASE

            WHEN (package.epoch IS NOT NULL) THEN ((package.epoch)::text || ':'::text)

            ELSE ''::text

        END || (package.name)::text) || '-'::text) || (package.version)::text) || '-'::text) || (package.release)::text) || '.'::text) || (package.arch)::text) AS full_package_name,

    package.synced_date

   FROM ((channel

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

     JOIN package ON (((channel.mgm_id = package.mgm_id) AND (channelpackage.package_id = package.package_id))))

  ORDER BY channel.mgm_id, channel.label, package.name, package.version, package.release, package.epoch, package.arch;