search

thewca / worldcubeassociation.org

All of the code that runs on worldcubeassociation.org
https://www.worldcubeassociation.org/
GNU General Public License v3.0
328 stars 176 forks source link

Show all tied results on a "Top N" rankings page #4479

Open KitClement opened 5 years ago

KitClement commented 5 years ago

As an example, see the comparison of the WCA results page and CubingChina for FMC average:

https://cubingchina.com/results/rankings?region=World&event=333fm&gender=all&type=average

https://www.worldcubeassociation.org/results/rankings/333fm/average?show=100+persons

There are 3 people shown with 98th rank currently, but advancing to the next page on CubingChina shows there are 13 more people who are also in 98th place. It would be nice if the SQL query worked with ties to show all 98th ranked competitors in the top 100 page.

jonatanklosko commented 5 years ago

Top level note: using pagination removes necessity for 100/1000 and also brings back the All people ranking that we dropped.