BUG: Table duplicates some rows and omits others #1537

Describe the bug
The table view shows some rows twice, hiding an equal number of other rows that should be part of the result. Thus the total row count is correct, but some of the rows appear twice while others are missing.

To Reproduce
Steps to reproduce the behavior:

1. Open a table with more rows than the collection page size (settings). Use a small page size to make the issue more apparent.
2. Filter the table (may be required)
3. Sort the table (appears to be required)
4. Check for duplicates (e.g. copy-paste into a text editor and delete duplicate lines)

Expected behavior
All rows are shown once.

Screenshots

This is with page size 50

Version Information (please complete the following information):

• OS: Mac
• App Version: 7.2.4 Premium
• Install source: Installer
• Type: Application
• Database engine: PostgreSQL

Maybe related to #1501