Men
Preliminary round
|
Team |
Played |
Won |
Tied |
Lost |
For |
Against |
Diff. |
Points |
1 |
ESP
|
8 |
8 |
0 |
0 |
241 |
146 |
+95 |
37 |
2 |
CRO
|
8 |
7 |
0 |
1 |
226 |
148 |
+78 |
33 |
3 |
EGY
|
8 |
6 |
0 |
2 |
202 |
149 |
+53 |
30.5 |
4 |
MNE
|
8 |
5 |
0 |
3 |
189 |
185 |
+4 |
22.5 |
5 |
GRE
|
8 |
3 |
1 |
4 |
178 |
184 |
-6 |
19 |
6 |
ROU
|
8 |
3 |
0 |
5 |
171 |
186 |
-15 |
17 |
7 |
ITA
|
8 |
2 |
0 |
6 |
161 |
197 |
-36 |
12 |
8 |
TUR
|
8 |
1 |
0 |
7 |
157 |
233 |
-76 |
6 |
9 |
KUW
|
8 |
0 |
1 |
7 |
135 |
232 |
-97 |
3 |
Consolidation round
|
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