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 = 41SELECT e.*, s.image as sport_logo FROM events as e LEFT JOIN sports as s on s.id=e.sport_id WHERE e.id = 41ArraySELECT * FROM sports WHERE id = 6select 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=2442 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 = 2442 AND rk.rank>0 ORDER BY rank>0 desc, rank, short EUSA
European Universities
COMPETITION SUMMARY
/ Women
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 = 2442 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
Last 16 Round
 
Szechenyi Istvan University 11
 
 
Last 16 Match 1 02.08.19:10  
 
 
Vasyl Stefanyk Uni 21
 
 
 
Russian Presidential 11
 
 
Last 16 Match 2 02.08.19:10  
 
 
Uni of Goettingen 14
 
 
 
Uni of Barcelona 9
 
 
Last 16 Match 3 02.08.19:30  
 
 
Uni of Zurich 13
 
 
 
Uni of Nantes 12
 
 
Last 16 Match 4 02.08.19:30  
 
 
Uni of Vienna 22
 
 
 
Polytech Uni of Catalonia 2
 
 
Last 16 Match 5 02.08.20:30  
 
 
Uni of Lyon 12
 
 
 
Uni of Aveiro 14
 
 
Last 16 Match 6 02.08.20:30  
 
 
Uni of Pitesti 16
 
 
 
Tel Avivi Uni 6
 
 
Last 16 Match 7 02.08.20:50  
 
 
Uni of Ljubljana 18
 
 
 
VU Amsterdam 10
 
 
Last 16 Match 8 02.08.20:50  
 
 
 
 
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 = 2442 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
Quarter Finals
 
 
Vasyl Stefanyk Uni 21
 
 
   
Quarter Final 1 03.08.10:20  
 
 
   
Uni of Goettingen 19
 
 
 
 
 
Uni of Zurich 9
 
 
   
Quarter Final 2 03.08.11:00  
 
 
   
Uni of Vienna 7
 
 
 
 
 
Uni of Aveiro 13
 
 
   
Quarter Final 3 03.08.11:40  
 
 
   
Uni of Pitesti 16
 
 
 
 
 
Uni of Ljubljana 21
 
 
   
Quarter Final 4 03.08.12:20  
 
 
   
Uni of Porto 12
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Russian Presidential 11
 
 
   
9th Place Quarter Final 1 03.08.09:00  
 
 
   
Uni of Barcelona 9
 
 
 
 
 
Uni of Nantes 18
 
 
   
9th Place Quarter Final 2 03.08.09:00  
 
 
   
Polytech Uni of Catalonia 5
 
 
 
 
 
Uni of Lyon 14
 
 
   
9th Place Quarter Final 3 03.08.09:40  
 
 
   
Tel Avivi Uni 9
 
 
 
 
 
VU Amsterdam 12
 
 
   
9th Place Quarter Final 4 03.08.09:40  
 
 
   
 
 
 
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 = 2442 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
Semi Finals
 
 
 
 
Uni of Goettingen 15
 
 
   
   
   
Semi Final 1 03.08.18:45  
 
 
   
   
   
Uni of Aveiro 15
 
 
 
 
 
 
 
 
 
Uni of Ljubljana 13
 
 
   
   
   
Semi Final 2 03.08.19:25  
 
 
   
   
   
Szechenyi Istvan University 10
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Zurich 8
 
 
   
   
   
Semi Final 5th Place Game 1 03.08.15:40  
 
 
   
   
   
Uni of Vienna 21
 
 
 
 
 
 
 
 
 
Uni of Pitesti 8
 
 
   
   
   
Semi Final 5th Place Game 2 03.08.16:00  
 
 
   
   
   
Uni of Porto 5
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Nantes 12
 
 
   
   
   
9th Place Semi Final 1 03.08.15:00  
 
 
   
   
   
Uni of Lyon 17
 
 
 
 
 
 
 
 
 
VU Amsterdam 14
 
 
   
   
   
9th Place Semi Final 2 03.08.15:20  
 
 
   
   
   
Russian Presidential 13
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Barcelona 11
 
 
   
   
   
Semi Final 13th Place 1 03.08.12:20  
 
 
   
   
   
Polytech Uni of Catalonia 9
 
 
 
 
 
 
 
 
 
Tel Avivi Uni 6
 
 
   
   
   
13th Place Semi Final 2 03.08.12:40  
 
 
   
   
   
 
 
 
 
 
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 = 2442 AND ph.level = 5 AND g.type!='SUBMATCH' ORDER BY bracket, g.time, g.id, if(g.play='TEAM',gp.id, gp2.id), t.name ASC
Finals
 
 
 
 
 
 
 
 
Uni of Aveiro 10
 
 
   
   
   
   
   
   
   
Final 03.08.21:10  
 
 
   
   
   
   
   
   
   
Uni of Goettingen 12
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Ljubljana 10
 
 
   
   
   
   
   
   
   
3rd Place Final 03.08.20:30  
 
 
   
   
   
   
   
   
   
Szechenyi Istvan University 7
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Vienna 17
 
 
   
   
   
   
   
   
   
5th Place Final 03.08.17:40  
 
 
   
   
   
   
   
   
   
Uni of Zurich 20
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Pitesti 11
 
 
   
   
   
   
   
   
   
7th Place Final 03.08.17:00  
 
 
   
   
   
   
   
   
   
Uni of Nantes 6
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Lyon 11
 
 
   
   
   
   
   
   
   
9th Place Final 03.08.16:20  
 
 
   
   
   
   
   
   
   
Uni of Porto 5
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
VU Amsterdam 18
 
 
   
   
   
   
   
   
   
11th Place Final 03.08.17:40  
 
 
   
   
   
   
   
   
   
Russian Presidential 9
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Polytech Uni of Catalonia 4
 
 
   
   
   
   
   
   
   
13th Place Final 03.08.17:00  
 
 
   
   
   
   
   
   
   
Uni of Barcelona 21
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Tel Avivi Uni 16
 
 
   
   
   
   
   
   
   
15th Place Final 03.08.16:20  
 
 
   
   
   
   
   
   
   
Uni of Physical Edu 14
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Nova University of Lisbon 1
 
 
   
   
   
   
   
   
   
17th Place Game 03.08.11:40  
 
 
   
   
   
   
   
   
   
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Goettingen
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Ljubljana
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Zurich
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Pitesti
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Lyon
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
VU Amsterdam
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Uni of Barcelona
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Tel Avivi Uni
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Nova University of Lisbon
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
FINAL RANKING
Rank Team
2 University of Aveiro - University of Aveiro (POR)
3 University of Goettingen - University of Goettingen (GER)
4 University of Ljubljana - University of Ljubljana (SLO)
5 University of Vienna - University of Vienna (AUT)
6 Szechenyi Istvan University (HUN)
7 University of Zurich - University of Zurich (SUI)
8 University of Pitesti - University of Pitesti (ROU)
9 University of Lyon - University of Lyon (FRA)
10 University of Nantes - University of Nantes (FRA)
11 VU University of Amsterdam (NED)
12 University of Porto - University of Porto (POR)
13 Russian Presidential Academy of National Economy and Public Administration - Russian Presidential Academy of National Economy and Public Administration (RUS)
14 Polytechnic University of Catalonia (ESP)
15 University of Barcelona - University of Barcelona (ESP)
16 Tel Aviv University - Tel Aviv University (ISR)
17 Hungarian University of Sports Science - Hungarian U. of Sports Science (HUN)
18 Nova University of Lisbon (POR)