Red Wings Record vs. Quebec / Hamilton / New York
All games against Quebec / Hamilton / New York
Overall Record
| Location |
W |
L |
T |
Win % |
| All |
45 |
27 |
25 |
.593 |
| Home |
28 |
11 |
10 |
.673 |
| Away |
17 |
16 |
15 |
.510 |
Regular Season Record
| Location |
W |
L |
T |
Win % |
| All |
43 |
26 |
25 |
.590 |
| Home |
26 |
11 |
10 |
.660 |
| Away |
17 |
15 |
15 |
.521 |
Playoff Record
| Location |
W |
L |
T |
Win % |
| All |
2 |
1 |
0 |
.667 |
| Home |
2 |
0 |
0 |
1.00 |
| Away |
0 |
1 |
0 |
.000 |
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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19'))) 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 = '19')))
MySQL error: 1054 (Unknown column 'schedule_game.location' in 'where clause')
Session halted.