World records by person
PersonAll-time per-cuber WR break count (single + average each contribute 1). Same source as by_country, only GROUP BY swap.
Top values usually in single / double digits — WRs are scarce (the entire WCA produces only a few dozen new WRs per year).
By the numbers
single + average
Each column = 1
Same row can be 2
`HAVING > 0`
Drop zeros
Cubers with 0 WRs excluded
sub_id = 1
Primary identity
Same as other person leaderboards
name 字母序 tiebreak
Tied-name sort
Same count → alphabetical
Data source
results aggregates SUM(IF(regional_single_record = WR, 1, 0) + IF(regional_average_record = WR, 1, 0)), GROUP BY person_id + HAVING > 0. Joined to persons (sub_id = 1).
sql
SELECT person_id,
SUM(IF(regional_single_record = 'WR', 1, 0)
+ IF(regional_average_record = 'WR', 1, 0)) wrs_count
FROM results
GROUP BY person_id
HAVING wrs_count > 0
ORDER BY wrs_count DESC, person.nameAlgorithm / pipeline
1
`SUM IF` to count WRs
Same row with both single + average WR contributes 2; one tag = 1; neither = 0.
2
Aggregate per person
One row per cuber, accumulating across all events and all time.
3
`HAVING wrs_count > 0`
Cubers who never broke a WR (the vast majority of WCA) excluded; otherwise the leaderboard would be hundreds of thousands long.
4
Sort desc + name tiebreak
Same WR count → alphabetical by name;
persons join brings primary identity.Caveats & edges
- Same cuber improving themselves all count: prelim + semi + final single WR at one comp = 3 WRs.
- WR-holder changing nationality doesn't affect their personal WR count, only by_country attribution.
- Different from
records_in_most_events(event breadth) — here we count occurrences, not distinct events. - No separate "current" version for persons; current-WR breakdown goes through
current_world_records_by_country(country-level only).