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 = 14select 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=2314 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 = 2314 AND rk.rank>0 ORDER BY rank>0 desc, rank, short EUSA
/ 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 = 2314 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
Finals
 
University of Parma 5
 
 
Final 27.07.17:00  
 
 
San Jorge Uni 14
 
 
 
Ecological Bucharest 7
 
 
3rd Place Final 27.07.16:00  
 
 
University of Coimbra 10
 
 
 
University of Porto 12
 
 
5th Place Final 27.07.15:20  
 
 
Institute of Technology Aachen 24
 
 
 
Karlsruhe Institute of Technology 7
 
 
7th Place Final 27.07.15:00  
 
 
 
 
 
 
 
San Jorge Uni
 
 
 
University of Coimbra
 
 
 
Institute of Technology Aachen
 
 
 
Karlsruhe Institute of Technology
 
Rank Team
2 University of Parma (ITA)
3 San Jorge University (ESP)
4 Ecological University of Bucharest (ROU)
5 University of Porto (POR)
6 University of Coimbra (POR)
7 Rhine-Westphalia Institute of Technology Aachen (GER)
8 Karlsruhe Institute of Technology (GER)