Longest time to sub-10 3x3x3 average

Restricted to cubers who eventually broke 3x3 sub-10 average — measures years from their first comp to their first sub-10 average. Top of the leaderboard = longest journey, best story.

Sub-10 is the recognized "high-level" line; people who took 10+ years to crack it are usually comeback cubers or veterans clawing their way back.

By the numbers

Data source

Three subqueries joined: ① set of cubers who ever hit sub-10 (event_id = 333 AND average > 0 AND average < 1000); ② each person's first comp date; ③ each person's first sub-10 date. Diff / 365.25 = years.

SELECT person_link,
       DATEDIFF(first_sub10.start_date, first_comp.start_date) / 365.25 years
FROM (SELECT DISTINCT person_id FROM results
      WHERE event_id='333' AND average > 0 AND average < 1000) sub10
JOIN (SELECT person_id, MIN(start_date) start_date FROM results
      JOIN competitions ON id=competition_id GROUP BY person_id) first_comp USING (person_id)
JOIN (SELECT person_id, MIN(start_date) start_date FROM results
      JOIN competitions ON id=competition_id
      WHERE event_id='333' AND average > 0 AND average < 1000
      GROUP BY person_id) first_sub10 USING (person_id)
ORDER BY years DESC LIMIT 100

Algorithm / pipeline

Caveats & edges

• "First comp" spans all events — even if you debuted only for BLD and didn't touch 3x3 for 5 years, those 5 years count.
• Only cubers who eventually broke sub-10 are listed — never-sub-10 cubers don't appear.
• First sub-10 is by comp date, not exact round time; slow-then-fast same day → that comp's start_date.

Related stats & links