diff options
Diffstat (limited to 'playoff/sql.py')
| -rw-r--r-- | playoff/sql.py | 7 |
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 ''' |