1 files changed, 10 insertions, 9 deletions
diff --git a/bin/build-master-status-from-mysql b/bin/build-master-status-from-mysql
index 6dacc5e..85185b7 100755
--- a/bin/build-master-status-from-mysql
+++ b/bin/build-master-status-from-mysql
@@ -8,15 +8,16 @@
 . "${base_dir}/bin/mysql-functions"
 
 # shellcheck disable=SC2016
-${mysql_command} -e '
-  SELECT `build_slaves`.`name`,`build_slaves`.`operator`,`package_sources`.`pkgbase`,`build_slaves`.`last_connection`
-  FROM `build_slaves`
-  LEFT JOIN `build_assignments` ON
-  `build_slaves`.`currently_building`=`build_assignments`.`id`
-  LEFT JOIN `package_sources` ON
-  `build_assignments`.`package_source`=`package_sources`.`id`
-  ORDER BY `build_slaves`.`last_connection`
-' --html | \
+{
+  printf 'SELECT `build_slaves`.`name`,`build_slaves`.`operator`,`package_sources`.`pkgbase`,`build_slaves`.`last_connection`'
+  printf ' FROM `build_slaves`'
+  printf ' LEFT JOIN `build_assignments` ON'
+  printf ' `build_slaves`.`currently_building`=`build_assignments`.`id`'
+  printf ' LEFT JOIN `package_sources` ON'
+  printf ' `build_assignments`.`package_source`=`package_sources`.`id`'
+  printf ' ORDER BY `build_slaves`.`last_connection`'
+} | \
+  ${mysql_command} --html | \
   sed '
     s,</TR>,\0\n,g
   ' | \