[NuGet.org Bug]: Package Pagination with sort by downloads desc is not sorted by downloads

[tonyqus]

Impact

It's more difficult to complete my work

Describe the bug

I'm crawling the package data from packages list page

I found that the packages are not sorted by downloads. It's a bit weird.

Repro Steps

Go to https://www.nuget.org/packages?page=8&prerel=false&includeComputedFrameworks=false&sortBy=totalDownloads-desc

Check the download number of Azure.Security.KeyVault.Keys package and Microsoft.Azure.Cosmos package.

Go to next page (page=9)

You will see that the next package has more downloads than Azure.Security.KeyVault.Keys package and Microsoft.Azure.Cosmos package. But it's sorted behind these two packages. It doesn't make sense.

Expected Behavior

The packages should be sorted by download desc page by page.

Screenshots

No response

Additional Context and logs

No response

[tonyqus]

Same problem happens in page=20

Duende.AccessTokenManagement package only has 6M download but it ranks in page 20. It doesn't make sense

However, packages after this package has 78M downloads. They are listed in page 21

[tonyqus]

Same problem happens in page=25

Duende.IdentityModel.OidcClient package only has 54k downloads

[erdembayar]

Related to #10405 (reply in thread)