id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tournament_team_player_result	ALL	tournament_team_player-tournament_id	NULL	NULL	NULL	33	Using where; Using temporary; Using filesort
1	SIMPLE	tournament	eq_ref	PRIMARY	PRIMARY	4	bsr.tournament_team_player_result.tournament_id	1	Using where