Zaprešić Open 2019 (M)

Skupina A, Poredak i raspored

Poredak Klub Odigrane Pobjede Porazi Osvojeni Izgubljeni Set razlika Bodovi
1 Detono Zagreb 3 3 0 6 0 +6 6
2 BHC Čakovec 3 2 1 4 4 0 4
3 BHC Algida 3 1 2 3 4 -1 2
4 BHC Falco Aeterna 3 0 3 1 6 -5 0

Skupina B, Poredak i raspored

Poredak Klub Odigrane Pobjede Porazi Osvojeni Izgubljeni Set razlika Bodovi
1 BHC Sesvete 3 3 0 6 1 +5 6
2 BHC Ban Let Cepelin 3 2 1 4 3 +1 4
3 Chemo Profili Zagreb 3 1 2 4 4 0 2
4 CRO YAC 3 0 3 0 6 -6 0

Skupina C, Poredak i raspored

Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, g.status, t.is_guest, c.image, g.type FROM game_participan' at line 1

Last SQL query: SELECT t.id AS team_id, sum(gtp.points) as points, 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 game_team_points as gtp on gtp.game_id=gp.game_id and gtp.team_id=gp.team_id and gtp.period_id is not null INNER JOIN (select pom.team_id, pom.rank from (select 212 as team_id, 1 as rank union all select 172, 2 union all select 218, 3 ) 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 (212, 172, 218, 0) AND ((p.id=71)) AND p.comp_id=77 GROUP BY game_id HAVING COUNT(game_id)=2) AS g_id) group by gtp.game_id, gtp.team_id ORDER BY game_id, gp.id
Poredak Klub Odigrane Pobjede Porazi Osvojeni Izgubljeni Set razlika Bodovi