diff options
Diffstat (limited to 'jfr_playoff/sql.py')
-rw-r--r-- | jfr_playoff/sql.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/jfr_playoff/sql.py b/jfr_playoff/sql.py index ab6d0be..1eac414 100644 --- a/jfr_playoff/sql.py +++ b/jfr_playoff/sql.py @@ -33,6 +33,11 @@ WHERE #db#.segments.tabl = %s AND #db#.segments.rnd = %s GROUP BY #db#.segments.tabl, #db#.segments.rnd ''' +CURRENT_SEGMENT = ''' +SELECT LEAST(segmentsperround, segm+1) +FROM #db#.admin +''' + PREFIX = ''' SELECT shortname FROM #db#.admin ''' |