diff options
| author | emkael <emkael@tlen.pl> | 2019-12-31 13:19:48 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2019-12-31 13:19:48 +0100 |
| commit | 7d3a08128bcadd562e7eaa48644c830ed166c98c (patch) | |
| tree | f9f3a33c67a3cf0fd85175d346c36883e02fe0bf /jfr_playoff/sql.py | |
| parent | 009c26df9ccc65e3c58f62154a63498debd8e5b3 (diff) | |
Migrating JFR match results to result info client model
Diffstat (limited to 'jfr_playoff/sql.py')
| -rw-r--r-- | jfr_playoff/sql.py | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/jfr_playoff/sql.py b/jfr_playoff/sql.py index 1eac414..6903ab1 100644 --- a/jfr_playoff/sql.py +++ b/jfr_playoff/sql.py @@ -34,8 +34,9 @@ GROUP BY #db#.segments.tabl, #db#.segments.rnd ''' CURRENT_SEGMENT = ''' -SELECT LEAST(segmentsperround, segm+1) -FROM #db#.admin +SELECT MAX(segment) +FROM #db#.scores +WHERE #db#.scores.rnd = %s AND #db#.scores.contract IS NOT NULL ''' PREFIX = ''' |