diff options
Diffstat (limited to 'jfr_playoff/sql.py')
| -rw-r--r-- | jfr_playoff/sql.py | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/jfr_playoff/sql.py b/jfr_playoff/sql.py index b01bd08..afbfbfb 100644 --- a/jfr_playoff/sql.py +++ b/jfr_playoff/sql.py @@ -34,3 +34,19 @@ WHERE #db#.segments.tabl = %s AND #db#.segments.rnd = %s PREFIX = ''' SELECT shortname FROM #db#.admin ''' + +SWISS_ENDED = ''' +SELECT (rnd = roundcnt) AND (segm = segmentsperround) FROM #db#.admin +''' + +SWISS_RESULTS = ''' +SELECT #db#.teams.fullname, + SUM(IF(#db#.matches.homet = #db#.teams.id, vph+corrh, vpv+corrv)) + + #db#.teams.score, + #db#.teams.grupa +FROM #db#.teams +LEFT JOIN #db#.matches + ON (#db#.teams.id = #db#.matches.homet OR #db#.teams.id = #db#.matches.visit) +WHERE #db#.teams.bye = 0 +GROUP BY #db#.teams.id +''' |