Red Wings Record vs. Toronto Maple Leafs

All games against Toronto Maple Leafs

database error: Invalid SQL: (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'overall' type, 'A' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'overall' type, 'A' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'overall' type, 'A' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'overall' type, 'H' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (schedule_game.location = 'home') AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'overall' type, 'H' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (schedule_game.location = 'home') AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'overall' type, 'H' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (schedule_game.location = 'home') AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'overall' type, 'R' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (schedule_game.location = 'away') AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'overall' type, 'R' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (schedule_game.location = 'away') AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'overall' type, 'R' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (schedule_game.location = 'away') AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'regular' type, 'A' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'regular' type, 'A' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'regular' type, 'A' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'regular' type, 'H' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (schedule_game.location = 'home') AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'regular' type, 'H' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (schedule_game.location = 'home') AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'regular' type, 'H' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (schedule_game.location = 'home') AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'regular' type, 'R' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (schedule_game.location = 'away') AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'regular' type, 'R' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (schedule_game.location = 'away') AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'regular' type, 'R' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (schedule_game.location = 'away') AND (round_id = 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'playoff' type, 'A' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (round_id != 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'playoff' type, 'A' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (round_id != 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'playoff' type, 'A' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (round_id != 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'playoff' type, 'H' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (schedule_game.location = 'home') AND (round_id != 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'playoff' type, 'H' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (schedule_game.location = 'home') AND (round_id != 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'playoff' type, 'H' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (schedule_game.location = 'home') AND (round_id != 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'W' outcome, 'playoff' type, 'R' location FROM schedule_game WHERE ((game_detroit_score > game_opponent_score) AND (schedule_game.location = 'away') AND (round_id != 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'L' outcome, 'playoff' type, 'R' location FROM schedule_game WHERE ((game_detroit_score < game_opponent_score) AND (schedule_game.location = 'away') AND (round_id != 0) AND (team_id = '18'))) UNION (SELECT COUNT(schedule_game.game_date) total, 'T' outcome, 'playoff' type, 'R' location FROM schedule_game WHERE ((game_detroit_score = game_opponent_score) AND (game_played = '1') AND (schedule_game.location = 'away') AND (round_id != 0) AND (team_id = '18')))
MySQL error: 1054 (Unknown column 'schedule_game.location' in 'where clause')
Session halted.