From 198c1c537490c0cad8a76401d49bef8ecf0ab3c8 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 10 Jan 2021 20:50:01 +0100 Subject: bin/wtp: order results --- bin/wtp | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'bin') 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 -- cgit v1.2.3