bin/wtp: order results

1 files changed, 6 insertions, 2 deletions

diff --git a/bin/wtp b/bin/wtp
index 3545f61..b1b682f 100755
--- a/bin/wtp
+++ b/bin/wtp
@@ -29,7 +29,9 @@
         printf 'CONCAT(".",`binary_packages`.`sub_pkgrel`),'
         printf '""),'
       printf '")"'
-      printf ') SEPARATOR ", "'
+      printf ')'
+      printf ' ORDER BY `repositories`.`stability`'
+      printf ' SEPARATOR ", "'
     printf ')'
   printf ')'
   printf ' FROM `binary_packages`'
@@ -41,6 +43,8 @@
   printf '%s' "$*" | \
     base64 -w0
   printf '") AND `repositories`.`is_on_master_mirror`'
-  printf ' GROUP BY CONCAT(`binary_packages`.`pkgname`,"-",`architectures`.`name`);\n'
+  printf ' GROUP BY CONCAT(`binary_packages`.`pkgname`,"-",`architectures`.`name`)'
+  printf ' ORDER BY `binary_packages`.`pkgname`,`architectures`.`name`'
+  printf ';\n'
 } | \
   mysql_run_query