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 = 37SELECT e.*, s.image as sport_logo FROM events as e LEFT JOIN sports as s on s.id=e.sport_id WHERE e.id = 37ArraySELECT * FROM sports WHERE id = 25select 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=2439 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 = 2439 AND rk.rank>0 ORDER BY rank>0 desc, rank, short EUSA
European Universities
COMPETITION SUMMARY
/ Men
Final Ranking
SELECT g.id AS game_id, g.results_order, g.comp_id, if(g.play='TEAM',gp.team_id, gp2.person_id) as team_id, g.phaze_id, if(g.play='TEAM',if(t.short!='',t.short, t.name), CONCAT(gp2.fname,' ',gp2.lname)) as name, if(g.play='TEAM',t.is_guest, gp2.type='GHOST') as is_guest, c.image, g.name AS gname, g.group, if(g.play='TEAM',gp.score,gp2.score) as score, loc.name AS location, g.time, g.status, g.period_id, ph.type AS phase_type, g.bracket, if(g.play='TEAM',if(t.short!='', t.short, if(c.short!='',c.short,t.name)), CONCAT(gp2.fname,' ',gp2.lname)) as short, if(g.play='TEAM',gp.irm, gp2.irm) as irm, g.bracket_size, g.bracket_pos FROM games AS g Left JOIN game_participants AS gp ON gp.game_id = g.id and g.play='TEAM' Left JOIN (select gs.*, sr.club_id as team_id, p.fname, p.lname, p.type from game_singles as gs inner join games as g on g.id=gs.game_id left JOIN single_rankings AS sr ON sr.player_id = gs.person_id and sr.comp_id=g.comp_id inner join people as p on p.id=gs.person_id) AS gp2 ON gp2.game_id = g.id and g.play='SINGLE' left JOIN teams AS t ON (gp.team_id = t.id) OR (gp2.team_id = t.id) left JOIN clubs AS c ON t.club_id = c.id LEFT JOIN phazes AS ph ON ph.id = g.phaze_id LEFT JOIN location AS loc ON loc.id = g.location WHERE g.comp_id = 2439 AND ph.level = 2 AND g.type!='SUBMATCH' ORDER BY bracket, g.time, g.id, if(g.play='TEAM',gp.id, gp2.id), t.name ASC
Quarter Finals
 
Sport University Cologne 0
 
 
M22 - Quarter Final 1 26.07.15:45  
 
 
Tilburg Uni 1
 
 
 
University of Belgrade 2
 
 
M25 - Quarter Final 2 26.07.18:00  
 
 
University of Zagreb 2
 
 
 
Duisburg-Essen University 0
 
 
M23 - Quarter Final 3 26.07.17:15  
 
 
Budapest Univ. of Tech. 2
 
 
 
Corvinus University 1
 
 
M24 - Quarter Final 4 26.07.16:30  
 
 
 
 
SELECT g.id AS game_id, g.results_order, g.comp_id, if(g.play='TEAM',gp.team_id, gp2.person_id) as team_id, g.phaze_id, if(g.play='TEAM',if(t.short!='',t.short, t.name), CONCAT(gp2.fname,' ',gp2.lname)) as name, if(g.play='TEAM',t.is_guest, gp2.type='GHOST') as is_guest, c.image, g.name AS gname, g.group, if(g.play='TEAM',gp.score,gp2.score) as score, loc.name AS location, g.time, g.status, g.period_id, ph.type AS phase_type, g.bracket, if(g.play='TEAM',if(t.short!='', t.short, if(c.short!='',c.short,t.name)), CONCAT(gp2.fname,' ',gp2.lname)) as short, if(g.play='TEAM',gp.irm, gp2.irm) as irm, g.bracket_size, g.bracket_pos FROM games AS g Left JOIN game_participants AS gp ON gp.game_id = g.id and g.play='TEAM' Left JOIN (select gs.*, sr.club_id as team_id, p.fname, p.lname, p.type from game_singles as gs inner join games as g on g.id=gs.game_id left JOIN single_rankings AS sr ON sr.player_id = gs.person_id and sr.comp_id=g.comp_id inner join people as p on p.id=gs.person_id) AS gp2 ON gp2.game_id = g.id and g.play='SINGLE' left JOIN teams AS t ON (gp.team_id = t.id) OR (gp2.team_id = t.id) left JOIN clubs AS c ON t.club_id = c.id LEFT JOIN phazes AS ph ON ph.id = g.phaze_id LEFT JOIN location AS loc ON loc.id = g.location WHERE g.comp_id = 2439 AND ph.level = 3 AND g.type!='SUBMATCH' ORDER BY bracket, g.time, g.id, if(g.play='TEAM',gp.id, gp2.id), t.name ASC
Semi Finals
 
 
University of Belgrade 2
 
 
   
