summaryrefslogtreecommitdiff
path: root/playoff/sql.py
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2017-04-09 14:38:03 +0200
committeremkael <emkael@tlen.pl>2017-04-09 14:43:23 +0200
commit614aa880da2777e0696526996fe1132e93445004 (patch)
tree39a4aead7a7a962b9860ff5646e2164655261c73 /playoff/sql.py
parentf8a9c86c4c2f376fe82bdf46b91d2092e44f7b28 (diff)
Towel count fix
Diffstat (limited to 'playoff/sql.py')
-rw-r--r--playoff/sql.py2
1 files changed, 1 insertions, 1 deletions
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