X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2FqueryGameStat.sql;h=6b8d5a13c6d77c678711adcd6a84345832bf70f7;hb=7a0c1b7e33a346195caebfdfa6489e7c6d0457e6;hp=c17209022ea44c99c69375ba3485848ac89179c9;hpb=059f0aa261609b7421f8576a53d93a764049da5f;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;