Ошибка

Сообщение об ошибке

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')) AND( (m.team_id_1 = '4573') OR (m.team_id_2 = '4573') ) GROUP BY match_id) ms' at line 2: SELECT m.season_id AS season_id, COUNT(m.id) AS played, SUM(CASE WHEN m.team_id_1 = 4573 THEN 1 ELSE 0 END) AS played_h, SUM(CASE WHEN m.team_id_2 = 4573 THEN 1 ELSE 0 END) AS played_a, SUM(CASE WHEN (((m.win = 1) and m.team_id_1 = 4573) or ((m.win = 2) and m.team_id_2 = 4573)) THEN 1 ELSE 0 END) AS win, SUM(CASE WHEN (m.win = 3) THEN 1 ELSE 0 END) AS drawn, SUM(CASE WHEN (((m.win = 2) and m.team_id_1 = 4573) or ((m.win = 1) and m.team_id_2 = 4573) or (m.win = 4)) THEN 1 ELSE 0 END) AS lost, SUM(CASE WHEN (m.team_id_1 = 4573) THEN ms.value_1 WHEN (m.team_id_2 = 4573) THEN ms.value_2 ELSE 0 END) AS scored, SUM(CASE WHEN (m.win = 4) THEN 3 WHEN (m.team_id_1 = 4573) THEN ms.value_2 WHEN (m.team_id_2 = 4573) THEN ms.value_1 ELSE 0 END) AS against, SUM(CASE WHEN (m.team_id_1 = 4573) THEN ms.value_1 - ms.value_2 WHEN (m.team_id_2 = 4573) THEN ms.value_2 - value_1 ELSE 0 END) AS scored_against, SUM(CASE WHEN ((m.win = 1) and (m.team_id_1 = 4573)) THEN 1 ELSE 0 END) AS win_h, SUM(CASE WHEN ((m.win = 3) and (m.team_id_1 = 4573)) THEN 1 ELSE 0 END) AS drawn_h, SUM(CASE WHEN ((m.win = 2) and (m.team_id_1 = 4573)) THEN 1 ELSE 0 END) AS lost_h, SUM(CASE WHEN (m.team_id_1 = 4573) THEN ms.value_1 ELSE 0 END) AS scored_h, SUM(CASE WHEN (m.team_id_1 = 4573) THEN ms.value_2 ELSE 0 END) AS against_h, SUM(CASE WHEN (m.team_id_1 = 4573) THEN ms.value_1 - ms.value_2 ELSE 0 END) AS scored_against_h, SUM(CASE WHEN ((m.win = 1) and (m.team_id_2 = 4573)) THEN 1 ELSE 0 END) AS win_a, SUM(CASE WHEN ((m.win = 3) and (m.team_id_2 = 4573)) THEN 1 ELSE 0 END) AS drawn_a, SUM(CASE WHEN ((m.win = 2) and (m.team_id_2 = 4573)) THEN 1 ELSE 0 END) AS lost_a, SUM(CASE WHEN (m.team_id_2 = 4573) THEN ms.value_2 ELSE 0 END) AS scored_a, SUM(CASE WHEN (m.team_id_2 = 4573) THEN ms.value_1 ELSE 0 END) AS against_a, SUM(CASE WHEN (m.team_id_2 = 4573) THEN ms.value_2 - ms.value_1 ELSE 0 END) AS scored_against_a, SUM(CASE WHEN (((ms.p1_value_1 > ms.p1_value_2) and m.team_id_1 = 4573)) THEN 1 ELSE 0 END) AS p1_win_h, SUM(CASE WHEN ((ms.p1_value_1 = ms.p1_value_2) and (m.team_id_1 = 4573)) THEN 1 ELSE 0 END) AS p1_drawn_h, SUM(CASE WHEN (((ms.p1_value_1 < ms.p1_value_2) and m.team_id_1 = 4573)) THEN 1 ELSE 0 END) AS p1_lost_h, SUM(CASE WHEN (m.team_id_1 = 4573) THEN ms.p1_value_1 ELSE 0 END) AS p1_scored_h, SUM(CASE WHEN (((ms.p1_value_1 < ms.p1_value_2) and m.team_id_2 = 4573)) THEN 1 ELSE 0 END) AS p1_win_a, SUM(CASE WHEN ((ms.p1_value_1 = ms.p1_value_2) and (m.team_id_2 = 4573)) THEN 1 ELSE 0 END) AS p1_drawn_a, SUM(CASE WHEN (((ms.p1_value_1 > ms.p1_value_2) and m.team_id_2 = 4573)) THEN 1 ELSE 0 END) AS p1_lost_a, SUM(CASE WHEN (m.team_id_2 = 4573) THEN ms.p1_value_2 ELSE 0 END) AS p2_scored_a FROM {soccer_match} m JOIN (SELECT ms.match_id AS match_id, SUM(value_1) AS value_1, SUM(value_2) AS value_2, SUM(CASE WHEN (period_id = 3) THEN value_1 END) AS p1_value_1, SUM(CASE WHEN (period_id = 3) THEN value_2 END) AS p1_value_2, SUM(CASE WHEN (period_id = 4) THEN value_1 END) AS p2_value_1, SUM(CASE WHEN (period_id = 4) THEN value_2 END) AS p2_value_2 FROM {soccer_match_score} ms INNER JOIN {soccer_match} m ON m.id = ms.match_id WHERE (m.season_id IN ()) AND( (m.team_id_1 = :db_condition_placeholder_2) OR (m.team_id_2 = :db_condition_placeholder_3) ) GROUP BY match_id) ms ON ms.match_id = m.id WHERE (m.season_id IN ()) AND( (m.team_id_1 = :db_condition_placeholder_0) OR (m.team_id_2 = :db_condition_placeholder_1) ) GROUP BY m.season_id; Array ( [:db_condition_placeholder_0] => 4573 [:db_condition_placeholder_1] => 4573 [:db_condition_placeholder_2] => 4573 [:db_condition_placeholder_3] => 4573 ) в функции soccerTeam->soccerStatisticTeam() (строка 474 в файле /home/readfootball/www/readfooball.com/htdocs/sites/all/modules/soccer/includes/team.inc).
На сайте произошла непредвиденная ошибка. Пожалуйста, повторите попытку позже.