From 614aa880da2777e0696526996fe1132e93445004 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sun, 9 Apr 2017 14:38:03 +0200
Subject: Towel count fix

---
 playoff/sql.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'playoff')

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