select
ice_hockey_event_states.current_state,
ice_hockey_event_states.period_value,
ice_hockey_event_states.period_time_elapsed,
ice_hockey_event_states.period_time_remaining,
ice_hockey_event_states.context,
events.event_status
from
ice_hockey_event_states,
events
where
ice_hockey_event_states.event_id = events.id
and events.event_key = 'l.nhl.com-2007-e.9222'
order by
period_value asc,
period_time_elapsed asc
0 1 13:18 6:42 event post-event
0 1 13:18 NULL event-play post-event
0 1 5:10 14:50 event post-event
0 1 5:10 NULL event-play post-event
0 1 9:59 10:01 event post-event
0 1 9:59 NULL event-play post-event
0 2 10:29 9:31 event post-event
0 2 10:29 NULL event-play post-event
0 2 11:31 8:29 event post-event
0 2 11:31 NULL event-play post-event
0 2 19:50 NULL event-play post-event
0 2 19:50 0:10 event post-event
0 2 4:54 NULL event-play post-event
0 2 4:54 15:06 event post-event
0 2 6:07 13:53 event post-event
0 2 6:07 NULL event-play post-event
1 3 NULL 3:19 event-play post-event
0 3 0:23 19:37 event post-event
0 3 0:23 NULL event-play post-event
select
persons.person_key,
ice_hockey_action_participants.participant_role,
ice_hockey_action_plays.score_attempt_type,
ice_hockey_event_states.period_value,
ice_hockey_event_states.period_time_elapsed,
ice_hockey_event_states.period_time_remaining,
ice_hockey_event_states.context,
ice_hockey_event_states.current_state,
ice_hockey_action_plays.comment
from
persons,
ice_hockey_action_participants,
ice_hockey_action_plays,
ice_hockey_event_states,
events
where
ice_hockey_action_participants.ice_hockey_action_play_id = ice_hockey_action_plays.id
and ice_hockey_action_plays.ice_hockey_event_state_id = ice_hockey_event_states.id
and ice_hockey_action_participants.person_id = persons.id
and ice_hockey_event_states.event_id = events.id
and events.event_key = 'l.nhl.com-2007-e.9222'
l.nhl.com-p.279 assist power-play 1 5:10 NULL event-play 0 Colorado Power-Play Goal - Jordan Leopold (5), from Ruslan Salei and Andrew Brunette at 5:10.
l.nhl.com-p.56 assist power-play 1 5:10 NULL event-play 0 Colorado Power-Play Goal - Jordan Leopold (5), from Ruslan Salei and Andrew Brunette at 5:10.
l.nhl.com-p.1118 goal power-play 1 5:10 NULL event-play 0 Colorado Power-Play Goal - Jordan Leopold (5), from Ruslan Salei and Andrew Brunette at 5:10.
l.nhl.com-p.1845 assist regular 1 9:59 NULL event-play 0 Vancouver Goal - Daniel Sedin (29), from Henrik Sedin and Kevin Bieksa at 9:59.
l.nhl.com-p.587 assist regular 1 9:59 NULL event-play 0 Vancouver Goal - Daniel Sedin (29), from Henrik Sedin and Kevin Bieksa at 9:59.
l.nhl.com-p.580 goal regular 1 9:59 NULL event-play 0 Vancouver Goal - Daniel Sedin (29), from Henrik Sedin and Kevin Bieksa at 9:59.
l.nhl.com-p.578 assist regular 1 13:18 NULL event-play 0 Vancouver Goal - Taylor Pyatt (16), from Henrik Sedin and Markus Naslund at 13:18.
l.nhl.com-p.587 assist regular 1 13:18 NULL event-play 0 Vancouver Goal - Taylor Pyatt (16), from Henrik Sedin and Markus Naslund at 13:18.
l.nhl.com-p.90 goal regular 1 13:18 NULL event-play 0 Vancouver Goal - Taylor Pyatt (16), from Henrik Sedin and Markus Naslund at 13:18.
l.nhl.com-p.1114 assist regular 2 4:54 NULL event-play 0 Colorado Goal - Paul Stastny (23), from Milan Hejduk and Peter Forsberg at 4:54.
l.nhl.com-p.774 assist regular 2 4:54 NULL event-play 0 Colorado Goal - Paul Stastny (23), from Milan Hejduk and Peter Forsberg at 4:54.
l.nhl.com-p.1995 goal regular 2 4:54 NULL event-play 0 Colorado Goal - Paul Stastny (23), from Milan Hejduk and Peter Forsberg at 4:54.
l.nhl.com-p.1438 assist regular 2 6:07 NULL event-play 0 Colorado Goal - Cody McLeod (4), from John-Michael Liles at 6:07.
l.nhl.com-p.1996 goal regular 2 6:07 NULL event-play 0 Colorado Goal - Cody McLeod (4), from John-Michael Liles at 6:07.
l.nhl.com-p.1114 assist regular 2 10:29 NULL event-play 0 Colorado Goal - Milan Hejduk (25), from Paul Stastny and Peter Forsberg at 10:29.
l.nhl.com-p.1995 assist regular 2 10:29 NULL event-play 0 Colorado Goal - Milan Hejduk (25), from Paul Stastny and Peter Forsberg at 10:29.
l.nhl.com-p.774 goal regular 2 10:29 NULL event-play 0 Colorado Goal - Milan Hejduk (25), from Paul Stastny and Peter Forsberg at 10:29.
l.nhl.com-p.279 assist regular 2 11:31 NULL event-play 0 Colorado Goal - Ben Guite (11), from Wojtek Wolski and Andrew Brunette at 11:31. NOTE: Curtis Sanford replaced Roberto Luongo at the same time for Vancouver.
l.nhl.com-p.1894 assist regular 2 11:31 NULL event-play 0 Colorado Goal - Ben Guite (11), from Wojtek Wolski and Andrew Brunette at 11:31. NOTE: Curtis Sanford replaced Roberto Luongo at the same time for Vancouver.
l.nhl.com-p.1626 goal regular 2 11:31 NULL event-play 0 Colorado Goal - Ben Guite (11), from Wojtek Wolski and Andrew Brunette at 11:31. NOTE: Curtis Sanford replaced Roberto Luongo at the same time for Vancouver.
l.nhl.com-p.580 assist regular 2 19:50 NULL event-play 0 Vancouver Goal - Sami Salo (7), from Alexandre Burrows and Daniel Sedin at 19:50.
l.nhl.com-p.1956 assist regular 2 19:50 NULL event-play 0 Vancouver Goal - Sami Salo (7), from Alexandre Burrows and Daniel Sedin at 19:50.
l.nhl.com-p.410 goal regular 2 19:50 NULL event-play 0 Vancouver Goal - Sami Salo (7), from Alexandre Burrows and Daniel Sedin at 19:50.
l.nhl.com-p.774 goal regular 3 0:23 NULL event-play 0 Colorado Goal - Milan Hejduk 2 (26), from Paul Stastny and Peter Forsberg at 0:23.
l.nhl.com-p.1995 assist regular 3 0:23 NULL event-play 0 Colorado Goal - Milan Hejduk 2 (26), from Paul Stastny and Peter Forsberg at 0:23.
l.nhl.com-p.1114 assist regular 3 0:23 NULL event-play 0 Colorado Goal - Milan Hejduk 2 (26), from Paul Stastny and Peter Forsberg at 0:23.
l.nhl.com-p.1118 goal power-play 1 5:10 14:50 event 0 Colorado Power-Play Goal - Jordan Leopold (5), from Ruslan Salei and Andrew Brunette at 5:10.
l.nhl.com-p.56 assist power-play 1 5:10 14:50 event 0 Colorado Power-Play Goal - Jordan Leopold (5), from Ruslan Salei and Andrew Brunette at 5:10.
l.nhl.com-p.279 assist power-play 1 5:10 14:50 event 0 Colorado Power-Play Goal - Jordan Leopold (5), from Ruslan Salei and Andrew Brunette at 5:10.
l.nhl.com-p.580 goal regular 1 9:59 10:01 event 0 Vancouver Goal - Daniel Sedin (29), from Henrik Sedin and Kevin Bieksa at 9:59.
l.nhl.com-p.587 assist regular 1 9:59 10:01 event 0 Vancouver Goal - Daniel Sedin (29), from Henrik Sedin and Kevin Bieksa at 9:59.
l.nhl.com-p.1845 assist regular 1 9:59 10:01 event 0 Vancouver Goal - Daniel Sedin (29), from Henrik Sedin and Kevin Bieksa at 9:59.
l.nhl.com-p.90 goal regular 1 13:18 6:42 event 0 Vancouver Goal - Taylor Pyatt (16), from Henrik Sedin and Markus Naslund at 13:18.
l.nhl.com-p.587 assist regular 1 13:18 6:42 event 0 Vancouver Goal - Taylor Pyatt (16), from Henrik Sedin and Markus Naslund at 13:18.
l.nhl.com-p.578 assist regular 1 13:18 6:42 event 0 Vancouver Goal - Taylor Pyatt (16), from Henrik Sedin and Markus Naslund at 13:18.
l.nhl.com-p.1995 goal regular 2 4:54 15:06 event 0 Colorado Goal - Paul Stastny (23), from Milan Hejduk and Peter Forsberg at 4:54.
l.nhl.com-p.774 assist regular 2 4:54 15:06 event 0 Colorado Goal - Paul Stastny (23), from Milan Hejduk and Peter Forsberg at 4:54.
l.nhl.com-p.1114 assist regular 2 4:54 15:06 event 0 Colorado Goal - Paul Stastny (23), from Milan Hejduk and Peter Forsberg at 4:54.
l.nhl.com-p.1996 goal regular 2 6:07 13:53 event 0 Colorado Goal - Cody McLeod (4), from John-Michael Liles at 6:07.
l.nhl.com-p.1438 assist regular 2 6:07 13:53 event 0 Colorado Goal - Cody McLeod (4), from John-Michael Liles at 6:07.
l.nhl.com-p.774 goal regular 2 10:29 9:31 event 0 Colorado Goal - Milan Hejduk (25), from Paul Stastny and Peter Forsberg at 10:29.
l.nhl.com-p.1995 assist regular 2 10:29 9:31 event 0 Colorado Goal - Milan Hejduk (25), from Paul Stastny and Peter Forsberg at 10:29.
l.nhl.com-p.1114 assist regular 2 10:29 9:31 event 0 Colorado Goal - Milan Hejduk (25), from Paul Stastny and Peter Forsberg at 10:29.
l.nhl.com-p.1626 goal regular 2 11:31 8:29 event 0 Colorado Goal - Ben Guite (11), from Wojtek Wolski and Andrew Brunette at 11:31. NOTE: Curtis Sanford replaced Roberto Luongo at the same time for Vancouver.
l.nhl.com-p.1894 assist regular 2 11:31 8:29 event 0 Colorado Goal - Ben Guite (11), from Wojtek Wolski and Andrew Brunette at 11:31. NOTE: Curtis Sanford replaced Roberto Luongo at the same time for Vancouver.
l.nhl.com-p.279 assist regular 2 11:31 8:29 event 0 Colorado Goal - Ben Guite (11), from Wojtek Wolski and Andrew Brunette at 11:31. NOTE: Curtis Sanford replaced Roberto Luongo at the same time for Vancouver.
l.nhl.com-p.410 goal regular 2 19:50 0:10 event 0 Vancouver Goal - Sami Salo (7), from Alexandre Burrows and Daniel Sedin at 19:50.
l.nhl.com-p.1956 assist regular 2 19:50 0:10 event 0 Vancouver Goal - Sami Salo (7), from Alexandre Burrows and Daniel Sedin at 19:50.
l.nhl.com-p.580 assist regular 2 19:50 0:10 event 0 Vancouver Goal - Sami Salo (7), from Alexandre Burrows and Daniel Sedin at 19:50.
l.nhl.com-p.774 goal regular 3 0:23 19:37 event 0 Colorado Goal - Milan Hejduk 2 (26), from Paul Stastny and Peter Forsberg at 0:23.
l.nhl.com-p.1995 assist regular 3 0:23 19:37 event 0 Colorado Goal - Milan Hejduk 2 (26), from Paul Stastny and Peter Forsberg at 0:23.
l.nhl.com-p.1114 assist regular 3 0:23 19:37 event 0 Colorado Goal - Milan Hejduk 2 (26), from Paul Stastny and Peter Forsberg at 0:23.