1
SELECT systemcustominfo.mgm_id,
2
systemcustominfo.system_id,
3
system.profile_name AS system_name,
4
systemcustominfo.organization,
5
systemcustominfo.key,
6
systemcustominfo.value,
7
systemcustominfo.synced_date
8
FROM (systemcustominfo
9
JOIN system ON (((systemcustominfo.mgm_id = system.mgm_id) AND (systemcustominfo.system_id = system.system_id))))
10
ORDER BY systemcustominfo.mgm_id, systemcustominfo.organization, systemcustominfo.system_id, systemcustominfo.key;