Improve Paco-Sako rules. Draft Isardam

[vchess.git] / server / db / queryGameStat.sql

diff --git a/server/db/queryGameStat.sql b/server/db/queryGameStat.sql
new file mode 100644 (file)
index 0000000..c172090
--- /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;