diff options
| author | emkael <emkael@tlen.pl> | 2017-02-25 18:44:50 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2017-02-25 18:44:50 +0100 |
| commit | 6762fb4bd2b02048a5657b0f2c68b279fdd48176 (patch) | |
| tree | 9d7ec94e29c61845635af3d8eccc20715d9116c6 /playoff/sql.py | |
| parent | e0fed55e7bf5b00a85fa0aa4949ba589cf1804d3 (diff) | |
Towel support
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 ''' |