Vasily Berezutskiy

WordPress-Datenbank-Fehler: [BIGINT UNSIGNED value is out of range in '`fussball-em-2024`.`a`.`time_out` - `fussball-em-2024`.`a`.`time_in` - 1']
SELECT a.player_id, SUM( a.goals ) as goals, SUM( a.assist ) as assists, SUM( a.goals_conceded ) as goals_conceded, SUM( a.goals_penalty ) as goals_penalty, SUM( a.goals_own ) as own_goals, SUM( a.card_y ) as card_y, SUM( a.card_yr ) as card_yr, SUM( a.card_r ) as card_r, SUM(CASE WHEN (a.appearance > 0) THEN 1 ELSE 0 END) as played, SUM(CASE WHEN (a.appearance = 1 OR a.appearance = 2) THEN 1 ELSE 0 END) as started, SUM(CASE WHEN a.appearance = 3 THEN 1 ELSE 0 END) as sub_in, SUM(CASE WHEN (( a.appearance = 1 OR ( a.appearance = 2 AND a.time_out > 59) ) AND a.goals_conceded = 0) THEN 1 ELSE 0 END) as clean_sheets , SUM(CASE WHEN (a.time_out >= a.time_in AND a.time_out = 46 ) THEN ( a.time_out - a.time_in - 1 ) WHEN (a.time_out >= a.time_in AND a.time_in = 46 ) THEN ( a.time_out - a.time_in + 1 ) WHEN (a.time_out >= a.time_in) THEN ( a.time_out - a.time_in ) ELSE 0 END ) as minutes FROM AwegqHV6_anwpfl_players a LEFT JOIN AwegqHV6_anwpfl_matches m ON m.match_id = a.match_id WHERE a.player_id = 29924 AND m.finished = 1 AND m.game_status = 1 GROUP BY a.player_id