bin/return-assignment: binary_packages -> binary_packages_in_repositories

1 files changed, 3 insertions, 4 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index 0488a7d..dcbd62e 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -411,13 +411,13 @@ packages=$(
   printf ' FROM `binary_packages`'
   mysql_join_binary_packages_architectures
   mysql_join_binary_packages_binary_packages_in_repositories
-  mysql_join_binary_packages_in_repositories_repositories
   printf ' WHERE `binary_packages`.`build_assignment`=from_base64("%s")' \
     "$(
       printf '%s' "${build_assignment_id}" | \
         base64 -w0
     )"
-  printf ' AND `repositories`.`name`="build-list"'
+  printf ' AND `binary_packages_in_repositories`.`repository`=%s' \
+    "${repository_ids__any_build_list}"
   printf ';\n'
 } | \
   mysql_run_query | \
@@ -629,8 +629,7 @@ trigger_mirror_refreshs
   printf 'UPDATE `binary_packages`'
   printf ' SET'
   printf ' `binary_packages`.`has_issues`=0,'
-  printf ' `binary_packages`.`is_tested`=0,'
-  printf ' `binary_packages`.`last_moved`=NOW()'
+  printf ' `binary_packages`.`is_tested`=0'
   printf ' WHERE `binary_packages`.`id` IN ('
   cut -d' ' -f1 < \
     "${tmp_dir}/package-ids" | \