Untitled

select 
	ice_hockey_event_states.period_value,
	ice_hockey_event_states.period_time_elapsed,
	ice_hockey_event_states.context,
	ice_hockey_action_plays.comment,
	ice_hockey_action_participants.person_id,
	display_names.first_name,
	display_names.last_name
from
	ice_hockey_event_states,
	ice_hockey_action_plays,
	ice_hockey_action_participants,
	events,
	display_names
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_event_states.event_id = events.id
	and events.event_key = 'l.nhl.com-2007-e.8556'
	and display_names.entity_type = 'persons'
	and display_names.entity_id = ice_hockey_action_participants.person_id
	;