database error: Invalid SQL: SELECT game.game_id, game.season_id, game_day_number, goal_period, goal_time, first_name, last_name, identifier, team_name FROM game_goal NATURAL JOIN game LEFT JOIN players_names ON game_goal.goal_goalie = players_names.player_id LEFT JOIN games_goaliestats ON ((games_goaliestats.game_id = game.game_id) AND (games_goaliestats.player_id = game_goal.goal_goalie)) LEFT JOIN alignment_team ON ((alignment_team.season_id = game.season_id) AND (alignment_team.team_id = games_goaliestats.team_id)) WHERE ((game_goal.player_id = 710) 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.