🐛 Incorrect Sorting of Proposals by Most Likes

[kneerose]

Area

Proposal Pillar

Domain

Custom setup

Which wallet were you using?

No response

Context

When sorting proposals by "Most Likes" on the proposal discussion page at 'https://p80-z78acf3c2-zded6a792-gtw.z937eb260.rustrocks.fr/', the displayed order is incorrect. According to the dev env, the proposal titled "Videlicet desparatus explicabo sapiente auxilium ipsum" with 1 like appears after the proposal titled "aaa" with 0 likes, despite the former having more likes.

https://p80-z78acf3c2-zded6a792-gtw.z937eb260.rustrocks.fr/proposal_discussion/3400
https://p80-z78acf3c2-zded6a792-gtw.z937eb260.rustrocks.fr/proposal_discussion/164

Steps to reproduce

1. Navigate to the proposal discussion page: 'https://p80-z78acf3c2-zded6a792-gtw.z937eb260.rustrocks.fr/proposal_discussion'
2. Sort the proposals by "Most Likes."
3. Observe the like counts and order of the first two proposals.

Actual behavior

• The "Most Likes" sorting does not display proposals in descending order of likes. For instance, "aaa" (0 likes) appears before "Videlicet desparatus explicabo sapiente auxilium ipsum" (1 like).

Expected behavior

• Proposals should be sorted in descending order based on like count, with "Videlicet desparatus explicabo sapiente auxilium ipsum" (1 like) appearing before "aaa" (0 likes).

[kneerose]

The sorting issue also occurs for most dislikes.

https://z74f91f2d-zb0719f09-gtw.z937eb260.rustrocks.fr/api/proposals?filters[$and][0][gov_action_type_id]=1&filters[$and][1][prop_name][$containsi]=&filters[$and][2][prop_submitted]=false&pagination[page]=1&pagination[pageSize]=25&sort[proposal][prop_dislikes]=DESC&populate[0]=proposal_links&populate[1]=proposal_withdrawals&populate[2]=proposal_constitution_content&populate[3]=proposal

Also, please don't forget to validate the other sorting response.