summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2018-01-26 21:01:03 +0100
committeremkael <emkael@tlen.pl>2018-01-26 21:01:03 +0100
commit5b2f14b41d7b6a79754ddcb1052cf770e76921f7 (patch)
tree561d2dc36ff643ef87a426716f679a56a083bf97
parent928617d6d33a988bf9b1d3781ef2c78356b4ec5a (diff)
Better detection of played boards
-rw-r--r--jfr_playoff/sql.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/jfr_playoff/sql.py b/jfr_playoff/sql.py
index 52d8248..897c192 100644
--- a/jfr_playoff/sql.py
+++ b/jfr_playoff/sql.py
@@ -11,7 +11,7 @@ WHERE matches.tabl = %s AND matches.rnd = %s
BOARD_COUNT = '''
SELECT segmentsperround*boardspersegment,
- SUM(sc1.contract IS NOT NULL AND sc2.contract IS NOT NULL)
+ SUM(sc1.score IS NOT NULL AND sc2.score IS NOT NULL)
FROM #db#.scores sc1
JOIN #db#.scores sc2
ON sc1.rnd = sc2.rnd