diff options
author | Erich Eckner <git@eckner.net> | 2018-05-30 13:37:54 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2018-05-30 13:37:54 +0200 |
commit | 857bd3fa11b0680f1a1ca482948ecc0a1110a478 (patch) | |
tree | 246f43a987fc7d0125107a287be2e05a917a9fe1 /buildmaster/to-delete.php | |
parent | 82e16bd24ef847b86321f25a8dd416c813b970f9 (diff) | |
download | archweb32-857bd3fa11b0680f1a1ca482948ecc0a1110a478.tar.xz |
do not read `binary_packages`.`repository`
Diffstat (limited to 'buildmaster/to-delete.php')
-rw-r--r-- | buildmaster/to-delete.php | 5 |
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`" ); ?> |