I've noticed that some deleted sessions still appear in the rankings; overall, country and spot. One example is the 500m rankings for Portland Harbour.
https://www.gps-speedsurfing.com/default.aspx?mnu=rankings&Year2=-&countryID2=268&SpotID2=681&Gender2=0&Tab=2&WeightClass2=0&AgeClass2=0&SpeedType2=3
Matthew Spooner (#9) and Tyler Baker (#14) both have deleted sessions appearing in the rankings. Ghosts of these sessions still remain and show a car journey along the courseway, explaining the deletions.
I've stumbled across similar anomalies for a number of the different rankings at a number of differenty spots.
@Dylan - Can anomolies like these be identifed with a simple SQL query and a bulk fix applied to the database?
|