I know it my be a headache, but would you not be better off having a custom post type of footballers and then using custom taxonomy of say teams.
But the team is then listed team name and year? As you can’t do teams and years individually as you don’t know what year they played for said team
May be easier to query!
