diff options
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) |