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.