bin/sanity-check: style cleanup

1 files changed, 5 insertions, 4 deletions

diff --git a/bin/sanity-check b/bin/sanity-check
index 502ab63..b2f11c2 100755
--- a/bin/sanity-check
+++ b/bin/sanity-check
@@ -179,14 +179,15 @@ while [ $# -gt 0 ]; do
       errors=$(
         # shellcheck disable=SC2016
         {
-          printf 'SELECT `architectures`.`name`,`package_sources`.`pkgbase` FROM `package_sources`'
+          printf 'SELECT `architectures`.`name`,`package_sources`.`pkgbase`'
+          printf ' FROM `package_sources`'
           mysql_join_package_sources_build_assignments
           mysql_join_build_assignments_architectures
           printf ' WHERE EXISTS('
-            printf 'SELECT * FROM `binary_packages`'
+            printf 'SELECT 1 FROM `binary_packages`'
             mysql_join_binary_packages_binary_packages_in_repositories
-            mysql_join_binary_packages_in_repositories_repositories
-            printf ' WHERE `repositories`.`name`="build-list"'
+            printf ' WHERE `binary_packages_in_repositories`.`repository`=%s' \
+              "${repository_ids__any_build_list}"
             printf ' AND `binary_packages`.`build_assignment`=`build_assignments`.`id`'
           printf ');\n'
         } | \