bug: duplicates items in pagination

[wa0x6e]

On large leaderboard pages where users have same proposals/votes count, some address appear twice due to pagination

On some edge case, this issue may also appear in the space profile page, where we could have duplicates spaces, when user have activities with same counter on multiple spaces

Edit: this issue is more global, and affecting all graphql queries returning a lot of data. Seems like only onchain is affected, as on the hub, we're internally sorting by an additional id column

• [x] offchain: https://github.com/snapshot-labs/snapshot-hub/pull/885
• [ ] onchain: pending

[wa0x6e]

We fixed this issue on the hub by always sorting by multiple columns, in addition of the requested one.

For onchain, not sure of the fix, as graphql does not allow sorting by multiple fields

[wa0x6e]

Seems like the issue is more global, and affecting other endpoint like votes (https://discord.com/channels/955773041898573854/1030773050217615440/1266434986970578954)

Issue title has been updated to reflect that