bin/get-assignment: add missing join

1 files changed, 3 insertions, 0 deletions

diff --git a/bin/get-assignment b/bin/get-assignment
index 89ff155..df80e8b 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -205,6 +205,9 @@ next_building=$(
     # toolchain package is on that list
     printf 'DELETE `considered_build_assignments`'
     printf ' FROM `considered_build_assignments`'
+    printf ' JOIN `build_assignments`'
+    printf ' ON `build_assignments`.`id`=`considered_build_assignments`.`id`'
+    mysql_join_build_assignments_package_sources
     printf ' WHERE NOT EXISTS ('
       printf 'SELECT 1 FROM `toolchain_order`'
       printf ' WHERE `toolchain_order`.`pkgbase`=`package_sources`.`pkgbase`'