From 857bd3fa11b0680f1a1ca482948ecc0a1110a478 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 30 May 2018 13:37:54 +0200 Subject: do not read `binary_packages`.`repository` --- buildmaster/to-delete.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'buildmaster/to-delete.php') diff --git a/buildmaster/to-delete.php b/buildmaster/to-delete.php index e4d8e67..67d9a28 100644 --- a/buildmaster/to-delete.php +++ b/buildmaster/to-delete.php @@ -13,9 +13,10 @@ "`architectures`.`name` AS `arch` " . "FROM `binary_packages` " . "JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` " . - "JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id` " . + " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" . + " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" . "WHERE `binary_packages`.`is_to_be_deleted` " . - "AND NOT `repositories`.`name` IN (\"build-support\",\"build-list\",\"deletion-list\")" + "AND `repositories`.`is_on_master_mirror`" ); ?> -- cgit v1.2.3