From 5b2f14b41d7b6a79754ddcb1052cf770e76921f7 Mon Sep 17 00:00:00 2001 From: emkael Date: Fri, 26 Jan 2018 21:01:03 +0100 Subject: Better detection of played boards --- jfr_playoff/sql.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 -- cgit v1.2.3