Untitled

SELECT
	`pe`.`event_id`,
	`pe`.`participant_id`,
	`pe`.`alignment`,
	`t`.`team_key`,
	`dn`.`full_name`
FROM `participants_events` AS `pe`
 INNER JOIN `teams` AS `t` ON pe.participant_id = t.id
 INNER JOIN `display_names` AS `dn` ON dn.entity_id = pe.participant_id
WHERE
	(dn.entity_type = 'teams')
	AND (t.publisher_id = '1')
	AND (pe.participant_type = 'teams')
	AND (pe.event_id = '10966')