# How does CityStrides rank strider finishers? **URL:** \ **Category:** General\ **Created:** [September 7, 2023, 5:36pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768 "2023-09-07T17:36:54Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![AWDK](https://community.citystrides.com/user_avatar/community.citystrides.com/awdk/32/2019_2.png) [@AWDK](https://community.citystrides.com/u/AWDK)\ **Post date:** [September 7, 2023, 5:36pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/1 "2023-09-07T17:36:54Z")
Just curious here. I’m working on hard mode in Seattle, WA. I achieved completed in Seattle a couple of years ago and have been amongst the handful of other 100% (regular mode) finishers. How does citystride rank those who are all #1 and 100%. Is it most recently finished? Will hard mode finish nail me to the top?!? Haha! Thanks, AK ---
**Author:** ![JamesChevalier](https://community.citystrides.com/user_avatar/community.citystrides.com/jameschevalier/32/2_2.png) [@JamesChevalier](https://community.citystrides.com/u/JamesChevalier)\ **Post date:** [September 7, 2023, 5:48pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/2 "2023-09-07T17:48:34Z")
It currently only sorts by percent complete, so any sorting beyond that e.g. multiple people at 💯 is internal to the database ---
**Author:** ![Marty](https://community.citystrides.com/letter_avatar_proxy/v4/letter/m/f0a364/32.png) [@Marty](https://community.citystrides.com/u/Marty)\ **Post date:** [September 7, 2023, 10:12pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/3 "2023-09-07T22:12:13Z")
Does that mean you removed the magic? > [@Leaderboard order?](https://community.citystrides.com/t/leaderboard-order/24297/7): > > Any further ordering is internal database magic. ---
**Author:** ![JamesChevalier](https://community.citystrides.com/user_avatar/community.citystrides.com/jameschevalier/32/2_2.png) [@JamesChevalier](https://community.citystrides.com/u/JamesChevalier)\ **Post date:** [September 7, 2023, 10:39pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/4 "2023-09-07T22:39:26Z")
Which magic are you referring to? ---
**Author:** ![rcreed](https://community.citystrides.com/letter_avatar_proxy/v4/letter/r/898d66/32.png) [@rcreed](https://community.citystrides.com/u/rcreed)\ **Post date:** [September 7, 2023, 11:57pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/5 "2023-09-07T23:57:58Z")
Just saying hi, as I’m also nearing 100% in Seattle on Hard Mode 🙂 It’s been a fun ride! ---
**Author:** ![AWDK](https://community.citystrides.com/user_avatar/community.citystrides.com/awdk/32/2019_2.png) [@AWDK](https://community.citystrides.com/u/AWDK)\ **Post date:** [September 8, 2023, 12:30am UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/6 "2023-09-08T00:30:43Z")
Hi! It’s been great fun watching everyone’s progress over the years! Congrats. It’s a big accomplishment. ---
**Author:** ![Marty](https://community.citystrides.com/letter_avatar_proxy/v4/letter/m/f0a364/32.png) [@Marty](https://community.citystrides.com/u/Marty)\ **Post date:** [September 8, 2023, 1:25pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/7 "2023-09-08T13:25:29Z")
You described it as ‘internal database magic’ in previous post I quoted. Was /s wondering where the magic went. ---
**Author:** ![AWDK](https://community.citystrides.com/user_avatar/community.citystrides.com/awdk/32/2019_2.png) [@AWDK](https://community.citystrides.com/u/AWDK)\ **Post date:** [September 8, 2023, 4:04pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/8 "2023-09-08T16:04:32Z")
alphabetical? ---
**Author:** ![ericjrw](https://community.citystrides.com/user_avatar/community.citystrides.com/ericjrw/32/1065_2.png) [@ericjrw](https://community.citystrides.com/u/ericjrw)\ **Post date:** [September 9, 2023, 5:12pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/9 "2023-09-09T17:12:40Z")
I don’t think so… But I came here looking for this answer too, as if there was some order amongst those who have completed a street, it seems quite random. ---
**Author:** ![amittai](https://community.citystrides.com/letter_avatar_proxy/v4/letter/a/7bcc69/32.png) [@amittai](https://community.citystrides.com/u/amittai)\ **Post date:** [September 19, 2023, 4:03pm UTC](https://community.citystrides.com/t/how-does-citystrides-rank-strider-finishers/26768/10 "2023-09-19T16:03:10Z")
> [@ericjrw](#): > > if there was some order amongst those who have completed a street, it seems quite random. for databases in general: “internal database magic” meaning “dunno how it works”, not as in “secret recipe”, which aligns with what James is saying. see: [mysql - Why do results from a SQL query not come back in the order I expect? - Stack Overflow](https://stackoverflow.com/questions/10999913/why-do-results-from-a-sql-query-not-come-back-in-the-order-i-expect) so: the tiebreaking order is random, unless it’s told how to sort them… and although it’s random, it’s not necessarily a different random order each time. this also means that for each 100% finisher, there is at least one possible query in which their name is returned at the top of the list! the more folks have finished a city, the longer it might take to get the desired random order.