I had this with entire tv series showing up as recently added (making to impossible to see what actually had been recently added) which has persisted over all versions of plex for the last 2+ years. I tried the plex dance, I reloaded plex from scratch and reloaded my entire operating system (not to fix plex but effectively making plex a very clean install). I am not savvy with SQL, but however and whatever this script does, it fixed my entire issue.
After all this time, I had the biggest sigh of relief. I was on the verge of switching to different server software. I would think that plex could easily ensure that dates should never exceed the current date and time. I am not a programmer, so maybe there is a deeper issue.
I also used DB Browser for SQLite. The only thing I would add is that you need so save and close DB Browser before restarting Plex. It may be stupid, but Im not brilliant and tried to load plex before exiting,
