Duplicate entries during pagination when entry is added after initial load

[kwongtn]

WhatsApp message as follows:

[15-May-23 15:39] V: The entry below it if u dont refresh but scroll to check it will be the duplicate entry of that entry
[15-May-23 15:39] V: Only refreshing solves the problem haha
[15-May-23 15:42] KwongTN: ah this is known potential issue since day one 😂
will happen if there are changes to the list after you first loaded it

For example, the db loads entries 1-10, sorted by descending order
Frontend queries the next page by telling it wants entries 11-20
However now new entries has been added, so entry 1 is now 2 and so on 😂
[15-May-23 15:43] V: Oh for the past few weeks still loads properly for me haha
[15-May-23 15:44] V: As in dun need refresh no issues
[15-May-23 15:44] V: Only today got issue haha
[15-May-23 15:45] KwongTN: Happens if you already have it loaded locally