Short description of the issue
Episodes shown as next to watch in the Continued Watching section are incorrect if they match another unwatched episode with the exact same release date and time.
Detailed description with additional context about the workflow
My example here is the new series 2 of Bookish. In my Continue Watching section I am being shown series 2 episode 2, despite not having marked episode 1 as watched. This is because the release date and time of both episodes is identical. This is the same on both web and mobile.
The problem I have with this is that if I hadn’t paid attention to it, I would have marked E2 as watched first before I might have noticed it and then having to fix it. I suspect this is due to the order in which the new entries would have been entered in to the database, and without a suitable ordering clause in the SQL to pull the data, the database would have returned a non-deterministic set of results which has returned E2 before E1. I’m a developer / SQL admin and I deal with these kind of issues a lot, so this seems like the most logical reasoning.
Screenshots and other visual aids
Tag your post with new and/or classic, along with the platform (eg: iOS, android, web) to help us assist you faster.