-- called by /home/master/builder/bin/generate-key-graph
SELECT DISTINCT REPLACE(TO_BASE64(`gpg_keys`.`public_key`),"\n",""),`gpg_keys`.`fingerprint` FROM `gpg_keys` JOIN `binary_packages` ON `gpg_keys`.`id`=`binary_packages`.`signing_key` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` AND `repositories`.`is_on_master_mirror`;