SELECT e.*, s.image as sport_logo FROM events as e LEFT JOIN sports as s on s.id=e.sport_id WHERE e.id = 23SELECT e.*, s.image as sport_logo FROM events as e LEFT JOIN sports as s on s.id=e.sport_id WHERE e.id = 23ArraySELECT * FROM sports WHERE id = 15select g.type as play, ph.name, g.comp_id, ph.id, ph.level, g.results_order as points, ph.type from phazes as ph inner join games as g on g.phaze_id=ph.id where ph.comp_id=2319 and g.type!='SUBMATCH' group by ph.level, g.type order by levelSELECT 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 = 2319 AND rk.rank>0 ORDER BY rank>0 desc, rank, short EUSA
European Universities
COMPETITION SUMMARY
/ Men M2-
Final Ranking
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 = 2319 ORDER BY rank>0 desc, rank, short

Repêchages


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=776 ORDER BY (gp.score>0) DESC, gp.irm, gp.score ASC, gp.st_order
Place Team University Time
1. KEU Klaipeda University (LTU) 7:11.29
2. DHU Durham University (GBR) 7:15.69
3. PIV Polytechnic Institute of Viana do Castelo (POR) 7:23.71
4. LYO University of Lyon (FRA) 7:41.32
5. NST Norwegian University of Science and Technology (NOR) 18:47.20

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=779 ORDER BY (gp.score>0) DESC, gp.irm, gp.score ASC, gp.st_order
Place Team University Time
1. STG University of Stuttgart (GER) 7:10.09
2. SIT Szechenyi Istvan University (HUN) 7:12.06
3. SFI Swiss Federal Institute of Technology in Zurich (SUI) 7:15.80
4. KEU Klaipeda University (LTU) 7:18.15
5. SUY Surrey University (GBR) 7:21.35
6. DHU Durham University (GBR) 7:31.95
7. PIV Polytechnic Institute of Viana do Castelo (POR) 7:41.46
8. LYO University of Lyon (FRA) 7:54.35
9. NST Norwegian University of Science and Technology (NOR) 11:11.34
FINAL RANKING
Rank Team
2 University of Stuttgart M2- - University of Stuttgart (GER)
3 Szechenyi Istvan University M2- (1) - Szechenyi Istvan University (HUN)
4 Swiss Federal Institute of Technology in Zurich M2- - Inst. Tech. Zurich (SUI)
5 Klaipeda University M2- - Klaipeda Uni (LTU)
6 University of Surrey M2- - Surrey University (GBR)
7 Durham University M2- - Durham Uni (GBR)
8 Polytechnic Institute of Viana do Castelo M2- - Polytech V. Castelo (POR)
9 University of Lyon M2- - University of Lyon (FRA)
10 Norwegian University of Science and Technology M2- - Norwegian Science University (NOR)