summaryrefslogtreecommitdiff
path: root/buildmaster/to-delete.php
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-05-30 13:37:54 +0200
committerErich Eckner <git@eckner.net>2018-05-30 13:37:54 +0200
commit857bd3fa11b0680f1a1ca482948ecc0a1110a478 (patch)
tree246f43a987fc7d0125107a287be2e05a917a9fe1 /buildmaster/to-delete.php
parent82e16bd24ef847b86321f25a8dd416c813b970f9 (diff)
downloadarchweb32-857bd3fa11b0680f1a1ca482948ecc0a1110a478.tar.xz
do not read `binary_packages`.`repository`
Diffstat (limited to 'buildmaster/to-delete.php')
-rw-r--r--buildmaster/to-delete.php5
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`"
);
?>