select 
	ice_hockey_action_plays.score_attempt_type,
	ice_hockey_action_plays.comment,
	
	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
from 
	ice_hockey_action_plays, 
	ice_hockey_event_states
where 
	ice_hockey_action_plays.ice_hockey_event_state_id = ice_hockey_event_states.id