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 = 27select 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=6527 and g.type!='SUBMATCH' group by ph.level, g.type order by levelSELECT p.id as team_id, c.image, rk.comp_id as comp_id, CONCAT(p.fname,' ',p.lname) as name, c.name as club_name, ct.short as country, c.id as club, rk.rank FROM single_rankings as rk INNER JOIN people as p on p.id=rk.player_id left JOIN clubs as c on c.id=rk.club_id left JOIN country as ct on ct.id=c.country WHERE rk.comp_id = 6527 AND rk.rank>0 ORDER BY rank>0 desc, rank EUSA
European Universities
COMPETITION SUMMARY
/ KL Men -74
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 = 6527 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
 
Liam Holden 3
 
 
Quarter Final 1 16.07.15:24  
 
 
Cesur Elen 3
 
 
 
Valentin Zauralsky 0
 
 
Quarter Final 2 16.07.15:36  
 
 
Fabian Robmann 3
 
 
 
Victor Ivanchenko 0
 
 
Quarter Final 3 16.07.15:48  
 
 
Lajos Fesu 3
 
 
 
Cameron Milne 0
 
 
Quarter Final 4 16.07.16: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 = 6527 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
 
 
Cesur Elen 3
 
 
   
Semi Final 1 17.07.11:00  
 
 
   
Fabian Robmann 0
 
 
 
 
 
Lajos Fesu 3
 
 
   
Semi Final 2 17.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 = 6527 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
 
 
 
 
Lajos Fesu 3
 
 
   
   
   
Final 17.07.11:00  
 
 
   
   
   
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Lajos Fesu
 
 
 
 
 
 
 
FINAL RANKING
Rank Competitor University
2 Cesur Elen Frankfurt University of Applied Sciences (GER)
3 Liam Holden South Gloucestershire and Stroud College (GBR)
3 Fabian Robmann University of Zurich (SUI)
5 Cameron Milne University of Warwick (GBR)
5 Akos Bolfan Eotvos Lorand University (HUN)
5 Victor Ivanchenko Taras Shevchenko National University of Kyiv (UKR)
5 Valentin Zauralsky Matej Bel University (SVK)
9 Filip Krata University of Lodz (POL)