X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2FqueryGameStat.sql;fp=server%2Fdb%2FqueryGameStat.sql;h=c17209022ea44c99c69375ba3485848ac89179c9;hb=059f0aa261609b7421f8576a53d93a764049da5f;hp=0000000000000000000000000000000000000000;hpb=057e34c4b970db0b1b19dcb44ec58ec7afdb9bc0;p=vchess.git

diff --git a/server/db/queryGameStat.sql b/server/db/queryGameStat.sql
new file mode 100644
index 00000000..c1720902
--- /dev/null
+++ b/server/db/queryGameStat.sql
@@ -0,0 +1,4 @@
+select name,total
+from GameStat g
+  join variants v on g.vid = v.id
+where total > 0;