bin/get-package-updates: ignore to_be_deleted packages

* either, they should be deleted -> nothing to do here
* or they should not -> reschedule

1 files changed, 5 insertions, 1 deletions

diff --git a/bin/get-package-updates b/bin/get-package-updates
index 8d2f370..706d2d1 100755
--- a/bin/get-package-updates
+++ b/bin/get-package-updates
@@ -328,11 +328,15 @@ echo 'Check modified packages from the last update, and put them to the build li
   )
   # shellcheck disable=SC2016
   {
-    printf 'SELECT `package_sources`.`pkgbase`,'
+    printf 'SELECT DISTINCT `package_sources`.`pkgbase`,'
     printf '`package_sources`.`git_revision`,'
     printf '`upstream_repositories`.`name`'
     printf ' FROM `package_sources`'
     mysql_join_package_sources_upstream_repositories
+    mysql_join_package_sources_build_assignments
+    mysql_join_build_assignments_binary_packages
+    mysql_join_binary_packages_binary_packages_in_repositories
+    printf ' AND NOT `binary_packages_in_repositories`.`is_to_be_deleted`'
   } \
   | mysql_run_query \
   | tr '\t' ' ' \