database error: Invalid SQL: SELECT game.game_id, game.season_id, game_day_number, goal_period, goal_time, scorer.player_fname scorer_first_name, scorer.player_lname scorer_last_name, scorer.player_identifier scorer_identifier, scorer_teams.team_name scorer_team_name, goalie.player_fname goalie_first_name, goalie.player_lname goalie_last_name, goalie.player_identifier goalie_identifier, goalie_teams.team_name goalie_team_name FROM game_goal NATURAL JOIN game INNER JOIN player scorer ON game_goal.goal_scorer = scorer.player_id INNER JOIN game_stat_skater ON ((game_stat_skater.game_id = game.game_id) AND (game_stat_skater.player_id = game_goal.goal_scorer)) INNER JOIN alignment_team scorer_teams ON ((scorer_teams.season_id = game.season_id) AND (scorer_teams.team_id = game_stat_skater.team_id)) LEFT JOIN player goalie ON game_goal.goal_goalie = goalie.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 goalie_teams ON ((goalie_teams.season_id = game.season_id) AND (goalie_teams.team_id = game_stat_goalie.team_id)) WHERE (((goal_scorer = 676) OR (goal_assist1.player_id = 676) OR (goal_assist2.player_id = 676)) AND (game_type = 'R')) ORDER BY game.season_id ASC, game_day_number ASC, goal_num ASC
MySQL error: 1109 (Unknown table 'goal_assist1' in where clause)
Session halted.