This is a weird issue that you might never notice unless you're really paying attention. It involves database sorting logic on duplicate values and how that can interact in unexpected ways with pagination logic.
In this video, I walk through a demo example and show the fix, along with a simple rule to keep in mind to know when this fix is necessary.
And after watching, don't forget to subscribe to our YouTube channel, so you don't miss future videos.
Here to help,
Joel
P.S. Bugs like this hide in code that looks completely fine. Our code review digs into exactly these kinds of subtle issues before your users find them.