diff options
| author | emkael <emkael@tlen.pl> | 2018-01-26 21:01:03 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2018-01-26 21:01:03 +0100 |
| commit | 5b2f14b41d7b6a79754ddcb1052cf770e76921f7 (patch) | |
| tree | 561d2dc36ff643ef87a426716f679a56a083bf97 | |
| parent | 928617d6d33a988bf9b1d3781ef2c78356b4ec5a (diff) | |
Better detection of played boards
| -rw-r--r-- | jfr_playoff/sql.py | 2 |
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 |