[BUG] Cards on Explore Page sometimes showing duplicate of already showed card instead of different project

[Patrik-Br]

Describe the bug
On the "Explore projects" section sometimes a random project from one page shows also on another page, in random place. If I use a different order (sort by new projects) the amount of projects/cards in total is the same so that means the card that was showing multiple times is not only duplicated but should show a different project instead. So it is possible that user won't be able to find a specific project this way. It will be easier to understand from the screenshots.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Explore projects'
2. Filter by organisation that has more projects then amount that fits on 1 page, for example "Médecins Sans Frontières (MSF)"
3. See that a radnom project(s) is showing on multiple pages

Expected behavior
Not showing the same project on multiple pages.

Screenshots
Screenshot of https://tasks.hotosm.org/explore?omitMapResults=1&organisation=M%C3%A9decins+Sans+Fronti%C3%A8res+%28MSF%29+&page=1

Projects number 15181 and 24690 are showing on both pages 1 and 2 If I sort by New projects the total number of projects is the same as before (35) but it doesn't show any project twice anymore.

Desktop (please complete the following information):

• OS Windows 11 Version 24H2
• Browser Vivaldi 7.5.3735.44 (Stable channel) (64-bit)
• TM Version v5.0.6

[prabinoid]

Thank you for this @Patrik-Br ! By default the ordering was based only on priority of the project which was non deterministic causing some projects to jump between pages or appear duplicated. This was made deterministic by adding id as a secondary sort key which results consistent results during pagination.

[Patrik-Br]

Thank you for the explanation! I really appreciate that :)