diff options
| -rw-r--r-- | playoff/sql.py | 2 |
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 |