do not read `binary_packages`.`repository`

1 files changed, 3 insertions, 2 deletions

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`"
   );
 
 ?>