The following commit has been merged in the master branch:
commit 50909f92f572a1cc84cf74f37830f2dd072b6cce
Author: Andreas Tille <[email protected]>
Date:   Fri May 31 15:14:07 2013 +0200

    Sorting

diff --git a/misc/sql/gis-thermometer.sh b/misc/sql/gis-thermometer.sh
index 778a486..77b118d 100755
--- a/misc/sql/gis-thermometer.sh
+++ b/misc/sql/gis-thermometer.sh
@@ -13,8 +13,8 @@ SELECT unstable.source,
        stable.version AS stable,
        testing.version AS testing,
        unstable.version AS unstable,
-       d.unstable_upstream,
-       d.unstable_status
+       d.unstable_upstream AS upstream,
+       d.unstable_status AS status
  FROM (
   SELECT DISTINCT p.source, strip_binary_upload(MAX(s.version)) AS version
     FROM packages p
@@ -49,6 +49,7 @@ SELECT unstable.source,
     ORDER BY p.source
   ) stable ON unstable.source = stable.source
   LEFT OUTER JOIN dehs d ON unstable.source = d.source
+  ORDER BY unstable.source
 ;
 
 EOT

-- 
Static and dynamic websites for Debian Pure Blends

_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit

Reply via email to