summaryrefslogtreecommitdiff
path: root/playoff/sql.py
diff options
context:
space:
mode:
Diffstat (limited to 'playoff/sql.py')
-rw-r--r--playoff/sql.py7
1 files changed, 7 insertions, 0 deletions
diff --git a/playoff/sql.py b/playoff/sql.py
index d5c28cd..69cd423 100644
--- a/playoff/sql.py
+++ b/playoff/sql.py
@@ -22,6 +22,13 @@ JOIN #db#.admin
WHERE sc1.tabl = %s AND sc1.rnd = %s
'''
+TOWEL_COUNT = '''
+SELECT #db#.admin.boardspersegment * SUM(#db#.segments.towel)
+FROM #db#.segments
+JOIN #db#.admin
+WHERE #db#.segments.tabl = %s AND #db#.segments.rnd = %s
+'''
+
PREFIX = '''
SELECT shortname FROM #db#.admin
'''