Hi experts, I've been out of practice with SQL lately. That's my excuse and I'm sticking to it.
This query tells me the players selected for fixtures where players have been selected (for some fixtures, no players are selected).
I need to get the info from just the latest such fixture, i.e. the most recent where players have been selected. How would I best do this?
SELECT FR.fr_match_date, FP.fp_player_id
FROM fixtures_results FR INNER JOIN fixtures_players FP
ON FR.id = FP.fp_fixture_id
WHERE FP.fp_fixture_id IS NOT NULL
AND FR.fr_team_code = 'W'
AND FR.fr_season_start = 2017
ORDER BY FR.fr_match_date DESC, FP.fp_player_id