SELECT YEAR(season.opens) AS season, goalie.tournament AS tournament_type, standing.name AS team, goalie.games_played, time_played AS played_time, goalie.goals_against, goalie.wins, goalie.tied, goalie.lost, goalie.saves, goalie.shut_outs, REPLACE(CAST(goals_against_per_game AS CHAR), '.', ',') AS goals_against_per_game, saving_percentage FROM goalie JOIN season ON (season.id = goalie.season) JOIN standing ON (standing.team = goalie.team AND standing.season = goalie.season) WHERE goalie.id = 25000 GROUP BY season, tournament_type, team: Unknown column 'standing.name' in 'field list'