id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	match_player	ref	idx-match_player-match_id,idx-match_player-team_id,idx-match_player-player_id	idx-match_player-player_id	4	const	49	Using where; Using temporary; Using filesort
1	SIMPLE	match	eq_ref	PRIMARY	PRIMARY	4	bsr.match_player.match_id	1	Using where
1	SIMPLE	tournament	eq_ref	PRIMARY,team_season_id	PRIMARY	4	bsr.match.tournament_id	1	Using where