Red Wings Record vs. Toronto Maple Leafs
All games against Toronto Maple Leafs
Overall Record
| Location |
W |
L |
T |
Win % |
| All |
333 |
332 |
93 |
.501 |
| Home |
197 |
138 |
46 |
.577 |
| Away |
136 |
194 |
47 |
.423 |
Regular Season Record
| Location |
W |
L |
T |
Win % |
| All |
274 |
273 |
93 |
.501 |
| Home |
168 |
108 |
46 |
.593 |
| Away |
106 |
165 |
47 |
.407 |
Playoff Record
| Location |
W |
L |
T |
Win % |
| All |
59 |
59 |
0 |
.500 |
| Home |
29 |
30 |
0 |
.492 |
| Away |
30 |
29 |
0 |
.508 |
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.