summaryrefslogtreecommitdiff
path: root/jfr_playoff
diff options
context:
space:
mode:
Diffstat (limited to 'jfr_playoff')
-rw-r--r--jfr_playoff/sql.py2
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 = '''