Results
Owner
Platform development
Hosting
Dspot
Disclaimers
EUSA General Data Protection Regulation (GDPR) Policy
This platform is co-funded by the Erasmus+ Programme of the European Union. The European Commission's support for the production of this publication does not constitute an endorsement of the contents, which reflect the views only of the authors, and the Commission cannot be held responsible for any use which may be made of the information contained therein.
SELECT t.id as team_id, t.id, rk.comp_id as comp_id, t.name, if(c.short!='',c.short,c.name) as club_name, c.image, ct.short as country, rk.seed, rk.rank, t.club_id as club,
if(t.short!='', t.short, if(c.short!='',c.short,c.name)) as short
FROM team_rankings as rk
INNER JOIN teams as t on t.id=rk.team_id
INNER JOIN clubs as c on c.id=t.club_id
INNER JOIN country as ct on ct.id=c.country
WHERE rk.comp_id = 2326 ORDER BY rank>0 desc, rank, short
SELECT gp.game_id, gp.team_id, c.name as club_name, c.image, co.short as country, if(t.short!='', t.short, if(c.short!='', c.short, c.name)) as name, gp.score, gp.irm, gp.st_order as number, g.name as gname FROM game_participants AS gp inner join games as g on g.id=gp.game_id INNER JOIN teams AS t ON gp.team_id = t.id INNER JOIN clubs AS c ON t.club_id = c.id INNER JOIN country AS co ON c.country = co.id WHERE g.phaze_id=855 ORDER BY (gp.score>0) DESC, gp.irm, gp.score ASC, gp.st_order
SELECT gp.game_id, gp.team_id, c.name as club_name, c.image, co.short as country, if(t.short!='', t.short, if(c.short!='', c.short, c.name)) as name, gp.score, gp.irm, gp.st_order as number, g.name as gname FROM game_participants AS gp inner join games as g on g.id=gp.game_id INNER JOIN teams AS t ON gp.team_id = t.id INNER JOIN clubs AS c ON t.club_id = c.id INNER JOIN country AS co ON c.country = co.id WHERE g.phaze_id=856 ORDER BY (gp.score>0) DESC, gp.irm, gp.score ASC, gp.st_order
Repêchage
SELECT gp.game_id, gp.team_id, c.name as club_name, c.image, co.short as country, if(t.short!='', t.short, if(c.short!='', c.short, c.name)) as name, gp.score, gp.irm, gp.st_order as number, g.name as gname FROM game_participants AS gp inner join games as g on g.id=gp.game_id INNER JOIN teams AS t ON gp.team_id = t.id INNER JOIN clubs AS c ON t.club_id = c.id INNER JOIN country AS co ON c.country = co.id WHERE g.phaze_id=855 ORDER BY (gp.score>0) DESC, gp.irm, gp.score ASC, gp.st_order
| Place | Team | University | Time |
|---|
Finals
SELECT gp.game_id, gp.team_id, c.name as club_name, c.image, co.short as country, if(t.short!='', t.short, if(c.short!='', c.short, c.name)) as name, gp.score, gp.irm, gp.st_order as number, g.name as gname FROM game_participants AS gp inner join games as g on g.id=gp.game_id INNER JOIN teams AS t ON gp.team_id = t.id INNER JOIN clubs AS c ON t.club_id = c.id INNER JOIN country AS co ON c.country = co.id WHERE g.phaze_id=856 ORDER BY (gp.score>0) DESC, gp.irm, gp.score ASC, gp.st_order
| Place | Team | University | Time |
|---|---|---|---|
| 1. | LON |
University of London (GBR)
|
6:40.66 |
| 2. | KIT |
Karlsruhe Institute of Technology (GER)
|
6:42.43 |
| 3. | TBU |
Tilburg University (NED)
|
6:47.34 |
| 4. | ZRB |
University of Zagreb (CRO)
|
6:47.80 |
| 5. | DHU |
Durham University (GBR)
|
6:48.74 |
| 6. | PRT |
University of Porto (POR)
|
6:52.20 |
| Rank | Team | |
|---|---|---|
2 
|
|
University of London M4- (GBR) |
3 
|
|
Karlsruhe Institute of Technology M4- - Karlsruhe Institute of Technology (GER) |
| 4 | |
Tilburg University M4- - Tilburg Uni (NED) |
| 5 | |
University of Zagreb M4- - University of Zagreb (CRO) |
| 6 | |
Durham University M4- - Durham Uni (GBR) |
| 7 | |
University of Porto M4- - University of Porto (POR) |