From 614aa880da2777e0696526996fe1132e93445004 Mon Sep 17 00:00:00 2001 From: emkael Date: Sun, 9 Apr 2017 14:38:03 +0200 Subject: Towel count fix --- playoff/sql.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/playoff/sql.py b/playoff/sql.py index 69cd423..76ea728 100644 --- a/playoff/sql.py +++ b/playoff/sql.py @@ -23,7 +23,7 @@ WHERE sc1.tabl = %s AND sc1.rnd = %s ''' TOWEL_COUNT = ''' -SELECT #db#.admin.boardspersegment * SUM(#db#.segments.towel) +SELECT #db#.admin.boardspersegment * SUM(#db#.segments.towel > 0) FROM #db#.segments JOIN #db#.admin WHERE #db#.segments.tabl = %s AND #db#.segments.rnd = %s -- cgit v1.2.3