diff options
| author | emkael <emkael@tlen.pl> | 2017-04-09 14:38:03 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2017-04-09 14:43:23 +0200 |
| commit | 614aa880da2777e0696526996fe1132e93445004 (patch) | |
| tree | 39a4aead7a7a962b9860ff5646e2164655261c73 | |
| parent | f8a9c86c4c2f376fe82bdf46b91d2092e44f7b28 (diff) | |
Towel count fix
| -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 |