bin/build-master-status: Left-join the tables

1 files changed, 2 insertions, 2 deletions

diff --git a/bin/build-master-status b/bin/build-master-status
index 16d6c5a..76e755a 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -132,7 +132,7 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
       'tested_packages_count'
     printf '`architectures`.`id`'
     printf ' FROM `architectures`'
-    printf ' JOIN ('
+    printf ' LEFT JOIN ('
       printf 'SELECT'
       printf ' COUNT('
         printf 'DISTINCT `build_assignments`.`id`'
@@ -189,7 +189,7 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
       mysql_join_build_assignments_build_dependency_loops
     printf ') AS `ba_q`'
     printf ' ON `ba_q`.`architecture`=`architectures`.`id`'
-    printf ' JOIN ('
+    printf ' LEFT JOIN ('
       printf 'SELECT'
       printf ' SUM('
         printf 'IF('