From b2a504ceec511d601a0be10af08c5e98fbbfc481 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Mon, 22 Jan 2018 14:43:02 +0100
Subject: Swiss results retrieval factored out

---
 jfr_playoff/sql.py | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'jfr_playoff/sql.py')

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)
-- 
cgit v1.2.3