bin/build-master-status: build-assignment statistics should only care about packages which are on the build-list

1 files changed, 9 insertions, 0 deletions

diff --git a/bin/build-master-status b/bin/build-master-status
index 2a71d8d..ec02136 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -183,6 +183,15 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
       mysql_join_build_assignments_binary_packages
       mysql_join_binary_packages_binary_packages_in_repositories
       mysql_join_binary_packages_in_repositories_repositories
+      printf ' JOIN ('
+        printf 'SELECT `binary_packages`.`build_assignment`'
+        printf ' FROM `binary_packages`'
+        mysql_join_binary_packages_binary_packages_in_repositories
+        printf ' WHERE `binary_packages_in_repositories`.`repository`=%s' \
+          "${repository_ids__any_build_list}"
+        printf ' GROUP BY `binary_packages`.`build_assignment`'
+      printf ') AS `bp_subq`'
+      printf ' ON `bp_subq`.`build_assignment`=`build_assignments`.`id`'
       printf ' LEFT'
       mysql_join_build_assignments_build_slaves
       printf ' LEFT'