| Poredak |
Klub |
Odigrane |
Pobjede |
Neriješeno |
Porazi |
Osvojeni |
Izgubljeni |
Set razlika |
Bodovi |
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 173 as team_id, 0 as rank union all
select 158, 1 ) 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 (173, 158, 0) AND ((p.id=55)) AND p.comp_id=71
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