M28 - Semi Final 1 27.07.11:45  
 
 
   
University of Zagreb 2
 
 
 
 
 
Budapest Univ. of Tech. 0
 
 
   
M29 - Semi Final 2 27.07.12:15  
 
 
   
Sport University Cologne 0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Tilburg Uni 2
 
 
   
M26 - 5-8 place game 1 27.07.10:15  
 
 
   
Duisburg-Essen University 2
 
 
 
 
 
Corvinus University 1
 
 
   
M27 - 5-8 place game 2 27.07.11:00  
 
 
   
 
 
 
SELECT g.id AS game_id, g.results_order, g.comp_id, if(g.play='TEAM',gp.team_id, gp2.person_id) as team_id, g.phaze_id, if(g.play='TEAM',if(t.short!='',t.short, t.name), CONCAT(gp2.fname,' ',gp2.lname)) as name, if(g.play='TEAM',t.is_guest, gp2.type='GHOST') as is_guest, c.image, g.name AS gname, g.group, if(g.play='TEAM',gp.score,gp2.score) as score, loc.name AS location, g.time, g.status, g.period_id, ph.type AS phase_type, g.bracket, if(g.play='TEAM',if(t.short!='', t.short, if(c.short!='',c.short,t.name)), CONCAT(gp2.fname,' ',gp2.lname)) as short, if(g.play='TEAM',gp.irm, gp2.irm) as irm, g.bracket_size, g.bracket_pos FROM games AS g Left JOIN game_participants AS gp ON gp.game_id = g.id and g.play='TEAM' Left JOIN (select gs.*, sr.club_id as team_id, p.fname, p.lname, p.type from game_singles as gs inner join games as g on g.id=gs.game_id left JOIN single_rankings AS sr ON sr.player_id = gs.person_id and sr.comp_id=g.comp_id inner join people as p on p.id=gs.person_id) AS gp2 ON gp2.game_id = g.id and g.play='SINGLE' left JOIN teams AS t ON (gp.team_id = t.id) OR (gp2.team_id = t.id) left JOIN clubs AS c ON t.club_id = c.id LEFT JOIN phazes AS ph ON ph.id = g.phaze_id LEFT JOIN location AS loc ON loc.id = g.location WHERE g.comp_id = 2439 AND ph.level = 4 AND g.type!='SUBMATCH' ORDER BY bracket, g.time, g.id, if(g.play='TEAM',gp.id, gp2.id), t.name ASC
Finals
 
 
 
 
University of Zagreb 2
 
 
   
   
   
M33 - Final 27.07.18:00  
 
 
   
   
   
University of Barcelona 2
 
 
 
 
 
 
 
 
 
Budapest Univ. of Tech. 0
 
 
   
   
   
M32 - 3rd place match 27.07.16:00  
 
 
   
   
   
Tilburg Uni 2
 
 
 
 
 
 
 
 
 
Duisburg-Essen University 1
 
 
   
   
   
M31 - 5th place match 27.07.16:00  
 
 
   
   
   
Sport University Cologne 2
 
 
 
 
 
 
 
 
 
Corvinus University 1
 
 
   
   
   
M30 - 7th place match 27.07.15:00  
 
 
   
   
   
University of Pecs 2
 
 
 
 
 
 
 
 
 
Ozyegin University 0
 
 
   
   
   
M21 - 9th place game 27.07.09:30  
 
 
   
   
   
 
 
 
 
 
 
 
 
 
 
 
 
 
 
University of Barcelona
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Tilburg Uni
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Sport University Cologne
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
University of Pecs
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
FINAL RANKING
Rank Team
2 University of Belgrade (SRB)
3 University of Barcelona (ESP)
4 Budapest University of Technology and Economics (HUN)
5 Tilburg University (NED)
6 University of Duisburg-Essen (GER)
7 German Sport University Cologne (GER)
8 Corvinus University of Budapest (HUN)
9 University of Pecs (HUN)
10 Ozyegin University (TUR)