Men
Consolidation round
Group
Ranking and schedule:
Group
Group A
Rnk |
Team |
Played |
Won |
Tied |
Lost |
For |
Against |
Diff. |
Points |
Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'as team_id, 3 as rank union all
select , 4 ) pom ) a' at line 6
Last SQL query: SELECT t.id AS team_id, gp.game_id, t.name, gp.score, pom.rank as rank, g.status, t.is_guest, c.image, g.type
FROM game_participants AS gp
INNER JOIN games AS g ON gp.game_id = g.id
INNER JOIN teams AS t ON gp.team_id = t.id
INNER JOIN clubs AS c ON t.club_id=c.id
INNER JOIN (select pom.team_id, pom.rank from (select as team_id, 3 as rank union all
select , 4 ) pom ) as pom on pom.team_id=t.id
WHERE g.id IN (SELECT id FROM (SELECT game_id AS id, COUNT(game_id) AS br FROM `game_participants` AS gid
INNER JOIN games AS g ON gid.game_id = g.id
INNER JOIN phazes AS p ON g.phaze_id = p.id
WHERE team_id IN (, , 0) AND ((p.id=2) or (p.level =((SELECT level FROM phazes WHERE id=2)-1))) AND p.comp_id=216
GROUP BY game_id
HAVING COUNT(game_id)=2) AS g_id)
ORDER BY game_id, gp.id