diff options
| author | emkael <emkael@tlen.pl> | 2018-01-22 14:43:02 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2018-01-22 14:43:02 +0100 |
| commit | b2a504ceec511d601a0be10af08c5e98fbbfc481 (patch) | |
| tree | 7e07daa0ba29a596c76d0479aa16a6a779b7b05a /jfr_playoff/sql.py | |
| parent | 2947c609534ac652380d020df5d9a3023f222b60 (diff) | |
Swiss results retrieval factored out
Diffstat (limited to 'jfr_playoff/sql.py')
| -rw-r--r-- | jfr_playoff/sql.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/jfr_playoff/sql.py b/jfr_playoff/sql.py index afbfbfb..52d8248 100644 --- a/jfr_playoff/sql.py +++ b/jfr_playoff/sql.py @@ -43,7 +43,9 @@ SWISS_RESULTS = ''' SELECT #db#.teams.fullname, SUM(IF(#db#.matches.homet = #db#.teams.id, vph+corrh, vpv+corrv)) + #db#.teams.score, - #db#.teams.grupa + #db#.teams.grupa, + #db#.teams.shortname, + #db#.teams.gif FROM #db#.teams LEFT JOIN #db#.matches ON (#db#.teams.id = #db#.matches.homet OR #db#.teams.id = #db#.matches.visit) |