database error: Invalid SQL: SELECT game.game_id, game.season_id, game_day_number, goal_period, goal_time, player_fname, player_lname, player_identifier, team_name FROM game_goal NATURAL JOIN game LEFT JOIN player ON game_goal.goal_goalie = player.player_id LEFT JOIN game_stat_goalie ON ((game_stat_goalie.game_id = game.game_id) AND (game_stat_goalie.player_id = game_goal.goal_goalie)) LEFT JOIN alignment_team ON ((alignment_team.season_id = game.season_id) AND (alignment_team.team_id = game_stat_goalie.team_id)) WHERE ((game_goal.player_id = 535) AND (game_type = 'R')) ORDER BY game.season_id ASC, game_day_number ASC, goal_num ASC
MySQL error: 1054 (Unknown column 'game_goal.player_id' in 'where clause')
Session halted.