id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tournament_team_player	index_merge	tournament_team_player-unique,tournament_team_player-tournament_id,tournament_team_player-team_id	tournament_team_player-team_id,tournament_team_player-tournament_id	4,4	NULL	1	Using intersect(tournament_team_player-team_id,tournament_team_player-tournament_id); Using where; Using temporary; Using filesort
1	SIMPLE	player	eq_ref	PRIMARY	PRIMARY	4	bsr.tournament_team_player.player_id	1	NULL