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 = 49SELECT e.*, s.image as sport_logo FROM events as e LEFT JOIN sports as s on s.id=e.sport_id WHERE e.id = 49ArraySELECT * FROM sports WHERE id = 4select 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=6555 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 = 6555 AND rk.rank>0 ORDER BY rank>0 desc, rank, short EUSA
European Universities
COMPETITION SUMMARY
/ Volleyball 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 = 6555 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
Semi finals
 
Gazi University 3
 
 
Semi Final 1 21.07.09:00  
 
 
Beykent University 3
 
 
 
Sumy State University 1
 
 
Semi Final 2 21.07.11:30  
 
 
University of Oslo 0
 
 
 
 
 
 
 
 
 
 
 
West University of Timisoara 3
 
 
5th-8th Place Semi Final 1 21.07.09:00  
 
 
Sport University Cologne 3
 
 
 
University of Valencia 0
 
 
5th-8th Place Semi Final 2 21.07.11: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 = 6555 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
Finals
 
 
Beykent University 3
 
 
   
Final 22.07.16:30  
 
 
   
Masaryk University 3
 
 
 
 
 
Sumy State University 0
 
 
   
3rd Place Final 22.07.13:00  
 
 
   
West University of Timisoara 3
 
 
 
 
 
Sport University Cologne 0
 
 
   
5th Place Final 22.07.10:45  
 
 
   
University of Oslo 3
 
 
 
 
 
University of Valencia 2
 
 
   
7th Place Final 22.07.08:30  
 
 
   
University of Porto 2
 
 
 
 
 
University Josip Juraj Stross. 3
 
 
   
9th Place Final 21.07.14:00  
 
 
   
 
 
 
 
 
 
 
 
Masaryk University
 
 
 
 
 
 
 
West University of Timisoara
 
 
 
 
 
 
 
University of Oslo
 
 
 
 
 
 
 
University of Porto
 
 
 
 
 
 
 
University Josip Juraj Stross.
 
 
 
FINAL RANKING
Rank Team
2 Gazi University (TUR)
3 Masaryk University (CZE)
4 Sumy State University (UKR)
5 West University of Timisoara (ROU)
6 German Sport University Cologne (GER)
7 University of Oslo (NOR)
8 University of Valencia (ESP)
9 Josip Juraj Strossmayer University of Osijek (CRO)
10 University of Porto (POR)