database error: Invalid SQL: SELECT DISTINCT game.game_id, game.season_id, game_day_number, period, time, scorer.first_name scorer_first_name, scorer.last_name scorer_last_name, scorer.identifier scorer_identifier, scorer_teams.team_name scorer_team_name, goalie.first_name goalie_first_name, goalie.last_name goalie_last_name, goalie.identifier goalie_identifier, goalie_teams.team_name goalie_team_name FROM games_goals NATURAL JOIN game INNER JOIN games_goals_assists ON games_goals.goal_id = games_goals_assists.goal_id INNER JOIN players_names scorer ON games_goals.player_id = scorer.player_id INNER JOIN games_playerstats ON ((games_playerstats.game_id = game.game_id) AND (games_playerstats.player_id = games_goals.player_id)) INNER JOIN alignment_team scorer_team_info ON ((scorer_teams.season_id = game.season_id) AND (scorer_teams.team_id = games_playerstats.team_id)) LEFT JOIN games_goals_goalies ON games_goals.goal_id = games_goals_goalies.goal_id LEFT JOIN players_names goalie ON games_goals_goalies.player_id = goalie.player_id LEFT JOIN games_goaliestats ON ((games_goaliestats.game_id = game.game_id) AND (games_goaliestats.player_id = games_goals_goalies.player_id)) LEFT JOIN alignment_team goalie_teams ON ((goalie_teams.season_id = game.season_id) AND (goalie_teams.team_id = games_goaliestats.team_id)) WHERE (((games_goals.player_id = 1150) OR (games_goals_assists.player_id = 1150)) AND (game_type = 'R')) ORDER BY game.season_id ASC, game_day_number ASC, game_goal_num ASC
MySQL error: 1109 (Unknown table 'scorer_teams' in field list)
Session halted.