Something

select 
	*
from
	ice_hockey_event_states,
	ice_hockey_action_plays,
	ice_hockey_action_participants,
	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_event_states.event_id = events.id
	and events.event_key = 'l.nhl.com-2007-e.8556'
	;