X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2FqueryGameStat.sql;h=6b8d5a13c6d77c678711adcd6a84345832bf70f7;hb=0760d861aac62ed093d95ab86f7226dc6b8d3a70;hp=c17209022ea44c99c69375ba3485848ac89179c9;hpb=579916492b42a8a103090db52030391bc1860fa4;p=vchess.git

diff --git a/server/db/queryGameStat.sql b/server/db/queryGameStat.sql
index c1720902..6b8d5a13 100644
--- a/server/db/queryGameStat.sql
+++ b/server/db/queryGameStat.sql
@@ -1,4 +1,5 @@
 select name,total
 from GameStat g
   join variants v on g.vid = v.id
-where total > 0;
+where total > 0
+order by total desc;