SELECT
es.event_id,
events.event_key,
ap.score_attempt_type,
ap.shootout_shot_order,
ap.play_result,
es.event_id,
es.action_key,
apar.person_id,
apar.participant_role
FROM ice_hockey_action_participants AS apar,
ice_hockey_action_plays AS ap,
ice_hockey_event_states AS es,
events
WHERE
apar.ice_hockey_action_play_id = ap.id
AND ap.ice_hockey_event_state_id = es.id
AND es.event_id = events.id
AND ap.score_attempt_type = 'shootout'
AND events.event_key = 'l.qmjhl.ca-2016-e.25188'
ORDER BY action_key ASC