diff options
| -rw-r--r-- | jfr_playoff/sql.py | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/jfr_playoff/sql.py b/jfr_playoff/sql.py index 897c192..ab6d0be 100644 --- a/jfr_playoff/sql.py +++ b/jfr_playoff/sql.py @@ -22,6 +22,7 @@ JOIN #db#.scores sc2 AND sc2.room = 2 JOIN #db#.admin WHERE sc1.tabl = %s AND sc1.rnd = %s +GROUP BY sc1.tabl, sc1.rnd ''' TOWEL_COUNT = ''' @@ -29,6 +30,7 @@ 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 +GROUP BY #db#.segments.tabl, #db#.segments.rnd ''' PREFIX = ''' |