id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hdbk_season	ALL	PRIMARY	NULL	NULL	NULL	26	Using filesort
1	SIMPLE	t	ref	PRIMARY,team_season_id	team_season_id	4	bsr.hdbk_season.season_id	9	Using index
1	SIMPLE	ttp	ref	tournament_team_player-unique,tournament_team_player-tournament_id	tournament_team_player-tournament_id	4	bsr.t.tournament_id	48	Using where