I’m trying to create a “recently played” playlist across playlists. I’ve tried the below.
select * from Games where GameID in (select GameID from GamesStats order by RecentPlayed DESC limit 25)
This seems to give me the order backwards, but if I order ASC it’s incorrect.
Any thoughts on what I can change?