1
SELECT channel.mgm_id,
2
channel.label AS channel_label,
3
channel.name AS channel_name,
4
package.name,
5
package.version,
6
package.release,
7
package.epoch,
8
package.arch,
9
(((((((
10
CASE
11
WHEN (package.epoch IS NOT NULL) THEN ((package.epoch)::text || ':'::text)
12
ELSE ''::text
13
END || (package.name)::text) || '-'::text) || (package.version)::text) || '-'::text) || (package.release)::text) || '.'::text) || (package.arch)::text) AS full_package_name,
14
package.synced_date
15
FROM ((channel
16
JOIN channelpackage ON (((channel.mgm_id = channelpackage.mgm_id) AND (channel.channel_id = channelpackage.channel_id))))
17
JOIN package ON (((channel.mgm_id = package.mgm_id) AND (channelpackage.package_id = package.package_id))))
18
ORDER BY channel.mgm_id, channel.label, package.name, package.version, package.release, package.epoch, package.arch;