Odd WCA stats/ Stats request Thread

[Mikel]

I thought this was interesting. Mats Bergsten has set his personal best AND the Swedish NR for 5x5 bld every other time he has competed. The times he didn't get NR were all DNF. See for yourself.

https://www.worldcubeassociation.org/results/p.php?i=2008BERG04#555bf

 

[guysensei1]

I thought this was interesting. Mats Bergsten has set his personal best AND the Swedish NR for 5x5 bld every other time he has competed. The times he didn't get NR were all DNF. See for yourself.

https://www.worldcubeassociation.org/results/p.php?i=2008BERG04#555bf

That's awesome!

 

[goodatthis]

Has anyone developed a box-and-whisker plot for all 3x3 averages? I'd like to know where the median, 1st, and 3rd quartile would lie.

 

[Robert-Y]

Which record has the most history (NR/CR/WR)? i.e. Which record has been broken the most number of times?

 

[goodatthis]

Which record has the most history (NR/CR/WR)? i.e. Which record has been broken the most number of times?

I didn't bother checking NR, but for CR and WR, NAR 3x3 average wins with 39. ER OH average and 4x4 average, as well as WR 4x4 single, have been broken 38 times.

 

[Stefan]

Repost with corrected data...

Which record has the most history (NR/CR/WR)? i.e. Which record has been broken the most number of times?

I'm going to assume you meant the WCA history view (which includes first and last and ties, so not only "broken" records).

Spoiler: Records with longest histories

Using data from WCA_export478_20140929 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Event[/TD][TD]Kind[/TD][TD]Region[/TD][TD]Records[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Netherlands[/TD][TD]42[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]North America[/TD][TD]39[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]World[/TD][TD]38[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Europe[/TD][TD]38[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Europe[/TD][TD]38[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Europe[/TD][TD]35[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Germany[/TD][TD]35[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]34[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Netherlands[/TD][TD]33[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Germany[/TD][TD]33[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]North America[/TD][TD]33[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]China[/TD][TD]33[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]USA[/TD][TD]33[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]World[/TD][TD]32[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Netherlands[/TD][TD]32[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Spain[/TD][TD]32[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]World[/TD][TD]32[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]USA[/TD][TD]32[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]32[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Germany[/TD][TD]31[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Europe[/TD][TD]30[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Indonesia[/TD][TD]29[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Taiwan[/TD][TD]29[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Spain[/TD][TD]29[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]North America[/TD][TD]29[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]World[/TD][TD]29[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Europe[/TD][TD]29[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Netherlands[/TD][TD]28[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]United Kingdom[/TD][TD]28[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]North America[/TD][TD]27[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Hungary[/TD][TD]27[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Sweden[/TD][TD]27[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Poland[/TD][TD]27[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Germany[/TD][TD]27[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]USA[/TD][TD]27[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]United Kingdom[/TD][TD]26[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Asia[/TD][TD]26[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Asia[/TD][TD]26[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]Europe[/TD][TD]26[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]USA[/TD][TD]26[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]North America[/TD][TD]26[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]World[/TD][TD]26[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]United Kingdom[/TD][TD]25[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Hungary[/TD][TD]25[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]USA[/TD][TD]25[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]China[/TD][TD]25[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Japan[/TD][TD]25[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Japan[/TD][TD]25[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]25[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Europe[/TD][TD]25[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Germany[/TD][TD]25[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Indonesia[/TD][TD]25[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Spain[/TD][TD]25[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Netherlands[/TD][TD]25[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]United Kingdom[/TD][TD]25[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Asia[/TD][TD]25[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Asia[/TD][TD]25[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Spain[/TD][TD]25[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Canada[/TD][TD]25[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Canada[/TD][TD]25[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Poland[/TD][TD]25[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Germany[/TD][TD]24[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Australia[/TD][TD]24[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Oceania[/TD][TD]24[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Philippines[/TD][TD]24[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]World[/TD][TD]24[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]United Kingdom[/TD][TD]24[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]Germany[/TD][TD]24[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]Asia[/TD][TD]24[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Hungary[/TD][TD]24[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]Spain[/TD][TD]24[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]North America[/TD][TD]23[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Germany[/TD][TD]23[/TD][/TR]
[TR][TD]Rubik's Magic[/TD][TD]Single[/TD][TD]World[/TD][TD]23[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]China[/TD][TD]23[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Asia[/TD][TD]23[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Poland[/TD][TD]23[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]Denmark[/TD][TD]23[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Italy[/TD][TD]23[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Indonesia[/TD][TD]23[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]China[/TD][TD]23[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]North America[/TD][TD]23[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Hungary[/TD][TD]23[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]North America[/TD][TD]23[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Korea[/TD][TD]23[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Poland[/TD][TD]23[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Iran[/TD][TD]23[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Sweden[/TD][TD]23[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Average[/TD][TD]Spain[/TD][TD]22[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Hungary[/TD][TD]22[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]USA[/TD][TD]22[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Canada[/TD][TD]22[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]France[/TD][TD]22[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Asia[/TD][TD]22[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Netherlands[/TD][TD]22[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Europe[/TD][TD]22[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]USA[/TD][TD]22[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]22[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Italy[/TD][TD]22[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Japan[/TD][TD]22[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Sweden[/TD][TD]22[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]USA[/TD][TD]22[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Asia[/TD][TD]22[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Canada[/TD][TD]22[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]France[/TD][TD]22[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Average[/TD][TD]World[/TD][TD]22[/TD][/TR]
[TR][TD]Square-1[/TD][TD]Average[/TD][TD]Europe[/TD][TD]22[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Hungary[/TD][TD]22[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Oceania[/TD][TD]21[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Spain[/TD][TD]21[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]China[/TD][TD]21[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Italy[/TD][TD]21[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Single[/TD][TD]North America[/TD][TD]21[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]China[/TD][TD]21[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Canada[/TD][TD]21[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]USA[/TD][TD]21[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Indonesia[/TD][TD]21[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]India[/TD][TD]21[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]United Kingdom[/TD][TD]21[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Single[/TD][TD]Belgium[/TD][TD]21[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Oceania[/TD][TD]21[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Japan[/TD][TD]21[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Italy[/TD][TD]21[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]Europe[/TD][TD]21[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Average[/TD][TD]France[/TD][TD]21[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]France[/TD][TD]21[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Canada[/TD][TD]21[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Denmark[/TD][TD]21[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Italy[/TD][TD]21[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]France[/TD][TD]21[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Canada[/TD][TD]21[/TD][/TR]
[TR][TD]7x7 Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]21[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]Germany[/TD][TD]21[/TD][/TR]
[TR][TD]Rubik's Clock[/TD][TD]Single[/TD][TD]Netherlands[/TD][TD]21[/TD][/TR]
[TR][TD]7x7 Cube[/TD][TD]Single[/TD][TD]Hungary[/TD][TD]20[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]Poland[/TD][TD]20[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]North America[/TD][TD]20[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Peru[/TD][TD]20[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Ukraine[/TD][TD]20[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Asia[/TD][TD]20[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Poland[/TD][TD]20[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Sweden[/TD][TD]20[/TD][/TR]
[TR][TD]Square-1[/TD][TD]Average[/TD][TD]World[/TD][TD]20[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]United Kingdom[/TD][TD]20[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Spain[/TD][TD]20[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Japan[/TD][TD]20[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]China[/TD][TD]20[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Hong Kong[/TD][TD]20[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Spain[/TD][TD]20[/TD][/TR]
[TR][TD]Rubik's Magic[/TD][TD]Average[/TD][TD]World[/TD][TD]20[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT eventId Event, Kind, Region,
  concat('[url=http://www.worldcubeassociation.org/results/regions.php?regionId=', regionId, '&eventId=', eventId, '&history=History]', count(*), '[/url]') Records
FROM (
SELECT eventId, 'World' Region, '' regionId, 'Single' Kind FROM Results WHERE regionalSingleRecord='WR' UNION ALL
SELECT eventId, 'World' Region, '' regionId, 'Average' Kind FROM Results WHERE regionalAverageRecord='WR' UNION ALL
SELECT eventId, Continents.name Region, Continents.id regionId, 'Single' Kind FROM Results join Countries on Countries.id=personCountryId join Continents on Continents.id=continentId WHERE regionalSingleRecord in(recordName, 'WR') UNION ALL
SELECT eventId, Continents.name Region, Continents.id regionId, 'Average' Kind FROM Results join Countries on Countries.id=personCountryId join Continents on Continents.id=continentId WHERE regionalAverageRecord in(recordName, 'WR') UNION ALL
SELECT eventId, personCountryId Region, personCountryId regionId, 'Single' Kind FROM Results WHERE regionalSingleRecord like '%R' UNION ALL
SELECT eventId, personCountryId Region, personCountryId regionId, 'Average' Kind FROM Results WHERE regionalAverageRecord like '%R'
) tmp
GROUP BY eventId, Kind, Region
HAVING count(*)>=20
ORDER BY count(*) desc;[/NOPARSE]

 

[Stefan]

Inspired by [post=947718]this[/post], I've been watching the sum the last couple days.

Spoiler: Total time speedsolved

Using data from WCA_export478_20140929 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Million Seconds[/TD][/TR]
[TR][TD="align:right"]100.04713259[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT sum(if(value1>0,value1,0)+
           if(value2>0,value2,0)+
           if(value3>0,value3,0)+
           if(value4>0,value4,0)+
           if(value5>0,value5,0))/100/1000000 'Million Seconds'
FROM Results join Events on Events.id=eventId
WHERE format='time';[/NOPARSE]

 

[cmhardw]

Inspired by [post=947718]this[/post], I've been watching the sum the last couple days.

Spoiler: Total time speedsolved

Using data from WCA_export478_20140929 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Million Seconds[/TD][/TR]
[TR][TD="align:right"]100.04713259[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT sum(if(value1>0,value1,0)+
           if(value2>0,value2,0)+
           if(value3>0,value3,0)+
           if(value4>0,value4,0)+
           if(value5>0,value5,0))/100/1000000 'Million Seconds'
FROM Results join Events on Events.id=eventId
WHERE format='time';[/NOPARSE]

Very cool!

 

[Stefan]

A variation of Robert's request...

Spoiler: Records with most holders

Using data from WCA_export478_20140929 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Event[/TD][TD]Kind[/TD][TD]Region[/TD][TD]Holders[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]World[/TD][TD]17[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Asia[/TD][TD]17[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]Europe[/TD][TD]17[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]World[/TD][TD]16[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]16[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]USA[/TD][TD]15[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]North America[/TD][TD]15[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Asia[/TD][TD]15[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Europe[/TD][TD]15[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]World[/TD][TD]15[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]World[/TD][TD]14[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]North America[/TD][TD]14[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]World[/TD][TD]14[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]North America[/TD][TD]14[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]Asia[/TD][TD]13[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Asia[/TD][TD]13[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]China[/TD][TD]13[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Canada[/TD][TD]13[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]USA[/TD][TD]13[/TD][/TR]
[TR][TD]Rubik's Magic[/TD][TD]Average[/TD][TD]World[/TD][TD]13[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]China[/TD][TD]13[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Asia[/TD][TD]13[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Europe[/TD][TD]13[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Single[/TD][TD]China[/TD][TD]13[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]USA[/TD][TD]13[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Korea[/TD][TD]13[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]12[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Canada[/TD][TD]12[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]World[/TD][TD]12[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Philippines[/TD][TD]12[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Europe[/TD][TD]12[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Average[/TD][TD]North America[/TD][TD]12[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]China[/TD][TD]12[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Europe[/TD][TD]12[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]China[/TD][TD]12[/TD][/TR]
[TR][TD]Master Magic[/TD][TD]Average[/TD][TD]Asia[/TD][TD]11[/TD][/TR]
[TR][TD]Rubik's Magic[/TD][TD]Single[/TD][TD]World[/TD][TD]11[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]North America[/TD][TD]11[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Italy[/TD][TD]11[/TD][/TR]
[TR][TD]Square-1[/TD][TD]Single[/TD][TD]Canada[/TD][TD]11[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Single[/TD][TD]World[/TD][TD]11[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]11[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD]Single[/TD][TD]World[/TD][TD]11[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Europe[/TD][TD]11[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Indonesia[/TD][TD]11[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Taiwan[/TD][TD]11[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Single[/TD][TD]South America[/TD][TD]11[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]USA[/TD][TD]11[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]China[/TD][TD]11[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Europe[/TD][TD]11[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]China[/TD][TD]11[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Single[/TD][TD]North America[/TD][TD]10[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Single[/TD][TD]North America[/TD][TD]10[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Single[/TD][TD]Asia[/TD][TD]10[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Spain[/TD][TD]10[/TD][/TR]
[TR][TD]Rubik's Magic[/TD][TD]Average[/TD][TD]Asia[/TD][TD]10[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]China[/TD][TD]10[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Europe[/TD][TD]10[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Spain[/TD][TD]10[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Japan[/TD][TD]10[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Germany[/TD][TD]10[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]Korea[/TD][TD]10[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Japan[/TD][TD]10[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Single[/TD][TD]China[/TD][TD]10[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Single[/TD][TD]Indonesia[/TD][TD]10[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Single[/TD][TD]India[/TD][TD]10[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Single[/TD][TD]North America[/TD][TD]10[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD]Average[/TD][TD]Korea[/TD][TD]10[/TD][/TR]
[TR][TD]Rubik's Clock[/TD][TD]Single[/TD][TD]Europe[/TD][TD]10[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Europe[/TD][TD]10[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Japan[/TD][TD]10[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]France[/TD][TD]10[/TD][/TR]
[TR][TD]Square-1[/TD][TD]Average[/TD][TD]World[/TD][TD]10[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]Asia[/TD][TD]10[/TD][/TR]
[TR][TD]Rubik's Magic[/TD][TD]Average[/TD][TD]Europe[/TD][TD]10[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Canada[/TD][TD]10[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Single[/TD][TD]Taiwan[/TD][TD]10[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Indonesia[/TD][TD]10[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD]Average[/TD][TD]World[/TD][TD]10[/TD][/TR]
[TR][TD]Square-1[/TD][TD]Single[/TD][TD]World[/TD][TD]10[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT eventId Event, Kind, Region,
  concat('[url=http://www.worldcubeassociation.org/results/regions.php?regionId=', regionId, '&eventId=', eventId, '&history=History]', count(distinct personId), '[/url]') Holders
FROM (
SELECT eventId, 'World' Region, '' regionId, 'Single' Kind, personId FROM Results WHERE regionalSingleRecord='WR' UNION ALL
SELECT eventId, 'World' Region, '' regionId, 'Average' Kind, personId FROM Results WHERE regionalAverageRecord='WR' UNION ALL
SELECT eventId, Continents.name Region, Continents.id regionId, 'Single' Kind, personId FROM Results join Countries on Countries.id=personCountryId join Continents on Continents.id=continentId WHERE regionalSingleRecord in(recordName, 'WR') UNION ALL
SELECT eventId, Continents.name Region, Continents.id regionId, 'Average' Kind, personId FROM Results join Countries on Countries.id=personCountryId join Continents on Continents.id=continentId WHERE regionalAverageRecord in(recordName, 'WR') UNION ALL
SELECT eventId, personCountryId Region, personCountryId regionId, 'Single' Kind, personId FROM Results WHERE regionalSingleRecord like '%R' UNION ALL
SELECT eventId, personCountryId Region, personCountryId regionId, 'Average' Kind, personId FROM Results WHERE regionalAverageRecord like '%R'
) tmp
GROUP BY eventId, Kind, Region
HAVING count(distinct personId)>=10
ORDER BY count(distinct personId) desc;[/NOPARSE]

 

[Stefan]

Very cool!

Well, to clarify: That doesn't include the times for DNFs, fewest moves and multiblind, and does include +2 penalties. So not quite as pure and cool as it might look at first, but yeah, still kinda cool

 

[Stefan]

O.O Wow this is incredible and seriously what is it with girls and megaminx? (me, yu da hyun, Emily, and the person that did this bld solve )

Thanks for inspiration.

Spoiler: Females in Top 100

Using data from WCA_export478_20140929 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Event[/TD][TD]Kind[/TD][TD]Cuber[/TD][TD]World Rank[/TD][TD]Result[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]Yu Da-Hyun[/TD][TD="align:right"]4[/TD][TD="align:right"]48.86[/TD][/TR]
[TR][TD]6x6 Cube[/TD][TD]Average[/TD][TD]Emily Wang[/TD][TD="align:right"]6[/TD][TD="align:right"]2:06.37[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Average[/TD][TD]Yi Wang (王旖)[/TD][TD="align:right"]6[/TD][TD="align:right"]3.40[/TD][/TR]
[TR][TD]6x6 Cube[/TD][TD]Single[/TD][TD]Emily Wang[/TD][TD="align:right"]8[/TD][TD="align:right"]2:02.41[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Single[/TD][TD]Yu Da-Hyun[/TD][TD="align:right"]8[/TD][TD="align:right"]46.09[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Single[/TD][TD]Yi Wang (王旖)[/TD][TD="align:right"]9[/TD][TD="align:right"]2.12[/TD][/TR]
[TR][TD]3x3 fewest moves[/TD][TD]Single[/TD][TD]Laura Ohrndorf[/TD][TD="align:right"]10[/TD][TD="align:right"]24[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]Emily Wang[/TD][TD="align:right"]15[/TD][TD="align:right"]54.96[/TD][/TR]
[TR][TD]Rubik's Clock[/TD][TD]Average[/TD][TD]Laura Ohrndorf[/TD][TD="align:right"]17[/TD][TD="align:right"]7.65[/TD][/TR]
[TR][TD]Rubik's Clock[/TD][TD]Single[/TD][TD]Laura Ohrndorf[/TD][TD="align:right"]21[/TD][TD="align:right"]6.31[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD]Single[/TD][TD]Shiori Sato (佐藤詩織)[/TD][TD="align:right"]22[/TD][TD="align:right"]17/19 (59:51)[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Single[/TD][TD]Emily Wang[/TD][TD="align:right"]22[/TD][TD="align:right"]51.59[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Single[/TD][TD]Emily Wang[/TD][TD="align:right"]34[/TD][TD="align:right"]1:04.63[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD]Average[/TD][TD]Emily Wang[/TD][TD="align:right"]35[/TD][TD="align:right"]1:11.55[/TD][/TR]
[TR][TD]Rubik's Clock[/TD][TD]Average[/TD][TD]Nikolett Placskó[/TD][TD="align:right"]37[/TD][TD="align:right"]8.43[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Single[/TD][TD]Karina Grandjean Beck[/TD][TD="align:right"]37[/TD][TD="align:right"]54.84[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Average[/TD][TD]Liliya Kamaltdinova[/TD][TD="align:right"]40[/TD][TD="align:right"]58.97[/TD][/TR]
[TR][TD]7x7 Cube[/TD][TD]Average[/TD][TD]Emily Wang[/TD][TD="align:right"]40[/TD][TD="align:right"]3:39.57[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]Karina Grandjean Beck[/TD][TD="align:right"]40[/TD][TD="align:right"]1:03.15[/TD][/TR]
[TR][TD]3x3 with feet[/TD][TD]Average[/TD][TD]Oksana Tyvodar[/TD][TD="align:right"]44[/TD][TD="align:right"]56.61[/TD][/TR]
[TR][TD]7x7 Cube[/TD][TD]Single[/TD][TD]Samantha Raskind[/TD][TD="align:right"]44[/TD][TD="align:right"]3:29.94[/TD][/TR]
[TR][TD]7x7 Cube[/TD][TD]Average[/TD][TD]Samantha Raskind[/TD][TD="align:right"]48[/TD][TD="align:right"]3:44.15[/TD][/TR]
[TR][TD]Rubik's Clock[/TD][TD]Single[/TD][TD]Nikolett Placskó[/TD][TD="align:right"]48[/TD][TD="align:right"]7.12[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Single[/TD][TD]Kalina Brzezińska[/TD][TD="align:right"]48[/TD][TD="align:right"]56.68[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Single[/TD][TD]Emily Wang[/TD][TD="align:right"]49[/TD][TD="align:right"]31.17[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD]Average[/TD][TD]Emily Wang[/TD][TD="align:right"]49[/TD][TD="align:right"]36.00[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD]Average[/TD][TD]Yui Tomita (富田唯依)[/TD][TD="align:right"]50[/TD][TD="align:right"]2.56[/TD][/TR]
[TR][TD]7x7 Cube[/TD][TD]Single[/TD][TD]Emily Wang[/TD][TD="align:right"]50[/TD][TD="align:right"]3:31.58[/TD][/TR]
[TR][TD]3x3 with feet[/TD][TD]Single[/TD][TD]Oksana Tyvodar[/TD][TD="align:right"]52[/TD][TD="align:right"]51.38[/TD][/TR]
[TR][TD]3x3 with feet[/TD][TD]Average[/TD][TD]Mika Muranushi (村主美佳)[/TD][TD="align:right"]52[/TD][TD="align:right"]1:02.44[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]Liliya Kamaltdinova[/TD][TD="align:right"]53[/TD][TD="align:right"]42.19[/TD][/TR]
[TR][TD]5x5 blindfolded[/TD][TD]Single[/TD][TD]Liliya Kamaltdinova[/TD][TD="align:right"]54[/TD][TD="align:right"]17:26.00[/TD][/TR]
[TR][TD]3x3 with feet[/TD][TD]Single[/TD][TD]Rafaela Oliveira da Silva[/TD][TD="align:right"]60[/TD][TD="align:right"]56.43[/TD][/TR]
[TR][TD]Square-1[/TD][TD]Single[/TD][TD]Alexandra Daryl Ariawan[/TD][TD="align:right"]61[/TD][TD="align:right"]13.52[/TD][/TR]
[TR][TD]3x3 with feet[/TD][TD]Single[/TD][TD]Mika Muranushi (村主美佳)[/TD][TD="align:right"]63[/TD][TD="align:right"]57.08[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]Sesi Cadmus[/TD][TD="align:right"]65[/TD][TD="align:right"]46.71[/TD][/TR]
[TR][TD]4x4 blindfolded[/TD][TD]Single[/TD][TD]Liliya Kamaltdinova[/TD][TD="align:right"]67[/TD][TD="align:right"]7:21.33[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD]Single[/TD][TD]Sesi Cadmus[/TD][TD="align:right"]69[/TD][TD="align:right"]9/10 (46:34)[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]Kalina Brzezińska[/TD][TD="align:right"]71[/TD][TD="align:right"]1:09.06[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD]Single[/TD][TD]Sanae Omyo (大名佐苗)[/TD][TD="align:right"]76[/TD][TD="align:right"]9/10 (55:01)[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Single[/TD][TD]Karina Grandjean Beck[/TD][TD="align:right"]76[/TD][TD="align:right"]2.88[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Single[/TD][TD]Sydney Weaver[/TD][TD="align:right"]77[/TD][TD="align:right"]1:01.50[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD]Single[/TD][TD]Jael Riggenbach[/TD][TD="align:right"]80[/TD][TD="align:right"]51.45[/TD][/TR]
[TR][TD]3x3 with feet[/TD][TD]Average[/TD][TD]Rafaela Oliveira da Silva[/TD][TD="align:right"]80[/TD][TD="align:right"]1:14.31[/TD][/TR]
[TR][TD]Square-1[/TD][TD]Single[/TD][TD]Zoé de Moffarts[/TD][TD="align:right"]80[/TD][TD="align:right"]14.13[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD]Single[/TD][TD]Michelle Nataniel Yugie[/TD][TD="align:right"]81[/TD][TD="align:right"]8/8 (57:12)[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD]Single[/TD][TD]Gabriela Gierasimiuk[/TD][TD="align:right"]81[/TD][TD="align:right"]2.93[/TD][/TR]
[TR][TD]Skewb[/TD][TD]Single[/TD][TD]Franciszka Cybulska[/TD][TD="align:right"]85[/TD][TD="align:right"]4.14[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD]Single[/TD][TD]Liliya Kamaltdinova[/TD][TD="align:right"]86[/TD][TD="align:right"]8/9 (35:54)[/TD][/TR]
[TR][TD]6x6 Cube[/TD][TD]Average[/TD][TD]Samantha Raskind[/TD][TD="align:right"]87[/TD][TD="align:right"]2:42.28[/TD][/TR]
[TR][TD]5x5 blindfolded[/TD][TD]Single[/TD][TD]Mimmi Leckius[/TD][TD="align:right"]91[/TD][TD="align:right"]28:02.00[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]Xinrui Li (李昕蕊)[/TD][TD="align:right"]92[/TD][TD="align:right"]1:12.02[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD]Single[/TD][TD]Mimmi Leckius[/TD][TD="align:right"]94[/TD][TD="align:right"]7/7 (47:52)[/TD][/TR]
[TR][TD]6x6 Cube[/TD][TD]Single[/TD][TD]Samantha Raskind[/TD][TD="align:right"]94[/TD][TD="align:right"]2:31.24[/TD][/TR]
[TR][TD]Megaminx[/TD][TD]Average[/TD][TD]Sydney Weaver[/TD][TD="align:right"]96[/TD][TD="align:right"]1:12.34[/TD][/TR]
[TR][TD]Square-1[/TD][TD]Average[/TD][TD]Alexandra Daryl Ariawan[/TD][TD="align:right"]97[/TD][TD="align:right"]20.63[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT eventId Event, Kind, personId Cuber, worldRank 'World Rank', best 'Result[R]'
FROM (
SELECT personId, eventId, 'Single' Kind, worldRank, best FROM RanksSingle UNION ALL
SELECT personId, eventId, 'Average' Kind, worldRank, best FROM RanksAverage
) tmp join Persons on Persons.id=personId
WHERE gender='f' and worldRank<=100
ORDER BY worldRank, eventId, best;[/NOPARSE]

 

[Robert-Y]

Thank you for delivering! Sorry yes I did mean to include ties as well as setting the record. As for the variation of my request, thanks. Somehow you managed to fulfil my next request BEFORE I could even ask

 

[Stefan]

Thanks to Kieran as well (my computation had a bug, I noticed because he had different numbers).

 

[kunparekh18]

Which is the slowest 3x3 solve in an average with at least 1 sub-10 solve ? Excluding DNF of course.

 

[Stefan]

Which is the slowest 3x3 solve in an average with at least 1 sub-10 solve ? Excluding DNF of course.

Spoiler: Slowest 3x3 solve in an average with a sub-10 solve

Using data from WCA_export478_20140929 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Worst[/TD][TD]Best[/TD][TD]Competition[/TD][TD]1.[/TD][TD]2.[/TD][TD]3.[/TD][TD]4.[/TD][TD]5.[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]1:18.50[/TD][TD="align:right"]7.25[/TD][TD]Eindhoven Open 2012[/TD][TD="align:right"]7.63[/TD][TD="align:right"]1:18.50[/TD][TD="align:right"]7.25[/TD][TD="align:right"]7.53[/TD][TD="align:right"]8.15[/TD][/TR]
[TR][TD]Edward Lin[/TD][TD="align:right"]1:13.15[/TD][TD="align:right"]9.61[/TD][TD]Caltech Winter 2013[/TD][TD="align:right"]9.77[/TD][TD="align:right"]9.61[/TD][TD="align:right"]1:13.15[/TD][TD="align:right"]9.96[/TD][TD="align:right"]10.19[/TD][/TR]
[TR][TD]Mateusz Śliż[/TD][TD="align:right"]1:04.04[/TD][TD="align:right"]9.81[/TD][TD]Polish Nationals 2014[/TD][TD="align:right"]14.30[/TD][TD="align:right"]10.91[/TD][TD="align:right"]11.49[/TD][TD="align:right"]1:04.04[/TD][TD="align:right"]9.81[/TD][/TR]
[TR][TD]Shubham Kumar[/TD][TD="align:right"]1:01.76[/TD][TD="align:right"]9.42[/TD][TD]NCR Open 2014[/TD][TD="align:right"]11.45[/TD][TD="align:right"]1:01.76[/TD][TD="align:right"]11.94[/TD][TD="align:right"]10.89[/TD][TD="align:right"]9.42[/TD][/TR]
[TR][TD]Vincent Sheu[/TD][TD="align:right"]1:00.03[/TD][TD="align:right"]9.35[/TD][TD]World Championship 2013[/TD][TD="align:right"]15.45[/TD][TD="align:right"]10.31[/TD][TD="align:right"]13.51[/TD][TD="align:right"]9.35[/TD][TD="align:right"]1:00.03[/TD][/TR]
[TR][TD]Sergey Ryabko[/TD][TD="align:right"]56.00[/TD][TD="align:right"]8.09[/TD][TD]MPEI Open 2012[/TD][TD="align:right"]11.80[/TD][TD="align:right"]10.06[/TD][TD="align:right"]56.00[/TD][TD="align:right"]13.63[/TD][TD="align:right"]8.09[/TD][/TR]
[TR][TD]Kevin Costello III[/TD][TD="align:right"]55.45[/TD][TD="align:right"]8.43[/TD][TD]CCFC Fall 2013[/TD][TD="align:right"]11.22[/TD][TD="align:right"]55.45[/TD][TD="align:right"]8.43[/TD][TD="align:right"]10.16[/TD][TD="align:right"]10.14[/TD][/TR]
[TR][TD]Armin Soleimani (آرمین سلیمانی)[/TD][TD="align:right"]53.27[/TD][TD="align:right"]9.47[/TD][TD]Iran Summer Cube 2013[/TD][TD="align:right"]53.27[/TD][TD="align:right"]12.05[/TD][TD="align:right"]9.47[/TD][TD="align:right"]13.13[/TD][TD="align:right"]12.83[/TD][/TR]
[TR][TD]Wojciech Szatanowski[/TD][TD="align:right"]53.17[/TD][TD="align:right"]9.11[/TD][TD]Radom Open 2013[/TD][TD="align:right"]12.03[/TD][TD="align:right"]10.14[/TD][TD="align:right"]53.17[/TD][TD="align:right"]11.67[/TD][TD="align:right"]9.11[/TD][/TR]
[TR][TD]Yu Sajima (佐島優)[/TD][TD="align:right"]50.81[/TD][TD="align:right"]9.83[/TD][TD]Tachikawa 2013[/TD][TD="align:right"]9.93[/TD][TD="align:right"]50.81[/TD][TD="align:right"]9.83[/TD][TD="align:right"]10.69[/TD][TD="align:right"]11.22[/TD][/TR]
[TR][TD]Stephen Adhisaputra[/TD][TD="align:right"]50.11[/TD][TD="align:right"]8.02[/TD][TD]Jakarta Cube Day 2014[/TD][TD="align:right"]8.02[/TD][TD="align:right"]10.25[/TD][TD="align:right"]9.65[/TD][TD="align:right"]9.46[/TD][TD="align:right"]50.11[/TD][/TR]
[TR][TD]Cameron Stollery[/TD][TD="align:right"]49.15[/TD][TD="align:right"]9.84[/TD][TD]Melbourne Cube Day 2013[/TD][TD="align:right"]49.15[/TD][TD="align:right"]9.84[/TD][TD="align:right"]10.83[/TD][TD="align:right"]12.00[/TD][TD="align:right"]14.15[/TD][/TR]
[TR][TD]Dario Roa Sánchez[/TD][TD="align:right"]45.32[/TD][TD="align:right"]9.32[/TD][TD]Les Santes Open 2014[/TD][TD="align:right"]9.32[/TD][TD="align:right"]10.34[/TD][TD="align:right"]45.32[/TD][TD="align:right"]10.96[/TD][TD="align:right"]9.79[/TD][/TR]
[TR][TD]Hao-Zheng Lin (林浩正)[/TD][TD="align:right"]44.90[/TD][TD="align:right"]9.21[/TD][TD]Mingdao Carnival 2014[/TD][TD="align:right"]9.21[/TD][TD="align:right"]9.78[/TD][TD="align:right"]44.90[/TD][TD="align:right"]9.99[/TD][TD="align:right"]25.98[/TD][/TR]
[TR][TD]Morten Arborg[/TD][TD="align:right"]43.65[/TD][TD="align:right"]8.88[/TD][TD]Helsinki Open 2011[/TD][TD="align:right"]11.25[/TD][TD="align:right"]43.65[/TD][TD="align:right"]8.88[/TD][TD="align:right"]9.36[/TD][TD="align:right"]11.05[/TD][/TR]
[TR][TD]Daniel Gloppestad Bajer[/TD][TD="align:right"]41.11[/TD][TD="align:right"]9.58[/TD][TD]Oslo 3x3 2013[/TD][TD="align:right"]10.43[/TD][TD="align:right"]9.58[/TD][TD="align:right"]10.50[/TD][TD="align:right"]11.46[/TD][TD="align:right"]41.11[/TD][/TR]
[TR][TD]Daniel Yeo Sian Leng[/TD][TD="align:right"]40.00[/TD][TD="align:right"]9.94[/TD][TD]World Championship 2011[/TD][TD="align:right"]9.94[/TD][TD="align:right"]19.02[/TD][TD="align:right"]14.52[/TD][TD="align:right"]11.03[/TD][TD="align:right"]40.00[/TD][/TR]
[TR][TD]John Brechon[/TD][TD="align:right"]40.00[/TD][TD="align:right"]9.00[/TD][TD]UIUC Fall 2013[/TD][TD="align:right"]9.00[/TD][TD="align:right"]9.78[/TD][TD="align:right"]9.83[/TD][TD="align:right"]11.65[/TD][TD="align:right"]40.00[/TD][/TR]
[TR][TD]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/TD][TD="align:right"]39.97[/TD][TD="align:right"]9.21[/TD][TD]Cubing Korea Xmas Eve 2011[/TD][TD="align:right"]DNF[/TD][TD="align:right"]39.97[/TD][TD="align:right"]9.21[/TD][TD="align:right"]9.93[/TD][TD="align:right"]10.86[/TD][/TR]
[TR][TD]Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/TD][TD="align:right"]39.75[/TD][TD="align:right"]8.30[/TD][TD]World Championship 2011[/TD][TD="align:right"]8.80[/TD][TD="align:right"]8.30[/TD][TD="align:right"]39.75[/TD][TD="align:right"]9.15[/TD][TD="align:right"]9.38[/TD][/TR]
[TR][TD]Jonathan Tan Wei Xiat[/TD][TD="align:right"]39.53[/TD][TD="align:right"]9.68[/TD][TD]Cyber Open 2011[/TD][TD="align:right"]10.50[/TD][TD="align:right"]10.94[/TD][TD="align:right"]13.72[/TD][TD="align:right"]39.53[/TD][TD="align:right"]9.68[/TD][/TR]
[TR][TD]Mateusz Śliż[/TD][TD="align:right"]39.32[/TD][TD="align:right"]9.92[/TD][TD]SLS Chorzow 2014[/TD][TD="align:right"]13.23[/TD][TD="align:right"]DNF[/TD][TD="align:right"]13.16[/TD][TD="align:right"]39.32[/TD][TD="align:right"]9.92[/TD][/TR]
[TR][TD]Kevin Costello III[/TD][TD="align:right"]39.05[/TD][TD="align:right"]9.54[/TD][TD]CCFC Fall 2013[/TD][TD="align:right"]10.34[/TD][TD="align:right"]11.05[/TD][TD="align:right"]12.26[/TD][TD="align:right"]39.05[/TD][TD="align:right"]9.54[/TD][/TR]
[TR][TD]Thompson Clarke[/TD][TD="align:right"]38.19[/TD][TD="align:right"]8.33[/TD][TD]Toronto Open Winter 2013[/TD][TD="align:right"]8.33[/TD][TD="align:right"]11.36[/TD][TD="align:right"]12.28[/TD][TD="align:right"]38.19[/TD][TD="align:right"]9.47[/TD][/TR]
[TR][TD]Arifumi Fushimi (伏見有史)[/TD][TD="align:right"]36.90[/TD][TD="align:right"]8.90[/TD][TD]Kawasaki Open 2010[/TD][TD="align:right"]11.18[/TD][TD="align:right"]8.90[/TD][TD="align:right"]36.90[/TD][TD="align:right"]12.25[/TD][TD="align:right"]11.43[/TD][/TR]
[TR][TD]Ben Yu (虞润川)[/TD][TD="align:right"]36.08[/TD][TD="align:right"]9.15[/TD][TD]Vancouver Summer 2013[/TD][TD="align:right"]12.90[/TD][TD="align:right"]14.19[/TD][TD="align:right"]9.15[/TD][TD="align:right"]36.08[/TD][TD="align:right"]15.33[/TD][/TR]
[TR][TD]Dong-Hyun Kim (김동현)[/TD][TD="align:right"]35.94[/TD][TD="align:right"]9.55[/TD][TD]Korean Style 2013[/TD][TD="align:right"]11.81[/TD][TD="align:right"]9.55[/TD][TD="align:right"]25.22[/TD][TD="align:right"]11.40[/TD][TD="align:right"]35.94[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD="align:right"]35.63[/TD][TD="align:right"]9.75[/TD][TD]Wroclaw Open 2009[/TD][TD="align:right"]35.63[/TD][TD="align:right"]9.75[/TD][TD="align:right"]11.91[/TD][TD="align:right"]12.30[/TD][TD="align:right"]12.28[/TD][/TR]
[TR][TD]Robert Yau[/TD][TD="align:right"]35.15[/TD][TD="align:right"]8.59[/TD][TD]Euro 2012[/TD][TD="align:right"]10.90[/TD][TD="align:right"]10.43[/TD][TD="align:right"]13.71[/TD][TD="align:right"]8.59[/TD][TD="align:right"]35.15[/TD][/TR]
[TR][TD]Hunor Bózsing[/TD][TD="align:right"]35.11[/TD][TD="align:right"]9.41[/TD][TD]Ljubljana 2013[/TD][TD="align:right"]11.69[/TD][TD="align:right"]11.59[/TD][TD="align:right"]10.34[/TD][TD="align:right"]9.41[/TD][TD="align:right"]35.11[/TD][/TR]
[TR][TD]Christian Dirks[/TD][TD="align:right"]34.90[/TD][TD="align:right"]9.00[/TD][TD]Aachen Summer 2012[/TD][TD="align:right"]13.50[/TD][TD="align:right"]11.38[/TD][TD="align:right"]10.34[/TD][TD="align:right"]9.00[/TD][TD="align:right"]34.90[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]34.77[/TD][TD="align:right"]7.94[/TD][TD]US Nationals 2012[/TD][TD="align:right"]11.77[/TD][TD="align:right"]10.08[/TD][TD="align:right"]34.77[/TD][TD="align:right"]9.63[/TD][TD="align:right"]7.94[/TD][/TR]
[TR][TD]Peter Chau[/TD][TD="align:right"]34.69[/TD][TD="align:right"]9.68[/TD][TD]Newport Cube Day 2014[/TD][TD="align:right"]10.53[/TD][TD="align:right"]9.68[/TD][TD="align:right"]34.69[/TD][TD="align:right"]15.03[/TD][TD="align:right"]10.97[/TD][/TR]
[TR][TD]Marco Rota[/TD][TD="align:right"]34.52[/TD][TD="align:right"]9.56[/TD][TD]Legnano Open 2012[/TD][TD="align:right"]16.36[/TD][TD="align:right"]DNF[/TD][TD="align:right"]9.56[/TD][TD="align:right"]16.46[/TD][TD="align:right"]34.52[/TD][/TR]
[TR][TD]Forte Shinko[/TD][TD="align:right"]34.30[/TD][TD="align:right"]9.63[/TD][TD]World Championship 2013[/TD][TD="align:right"]34.30[/TD][TD="align:right"]13.08[/TD][TD="align:right"]9.63[/TD][TD="align:right"]14.47[/TD][TD="align:right"]12.04[/TD][/TR]
[TR][TD]Andrew Kang[/TD][TD="align:right"]34.21[/TD][TD="align:right"]8.91[/TD][TD]Battle of Lexington 2010[/TD][TD="align:right"]9.31[/TD][TD="align:right"]34.21[/TD][TD="align:right"]10.55[/TD][TD="align:right"]8.91[/TD][TD="align:right"]14.44[/TD][/TR]
[TR][TD]Alejandro Aguado Barahona[/TD][TD="align:right"]33.36[/TD][TD="align:right"]9.84[/TD][TD]Euro 2010[/TD][TD="align:right"]11.55[/TD][TD="align:right"]13.71[/TD][TD="align:right"]12.81[/TD][TD="align:right"]9.84[/TD][TD="align:right"]33.36[/TD][/TR]
[TR][TD]Cameron Stollery[/TD][TD="align:right"]33.34[/TD][TD="align:right"]9.02[/TD][TD]Canberra Summer 2014[/TD][TD="align:right"]33.34[/TD][TD="align:right"]13.63[/TD][TD="align:right"]DNF[/TD][TD="align:right"]9.02[/TD][TD="align:right"]12.66[/TD][/TR]
[TR][TD]Guan Ying Chen (陳冠穎)[/TD][TD="align:right"]33.11[/TD][TD="align:right"]9.94[/TD][TD]Taiwan Summer 2012[/TD][TD="align:right"]11.65[/TD][TD="align:right"]12.65[/TD][TD="align:right"]33.11[/TD][TD="align:right"]9.94[/TD][TD="align:right"]14.38[/TD][/TR]
[TR][TD]Ethan Crislip[/TD][TD="align:right"]32.97[/TD][TD="align:right"]8.55[/TD][TD]Ohio Fall 2011[/TD][TD="align:right"]10.40[/TD][TD="align:right"]32.97[/TD][TD="align:right"]8.55[/TD][TD="align:right"]11.16[/TD][TD="align:right"]10.99[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]32.91[/TD][TD="align:right"]8.00[/TD][TD]Liberty Science 2010[/TD][TD="align:right"]8.41[/TD][TD="align:right"]11.25[/TD][TD="align:right"]13.06[/TD][TD="align:right"]32.91[/TD][TD="align:right"]8.00[/TD][/TR]
[TR][TD]Ernesto Gutiérrez Cuba[/TD][TD="align:right"]32.85[/TD][TD="align:right"]8.62[/TD][TD]Back to the Palace 2014[/TD][TD="align:right"]8.62[/TD][TD="align:right"]32.85[/TD][TD="align:right"]13.19[/TD][TD="align:right"]10.19[/TD][TD="align:right"]11.68[/TD][/TR]
[TR][TD]Andrew Ricci[/TD][TD="align:right"]32.80[/TD][TD="align:right"]8.21[/TD][TD]MIT Spring 2012[/TD][TD="align:right"]10.28[/TD][TD="align:right"]32.80[/TD][TD="align:right"]9.38[/TD][TD="align:right"]8.21[/TD][TD="align:right"]10.22[/TD][/TR]
[TR][TD]Xiaobo Jin (金晓波)[/TD][TD="align:right"]32.66[/TD][TD="align:right"]9.55[/TD][TD]Hefei Summer 2012[/TD][TD="align:right"]11.25[/TD][TD="align:right"]25.30[/TD][TD="align:right"]10.28[/TD][TD="align:right"]32.66[/TD][TD="align:right"]9.55[/TD][/TR]
[TR][TD]Jong-Ho Jeong (정종호)[/TD][TD="align:right"]32.00[/TD][TD="align:right"]9.58[/TD][TD]Grenoble Winter 2014[/TD][TD="align:right"]9.61[/TD][TD="align:right"]9.58[/TD][TD="align:right"]32.00[/TD][TD="align:right"]11.94[/TD][TD="align:right"]11.65[/TD][/TR]
[TR][TD]Yi-Fan Wu (吳亦凡)[/TD][TD="align:right"]31.80[/TD][TD="align:right"]8.78[/TD][TD]Hsinchu Winter 2013[/TD][TD="align:right"]9.06[/TD][TD="align:right"]31.80[/TD][TD="align:right"]14.81[/TD][TD="align:right"]9.44[/TD][TD="align:right"]8.78[/TD][/TR]
[TR][TD]Phạm Thế Quyền[/TD][TD="align:right"]31.13[/TD][TD="align:right"]9.75[/TD][TD]Hanoi Open 2010[/TD][TD="align:right"]13.47[/TD][TD="align:right"]13.69[/TD][TD="align:right"]9.75[/TD][TD="align:right"]17.19[/TD][TD="align:right"]31.13[/TD][/TR]
[TR][TD]Preeda Hongpimolmas (ปรีดา หงส์พิมลมาศ)[/TD][TD="align:right"]31.11[/TD][TD="align:right"]9.90[/TD][TD]Asian Championship 2010[/TD][TD="align:right"]13.28[/TD][TD="align:right"]9.90[/TD][TD="align:right"]31.11[/TD][TD="align:right"]11.44[/TD][TD="align:right"]12.81[/TD][/TR]
[TR][TD]Richard McKearney[/TD][TD="align:right"]30.97[/TD][TD="align:right"]9.47[/TD][TD]Bristol Spring 2010[/TD][TD="align:right"]9.47[/TD][TD="align:right"]14.00[/TD][TD="align:right"]30.97[/TD][TD="align:right"]15.84[/TD][TD="align:right"]14.83[/TD][/TR]
[TR][TD]Farzad Karimi (فرزاد کریمی)[/TD][TD="align:right"]30.72[/TD][TD="align:right"]8.97[/TD][TD]Iran Open 2013[/TD][TD="align:right"]10.28[/TD][TD="align:right"]8.97[/TD][TD="align:right"]30.72[/TD][TD="align:right"]13.25[/TD][TD="align:right"]9.16[/TD][/TR]
[TR][TD]Guillain Potron[/TD][TD="align:right"]30.38[/TD][TD="align:right"]9.63[/TD][TD]Barcelona Open 2010[/TD][TD="align:right"]13.93[/TD][TD="align:right"]9.63[/TD][TD="align:right"]13.47[/TD][TD="align:right"]30.38[/TD][TD="align:right"]12.09[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]30.36[/TD][TD="align:right"]9.78[/TD][TD]Düsseldorf Open 2010[/TD][TD="align:right"]30.36[/TD][TD="align:right"]14.94[/TD][TD="align:right"]9.78[/TD][TD="align:right"]11.06[/TD][TD="align:right"]10.97[/TD][/TR]
[TR][TD]Sebastian Weyer[/TD][TD="align:right"]30.23[/TD][TD="align:right"]8.44[/TD][TD]Euro 2014[/TD][TD="align:right"]9.41[/TD][TD="align:right"]8.44[/TD][TD="align:right"]8.47[/TD][TD="align:right"]30.23[/TD][TD="align:right"]9.30[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]30.16[/TD][TD="align:right"]9.88[/TD][TD]Iran Open 2011[/TD][TD="align:right"]14.36[/TD][TD="align:right"]9.88[/TD][TD="align:right"]17.55[/TD][TD="align:right"]15.55[/TD][TD="align:right"]30.16[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD="align:right"]30.11[/TD][TD="align:right"]9.65[/TD][TD]World Championship 2011[/TD][TD="align:right"]10.09[/TD][TD="align:right"]30.11[/TD][TD="align:right"]10.59[/TD][TD="align:right"]10.33[/TD][TD="align:right"]9.65[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT
  personId Cuber,
  greatest(value1, value2, value3, value4, value5) 'Worst[T]',
  best 'Best[T]',
  competitionId Competition,
  value1 '1.[T]', value2 '2.[T]', value3 '3.[T]', value4 '4.[T]', value5 '5.[T]'
FROM Results
WHERE eventId='333' and best>0 and best<1000 and greatest(value1, value2, value3, value4, value5)>=3000
ORDER BY 2 desc;[/NOPARSE]

Spoiler: Slowest 3x3 averages with sub-10 single

Using data from WCA_export478_20140929 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Best[/TD][TD]Average[/TD][TD]Competition[/TD][TD]1.[/TD][TD]2.[/TD][TD]3.[/TD][TD]4.[/TD][TD]5.[/TD][/TR]
[TR][TD]Marco Rota[/TD][TD="align:right"]9.56[/TD][TD="align:right"]22.45[/TD][TD]Legnano Open 2012[/TD][TD="align:right"]16.36[/TD][TD="align:right"]DNF[/TD][TD="align:right"]9.56[/TD][TD="align:right"]16.46[/TD][TD="align:right"]34.52[/TD][/TR]
[TR][TD]Mateusz Śliż[/TD][TD="align:right"]9.92[/TD][TD="align:right"]21.90[/TD][TD]SLS Chorzow 2014[/TD][TD="align:right"]13.23[/TD][TD="align:right"]DNF[/TD][TD="align:right"]13.16[/TD][TD="align:right"]39.32[/TD][TD="align:right"]9.92[/TD][/TR]
[TR][TD]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/TD][TD="align:right"]9.21[/TD][TD="align:right"]20.25[/TD][TD]Cubing Korea Xmas Eve 2011[/TD][TD="align:right"]DNF[/TD][TD="align:right"]39.97[/TD][TD="align:right"]9.21[/TD][TD="align:right"]9.93[/TD][TD="align:right"]10.86[/TD][/TR]
[TR][TD]Cameron Stollery[/TD][TD="align:right"]9.02[/TD][TD="align:right"]19.88[/TD][TD]Canberra Summer 2014[/TD][TD="align:right"]33.34[/TD][TD="align:right"]13.63[/TD][TD="align:right"]DNF[/TD][TD="align:right"]9.02[/TD][TD="align:right"]12.66[/TD][/TR]
[TR][TD]Hao-Zheng Lin (林浩正)[/TD][TD="align:right"]9.22[/TD][TD="align:right"]19.55[/TD][TD]Taipei Open 2011[/TD][TD="align:right"]9.22[/TD][TD="align:right"]29.71[/TD][TD="align:right"]16.40[/TD][TD="align:right"]DNF[/TD][TD="align:right"]12.53[/TD][/TR]
[TR][TD]Daniel Cano Salgado[/TD][TD="align:right"]9.53[/TD][TD="align:right"]19.39[/TD][TD]IV Bogota 2012[/TD][TD="align:right"]DNF[/TD][TD="align:right"]9.53[/TD][TD="align:right"]15.80[/TD][TD="align:right"]27.69[/TD][TD="align:right"]14.69[/TD][/TR]
[TR][TD]Ping-Yueh Huang (黃品越)[/TD][TD="align:right"]9.87[/TD][TD="align:right"]18.65[/TD][TD]Master Challenge 2014[/TD][TD="align:right"]10.25[/TD][TD="align:right"]DNF[/TD][TD="align:right"]9.87[/TD][TD="align:right"]29.75[/TD][TD="align:right"]15.96[/TD][/TR]
[TR][TD]Thomas Schmidt[/TD][TD="align:right"]7.79[/TD][TD="align:right"]18.57[/TD][TD]Danish Open 2014[/TD][TD="align:right"]20.40[/TD][TD="align:right"]19.73[/TD][TD="align:right"]16.89[/TD][TD="align:right"]19.09[/TD][TD="align:right"]7.79[/TD][/TR]
[TR][TD]Tomasz Kiełbasa[/TD][TD="align:right"]9.44[/TD][TD="align:right"]17.86[/TD][TD]Poznan Open 2011[/TD][TD="align:right"]16.00[/TD][TD="align:right"]9.44[/TD][TD="align:right"]20.40[/TD][TD="align:right"]17.19[/TD][TD="align:right"]21.59[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD="align:right"]9.42[/TD][TD="align:right"]17.66[/TD][TD]V-CUBE Athens Open 2013[/TD][TD="align:right"]19.25[/TD][TD="align:right"]9.42[/TD][TD="align:right"]17.33[/TD][TD="align:right"]18.28[/TD][TD="align:right"]17.36[/TD][/TR]
[TR][TD]Xilun Chi (遅熙倫)[/TD][TD="align:right"]9.78[/TD][TD="align:right"]17.63[/TD][TD]West Japan Big Cube 2013[/TD][TD="align:right"]21.33[/TD][TD="align:right"]9.78[/TD][TD="align:right"]15.41[/TD][TD="align:right"]17.91[/TD][TD="align:right"]19.58[/TD][/TR]
[TR][TD]Angus Hannelly[/TD][TD="align:right"]9.86[/TD][TD="align:right"]17.44[/TD][TD]Australian Nationals 2013[/TD][TD="align:right"]20.25[/TD][TD="align:right"]17.15[/TD][TD="align:right"]14.91[/TD][TD="align:right"]9.86[/TD][TD="align:right"]20.61[/TD][/TR]
[TR][TD]Mattias Claesson[/TD][TD="align:right"]8.63[/TD][TD="align:right"]17.30[/TD][TD]Swedish Cubedays 2011[/TD][TD="align:right"]17.50[/TD][TD="align:right"]17.86[/TD][TD="align:right"]16.53[/TD][TD="align:right"]20.58[/TD][TD="align:right"]8.63[/TD][/TR]
[TR][TD]Qingwei Kong (孔庆玮)[/TD][TD="align:right"]9.98[/TD][TD="align:right"]17.23[/TD][TD]Wuxi Open 2013[/TD][TD="align:right"]16.01[/TD][TD="align:right"]20.59[/TD][TD="align:right"]22.87[/TD][TD="align:right"]15.10[/TD][TD="align:right"]9.98[/TD][/TR]
[TR][TD]Frank Ebel[/TD][TD="align:right"]9.94[/TD][TD="align:right"]17.23[/TD][TD]Austrian Open 2012[/TD][TD="align:right"]21.00[/TD][TD="align:right"]15.55[/TD][TD="align:right"]15.13[/TD][TD="align:right"]9.94[/TD][TD="align:right"]DNF[/TD][/TR]
[TR][TD]Stefan Pochmann[/TD][TD="align:right"]9.56[/TD][TD="align:right"]17.21[/TD][TD]Aachen Open 2009[/TD][TD="align:right"]16.83[/TD][TD="align:right"]17.94[/TD][TD="align:right"]17.80[/TD][TD="align:right"]9.56[/TD][TD="align:right"]17.00[/TD][/TR]
[TR][TD]Vincent Sheu[/TD][TD="align:right"]8.55[/TD][TD="align:right"]17.11[/TD][TD]Vidar Open 2011[/TD][TD="align:right"]18.75[/TD][TD="align:right"]19.72[/TD][TD="align:right"]8.55[/TD][TD="align:right"]15.96[/TD][TD="align:right"]16.61[/TD][/TR]
[TR][TD]Davide Merli[/TD][TD="align:right"]7.96[/TD][TD="align:right"]17.01[/TD][TD]Legnano Open 2012[/TD][TD="align:right"]14.96[/TD][TD="align:right"]18.66[/TD][TD="align:right"]7.96[/TD][TD="align:right"]20.90[/TD][TD="align:right"]17.40[/TD][/TR]
[TR][TD]Tuan Nghia Duong[/TD][TD="align:right"]9.31[/TD][TD="align:right"]16.99[/TD][TD]French Open 2010[/TD][TD="align:right"]17.09[/TD][TD="align:right"]18.56[/TD][TD="align:right"]16.41[/TD][TD="align:right"]9.31[/TD][TD="align:right"]17.47[/TD][/TR]
[TR][TD]Jonah Crosby[/TD][TD="align:right"]9.72[/TD][TD="align:right"]16.99[/TD][TD]Lexington Fall 2013[/TD][TD="align:right"]20.71[/TD][TD="align:right"]9.72[/TD][TD="align:right"]14.06[/TD][TD="align:right"]16.21[/TD][TD="align:right"]DNF[/TD][/TR]
[TR][TD]Maciek Jagiełło[/TD][TD="align:right"]9.77[/TD][TD="align:right"]16.85[/TD][TD]Polish Open 2012[/TD][TD="align:right"]16.05[/TD][TD="align:right"]9.77[/TD][TD="align:right"]17.55[/TD][TD="align:right"]21.34[/TD][TD="align:right"]16.94[/TD][/TR]
[TR][TD]Zheng Li (李政)[/TD][TD="align:right"]9.84[/TD][TD="align:right"]16.84[/TD][TD]World Championship 2013[/TD][TD="align:right"]21.18[/TD][TD="align:right"]16.59[/TD][TD="align:right"]20.52[/TD][TD="align:right"]9.84[/TD][TD="align:right"]13.41[/TD][/TR]
[TR][TD]Jonas Brzenczek[/TD][TD="align:right"]9.96[/TD][TD="align:right"]16.65[/TD][TD]Hamburg Open 2014[/TD][TD="align:right"]19.46[/TD][TD="align:right"]18.91[/TD][TD="align:right"]15.55[/TD][TD="align:right"]15.48[/TD][TD="align:right"]9.96[/TD][/TR]
[TR][TD]Shivam Bansal[/TD][TD="align:right"]9.98[/TD][TD="align:right"]16.64[/TD][TD]Indian Nationals 2014[/TD][TD="align:right"]17.36[/TD][TD="align:right"]9.98[/TD][TD="align:right"]17.77[/TD][TD="align:right"]16.73[/TD][TD="align:right"]15.82[/TD][/TR]
[TR][TD]Phil Thomas[/TD][TD="align:right"]9.40[/TD][TD="align:right"]16.64[/TD][TD]Indiana Summer Open 2009[/TD][TD="align:right"]16.56[/TD][TD="align:right"]15.94[/TD][TD="align:right"]9.40[/TD][TD="align:right"]18.06[/TD][TD="align:right"]17.41[/TD][/TR]
[TR][TD]James Hildreth[/TD][TD="align:right"]8.63[/TD][TD="align:right"]16.53[/TD][TD]Leaf Town 2013[/TD][TD="align:right"]21.60[/TD][TD="align:right"]13.53[/TD][TD="align:right"]15.21[/TD][TD="align:right"]8.63[/TD][TD="align:right"]20.86[/TD][/TR]
[TR][TD]Yoshiki Chinen (知念良樹)[/TD][TD="align:right"]9.94[/TD][TD="align:right"]16.33[/TD][TD]Kyushu Open 2013[/TD][TD="align:right"]15.44[/TD][TD="align:right"]16.58[/TD][TD="align:right"]16.96[/TD][TD="align:right"]9.94[/TD][TD="align:right"]18.63[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]9.13[/TD][TD="align:right"]16.31[/TD][TD]US Nationals and Open 2008[/TD][TD="align:right"]21.27[/TD][TD="align:right"]13.46[/TD][TD="align:right"]14.41[/TD][TD="align:right"]9.13[/TD][TD="align:right"]21.06[/TD][/TR]
[TR][TD]Erfan Moradi (عرفان مرادی)[/TD][TD="align:right"]9.78[/TD][TD="align:right"]16.24[/TD][TD]Summer with Cubers 2014[/TD][TD="align:right"]9.78[/TD][TD="align:right"]17.34[/TD][TD="align:right"]13.72[/TD][TD="align:right"]25.06[/TD][TD="align:right"]17.65[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]9.55[/TD][TD="align:right"]16.24[/TD][TD]Netherlands 2007[/TD][TD="align:right"]15.23[/TD][TD="align:right"]19.72[/TD][TD="align:right"]17.53[/TD][TD="align:right"]9.55[/TD][TD="align:right"]15.96[/TD][/TR]
[TR][TD]Christian Foyle[/TD][TD="align:right"]9.65[/TD][TD="align:right"]16.16[/TD][TD]Shepparton Winter 2013[/TD][TD="align:right"]20.88[/TD][TD="align:right"]13.84[/TD][TD="align:right"]9.65[/TD][TD="align:right"]15.65[/TD][TD="align:right"]19.00[/TD][/TR]
[TR][TD]Dong-Hyun Kim (김동현)[/TD][TD="align:right"]9.55[/TD][TD="align:right"]16.14[/TD][TD]Korean Style 2013[/TD][TD="align:right"]11.81[/TD][TD="align:right"]9.55[/TD][TD="align:right"]25.22[/TD][TD="align:right"]11.40[/TD][TD="align:right"]35.94[/TD][/TR]
[TR][TD]Supakit Nateeraitaiwa (ศุภกิตติ์ นทีรัยโทวะ)[/TD][TD="align:right"]9.34[/TD][TD="align:right"]16.07[/TD][TD]Asian Championship 2010[/TD][TD="align:right"]16.90[/TD][TD="align:right"]15.36[/TD][TD="align:right"]15.96[/TD][TD="align:right"]9.34[/TD][TD="align:right"]21.40[/TD][/TR]
[TR][TD]Kaijun Lin (林恺俊)[/TD][TD="align:right"]9.94[/TD][TD="align:right"]16.01[/TD][TD]Guangzhou 3x3 Day 2013[/TD][TD="align:right"]11.13[/TD][TD="align:right"]9.94[/TD][TD="align:right"]DNF[/TD][TD="align:right"]26.34[/TD][TD="align:right"]10.55[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD="align:right"]9.53[/TD][TD="align:right"]16.01[/TD][TD]Prague Open 2014[/TD][TD="align:right"]13.94[/TD][TD="align:right"]13.97[/TD][TD="align:right"]9.53[/TD][TD="align:right"]20.11[/TD][TD="align:right"]DNF[/TD][/TR]
[TR][TD]David Andersson[/TD][TD="align:right"]9.46[/TD][TD="align:right"]16.01[/TD][TD]Stockholm Open 2013[/TD][TD="align:right"]15.05[/TD][TD="align:right"]20.19[/TD][TD="align:right"]16.38[/TD][TD="align:right"]16.61[/TD][TD="align:right"]9.46[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD="align:right"]9.22[/TD][TD="align:right"]16.00[/TD][TD]Lemgo Open 2010[/TD][TD="align:right"]9.75[/TD][TD="align:right"]DNF[/TD][TD="align:right"]13.11[/TD][TD="align:right"]9.22[/TD][TD="align:right"]25.15[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT
  personId Cuber,
  best 'Best[T]',
  average 'Average[T]',
  competitionId Competition,
  value1 '1.[T]', value2 '2.[T]', value3 '3.[T]', value4 '4.[T]', value5 '5.[T]'
FROM Results
WHERE eventId='333' and best>0 and best<1000 and average>=1600
ORDER BY average desc;[/NOPARSE]

 

[TMOY]

This can't possibly be the correct result, sorry. For example, Mats Valk's former 7.77 avg ER, which definitely contains sub-10 solves, also contains a 1:18.59 (caused by a big pop).

 

[kinch2002]

Oops he left the "average >16 seconds" criteria in the first list

 

[supercavitation]

Oops he left the "average >16 seconds" criteria in the first list

I was going to say, John Brechon's average from US Nationals Finals is also missing (11.21 Average with a 9.28 single and a 29.92 single).

 

[Stefan]

Oops, thanks Francois and Daniel. Fixed now. John still doesn't make the list, as I now cut off at 30 seconds

 

[Lid]

Here is what I got, no cut off!

Spoiler: Slowest 3x3 solve in an average with a sub-10 solve

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]ID[/TD][TD]Worst[/TD][TD]Best[/TD][TD]Competition[/TD][TD]1.[/TD][TD]2.[/TD][TD]3.[/TD][TD]4.[/TD][TD]5.[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD]2007VALK01[/TD][TD]7850[/TD][TD]725[/TD][TD]EindhovenOpen2012[/TD][TD]763[/TD][TD]7850[/TD][TD]725[/TD][TD]753[/TD][TD]815[/TD][/TR]
[TR][TD]Edward Lin[/TD][TD]2008LINE02[/TD][TD]7315[/TD][TD]961[/TD][TD]CaltechWinter2013[/TD][TD]977[/TD][TD]961[/TD][TD]7315[/TD][TD]996[/TD][TD]1019[/TD][/TR]
[TR][TD]Mateusz Śliż[/TD][TD]2012SLIZ01[/TD][TD]6404[/TD][TD]981[/TD][TD]PolishNationals2014[/TD][TD]1430[/TD][TD]1091[/TD][TD]1149[/TD][TD]6404[/TD][TD]981[/TD][/TR]
[TR][TD]Shubham Kumar[/TD][TD]2013KUMA15[/TD][TD]6176[/TD][TD]942[/TD][TD]NationalCubingRegion2014[/TD][TD]1145[/TD][TD]6176[/TD][TD]1194[/TD][TD]1089[/TD][TD]942[/TD][/TR]
[TR][TD]Vincent Sheu[/TD][TD]2006SHEU01[/TD][TD]6003[/TD][TD]935[/TD][TD]WC2013[/TD][TD]1545[/TD][TD]1031[/TD][TD]1351[/TD][TD]935[/TD][TD]6003[/TD][/TR]
[TR][TD]Sergey Ryabko[/TD][TD]2009RYAB01[/TD][TD]5600[/TD][TD]809[/TD][TD]MPEIOpen2012[/TD][TD]1180[/TD][TD]1006[/TD][TD]5600[/TD][TD]1363[/TD][TD]809[/TD][/TR]
[TR][TD]Kevin Costello III[/TD][TD]2012COST01[/TD][TD]5545[/TD][TD]843[/TD][TD]CCFCFall2013[/TD][TD]1122[/TD][TD]5545[/TD][TD]843[/TD][TD]1016[/TD][TD]1014[/TD][/TR]
[TR][TD]Armin Soleimani (آرمین سلیمانی)[/TD][TD]2011SOLE02[/TD][TD]5327[/TD][TD]947[/TD][TD]IranSummerCube2013[/TD][TD]5327[/TD][TD]1205[/TD][TD]947[/TD][TD]1313[/TD][TD]1283[/TD][/TR]
[TR][TD]Wojciech Szatanowski[/TD][TD]2011SZAT01[/TD][TD]5317[/TD][TD]911[/TD][TD]RadomOpen2013[/TD][TD]1203[/TD][TD]1014[/TD][TD]5317[/TD][TD]1167[/TD][TD]911[/TD][/TR]
[TR][TD]Yu Sajima (佐島優)[/TD][TD]2008SAJI01[/TD][TD]5081[/TD][TD]983[/TD][TD]TachikawaFest2013[/TD][TD]993[/TD][TD]5081[/TD][TD]983[/TD][TD]1069[/TD][TD]1122[/TD][/TR]
[TR][TD]Stephen Adhisaputra[/TD][TD]2010ADHI01[/TD][TD]5011[/TD][TD]802[/TD][TD]JakartaCubeDay2014[/TD][TD]802[/TD][TD]1025[/TD][TD]965[/TD][TD]946[/TD][TD]5011[/TD][/TR]
[TR][TD]Cameron Stollery[/TD][TD]2010STOL01[/TD][TD]4915[/TD][TD]984[/TD][TD]MelbourneCubeDay2013[/TD][TD]4915[/TD][TD]984[/TD][TD]1083[/TD][TD]1200[/TD][TD]1415[/TD][/TR]
[TR][TD]Dario Roa Sánchez[/TD][TD]2011SANC02[/TD][TD]4532[/TD][TD]932[/TD][TD]LesSantesOpen2014[/TD][TD]932[/TD][TD]1034[/TD][TD]4532[/TD][TD]1096[/TD][TD]979[/TD][/TR]
[TR][TD]Hao-Zheng Lin (林浩正)[/TD][TD]2008LINH01[/TD][TD]4490[/TD][TD]921[/TD][TD]MingdaoCubeCarnival2014[/TD][TD]921[/TD][TD]978[/TD][TD]4490[/TD][TD]999[/TD][TD]2598[/TD][/TR]
[TR][TD]Morten Arborg[/TD][TD]2010ARBO01[/TD][TD]4365[/TD][TD]888[/TD][TD]HelsinkiOpen2011[/TD][TD]1125[/TD][TD]4365[/TD][TD]888[/TD][TD]936[/TD][TD]1105[/TD][/TR]
[TR][TD]Daniel Gloppestad Bajer[/TD][TD]2009GLOP01[/TD][TD]4111[/TD][TD]958[/TD][TD]Oslo2013[/TD][TD]1043[/TD][TD]958[/TD][TD]1050[/TD][TD]1146[/TD][TD]4111[/TD][/TR]
[TR][TD]John Brechon[/TD][TD]2010BREC01[/TD][TD]4000[/TD][TD]900[/TD][TD]UIUCFall2013[/TD][TD]900[/TD][TD]978[/TD][TD]983[/TD][TD]1165[/TD][TD]4000[/TD][/TR]
[TR][TD]Daniel Yeo Sian Leng[/TD][TD]2010LENG01[/TD][TD]4000[/TD][TD]994[/TD][TD]WC2011[/TD][TD]994[/TD][TD]1902[/TD][TD]1452[/TD][TD]1103[/TD][TD]4000[/TD][/TR]
[TR][TD]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/TD][TD]2009PICH01[/TD][TD]3997[/TD][TD]921[/TD][TD]CubingKoreaXmasEve2011[/TD][TD]DNF[/TD][TD]3997[/TD][TD]921[/TD][TD]993[/TD][TD]1086[/TD][/TR]
[TR][TD]Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/TD][TD]2009CHAR03[/TD][TD]3975[/TD][TD]830[/TD][TD]WC2011[/TD][TD]880[/TD][TD]830[/TD][TD]3975[/TD][TD]915[/TD][TD]938[/TD][/TR]
[TR][TD]Jonathan Tan Wei Xiat[/TD][TD]2009XIAT02[/TD][TD]3953[/TD][TD]968[/TD][TD]CyberOpen2011[/TD][TD]1050[/TD][TD]1094[/TD][TD]1372[/TD][TD]3953[/TD][TD]968[/TD][/TR]
[TR][TD]Mateusz Śliż[/TD][TD]2012SLIZ01[/TD][TD]3932[/TD][TD]992[/TD][TD]SLSChorzow2014[/TD][TD]1323[/TD][TD]DNF[/TD][TD]1316[/TD][TD]3932[/TD][TD]992[/TD][/TR]
[TR][TD]Kevin Costello III[/TD][TD]2012COST01[/TD][TD]3905[/TD][TD]954[/TD][TD]CCFCFall2013[/TD][TD]1034[/TD][TD]1105[/TD][TD]1226[/TD][TD]3905[/TD][TD]954[/TD][/TR]
[TR][TD]Thompson Clarke[/TD][TD]2008CLAR01[/TD][TD]3819[/TD][TD]833[/TD][TD]TorontoOpenWinter2013[/TD][TD]833[/TD][TD]1136[/TD][TD]1228[/TD][TD]3819[/TD][TD]947[/TD][/TR]
[TR][TD]Arifumi Fushimi (伏見有史)[/TD][TD]2009FUSH01[/TD][TD]3690[/TD][TD]890[/TD][TD]KawasakiOpen2010[/TD][TD]1118[/TD][TD]890[/TD][TD]3690[/TD][TD]1225[/TD][TD]1143[/TD][/TR]
[TR][TD]Ben Yu (虞润川)[/TD][TD]2011YUBE01[/TD][TD]3608[/TD][TD]915[/TD][TD]VancouverOpenSummer2013[/TD][TD]1290[/TD][TD]1419[/TD][TD]915[/TD][TD]3608[/TD][TD]1533[/TD][/TR]
[TR][TD]Dong-Hyun Kim (김동현)[/TD][TD]2012KIMD01[/TD][TD]3594[/TD][TD]955[/TD][TD]KoreanStyle2013[/TD][TD]1181[/TD][TD]955[/TD][TD]2522[/TD][TD]1140[/TD][TD]3594[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD]2005ZOLN01[/TD][TD]3563[/TD][TD]975[/TD][TD]WroclawOpen2009[/TD][TD]3563[/TD][TD]975[/TD][TD]1191[/TD][TD]1230[/TD][TD]1228[/TD][/TR]
[TR][TD]Robert Yau[/TD][TD]2009YAUR01[/TD][TD]3515[/TD][TD]859[/TD][TD]Euro2012[/TD][TD]1090[/TD][TD]1043[/TD][TD]1371[/TD][TD]859[/TD][TD]3515[/TD][/TR]
[TR][TD]Hunor Bózsing[/TD][TD]2009BOZS01[/TD][TD]3511[/TD][TD]941[/TD][TD]LjubljanaOpen2013[/TD][TD]1169[/TD][TD]1159[/TD][TD]1034[/TD][TD]941[/TD][TD]3511[/TD][/TR]
[TR][TD]Christian Dirks[/TD][TD]2010DIRK01[/TD][TD]3490[/TD][TD]900[/TD][TD]AachenSummer2012[/TD][TD]1350[/TD][TD]1138[/TD][TD]1034[/TD][TD]900[/TD][TD]3490[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD]2007HESS01[/TD][TD]3477[/TD][TD]794[/TD][TD]USNationals2012[/TD][TD]1177[/TD][TD]1008[/TD][TD]3477[/TD][TD]963[/TD][TD]794[/TD][/TR]
[TR][TD]Peter Chau[/TD][TD]2011CHAU05[/TD][TD]3469[/TD][TD]968[/TD][TD]NewportCubeDay2014[/TD][TD]1053[/TD][TD]968[/TD][TD]3469[/TD][TD]1503[/TD][TD]1097[/TD][/TR]
[TR][TD]Marco Rota[/TD][TD]2009ROTA01[/TD][TD]3452[/TD][TD]956[/TD][TD]LegnanoOpen2012[/TD][TD]1636[/TD][TD]DNF[/TD][TD]956[/TD][TD]1646[/TD][TD]3452[/TD][/TR]
[TR][TD]Forte Shinko[/TD][TD]2009SHIN02[/TD][TD]3430[/TD][TD]963[/TD][TD]WC2013[/TD][TD]3430[/TD][TD]1308[/TD][TD]963[/TD][TD]1447[/TD][TD]1204[/TD][/TR]
[TR][TD]Andrew Kang[/TD][TD]2006KANG01[/TD][TD]3421[/TD][TD]891[/TD][TD]BattleOfLexington2010[/TD][TD]931[/TD][TD]3421[/TD][TD]1055[/TD][TD]891[/TD][TD]1444[/TD][/TR]
[TR][TD]Alejandro Aguado Barahona[/TD][TD]2007AGUA01[/TD][TD]3336[/TD][TD]984[/TD][TD]Euro2010[/TD][TD]1155[/TD][TD]1371[/TD][TD]1281[/TD][TD]984[/TD][TD]3336[/TD][/TR]
[TR][TD]Cameron Stollery[/TD][TD]2010STOL01[/TD][TD]3334[/TD][TD]902[/TD][TD]CanberraSummer2014[/TD][TD]3334[/TD][TD]1363[/TD][TD]DNF[/TD][TD]902[/TD][TD]1266[/TD][/TR]
[TR][TD]Guan Ying Chen (陳冠穎)[/TD][TD]2011CHEN03[/TD][TD]3311[/TD][TD]994[/TD][TD]TaiwanSummer2012[/TD][TD]1165[/TD][TD]1265[/TD][TD]3311[/TD][TD]994[/TD][TD]1438[/TD][/TR]
[TR][TD]Ethan Crislip[/TD][TD]2010CRIS01[/TD][TD]3297[/TD][TD]855[/TD][TD]OhioFall2011[/TD][TD]1040[/TD][TD]3297[/TD][TD]855[/TD][TD]1116[/TD][TD]1099[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD]2007HESS01[/TD][TD]3291[/TD][TD]800[/TD][TD]LibertyScience2010[/TD][TD]841[/TD][TD]1125[/TD][TD]1306[/TD][TD]3291[/TD][TD]800[/TD][/TR]
[TR][TD]Ernesto Gutiérrez Cuba[/TD][TD]2011CUBA02[/TD][TD]3285[/TD][TD]862[/TD][TD]BackToThePalace2014[/TD][TD]862[/TD][TD]3285[/TD][TD]1319[/TD][TD]1019[/TD][TD]1168[/TD][/TR]
[TR][TD]Andrew Ricci[/TD][TD]2010RICC02[/TD][TD]3280[/TD][TD]821[/TD][TD]MITSpring2012[/TD][TD]1028[/TD][TD]3280[/TD][TD]938[/TD][TD]821[/TD][TD]1022[/TD][/TR]
[TR][TD]Xiaobo Jin (金晓波)[/TD][TD]2008JINX01[/TD][TD]3266[/TD][TD]955[/TD][TD]HefeiSummer2012[/TD][TD]1125[/TD][TD]2530[/TD][TD]1028[/TD][TD]3266[/TD][TD]955[/TD][/TR]
[TR][TD]Jong-Ho Jeong (정종호)[/TD][TD]2008JONG03[/TD][TD]3200[/TD][TD]958[/TD][TD]GrenobleWinter2014[/TD][TD]961[/TD][TD]958[/TD][TD]3200[/TD][TD]1194[/TD][TD]1165[/TD][/TR]
[TR][TD]Yi-Fan Wu (吳亦凡)[/TD][TD]2010WUIF01[/TD][TD]3180[/TD][TD]878[/TD][TD]HsinchuWinter2013[/TD][TD]906[/TD][TD]3180[/TD][TD]1481[/TD][TD]944[/TD][TD]878[/TD][/TR]
[TR][TD]Phạm Thế Quyền[/TD][TD]2010PHAM08[/TD][TD]3113[/TD][TD]975[/TD][TD]HanoiOpen2010[/TD][TD]1347[/TD][TD]1369[/TD][TD]975[/TD][TD]1719[/TD][TD]3113[/TD][/TR]
[TR][TD]Preeda Hongpimolmas (ปรีดา หงส์พิมลมาศ)[/TD][TD]2009HONG04[/TD][TD]3111[/TD][TD]990[/TD][TD]AsianChampionship2010[/TD][TD]1328[/TD][TD]990[/TD][TD]3111[/TD][TD]1144[/TD][TD]1281[/TD][/TR]
[TR][TD]Richard McKearney[/TD][TD]2008MCKE01[/TD][TD]3097[/TD][TD]947[/TD][TD]BristolSpring2010[/TD][TD]947[/TD][TD]1400[/TD][TD]3097[/TD][TD]1584[/TD][TD]1483[/TD][/TR]
[TR][TD]Farzad Karimi (فرزاد کریمی)[/TD][TD]2011KARI01[/TD][TD]3072[/TD][TD]897[/TD][TD]IranOpen2013[/TD][TD]1028[/TD][TD]897[/TD][TD]3072[/TD][TD]1325[/TD][TD]916[/TD][/TR]
[TR][TD]Guillain Potron[/TD][TD]2008POTR01[/TD][TD]3038[/TD][TD]963[/TD][TD]BarcelonaOpen2010[/TD][TD]1393[/TD][TD]963[/TD][TD]1347[/TD][TD]3038[/TD][TD]1209[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD]2007VALK01[/TD][TD]3036[/TD][TD]978[/TD][TD]DusseldorfOpen2010[/TD][TD]3036[/TD][TD]1494[/TD][TD]978[/TD][TD]1106[/TD][TD]1097[/TD][/TR]
[TR][TD]Sebastian Weyer[/TD][TD]2010WEYE02[/TD][TD]3023[/TD][TD]844[/TD][TD]Euro2014[/TD][TD]941[/TD][TD]844[/TD][TD]847[/TD][TD]3023[/TD][TD]930[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]2003BRUC01[/TD][TD]3016[/TD][TD]988[/TD][TD]IranOpen2011[/TD][TD]1436[/TD][TD]988[/TD][TD]1755[/TD][TD]1555[/TD][TD]3016[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD]2005BATI01[/TD][TD]3011[/TD][TD]965[/TD][TD]WC2011[/TD][TD]1009[/TD][TD]3011[/TD][TD]1059[/TD][TD]1033[/TD][TD]965[/TD][/TR]
[TR][TD]John Brechon[/TD][TD]2010BREC01[/TD][TD]2992[/TD][TD]928[/TD][TD]USNationals2014[/TD][TD]1055[/TD][TD]1145[/TD][TD]928[/TD][TD]2992[/TD][TD]1164[/TD][/TR]
[TR][TD]Jules Desjardin[/TD][TD]2010DESJ01[/TD][TD]2991[/TD][TD]853[/TD][TD]GrenobleWinter2014[/TD][TD]909[/TD][TD]1127[/TD][TD]853[/TD][TD]2991[/TD][TD]1431[/TD][/TR]
[TR][TD]Paolo Moriello[/TD][TD]2009MORI05[/TD][TD]2983[/TD][TD]883[/TD][TD]TiburtinaeOpen2012[/TD][TD]883[/TD][TD]968[/TD][TD]1002[/TD][TD]1093[/TD][TD]2983[/TD][/TR]
[TR][TD]Sergey Ryabko[/TD][TD]2009RYAB01[/TD][TD]2981[/TD][TD]796[/TD][TD]MPEIOpen2012[/TD][TD]1294[/TD][TD]981[/TD][TD]796[/TD][TD]2981[/TD][TD]806[/TD][/TR]
[TR][TD]Ping-Yueh Huang (黃品越)[/TD][TD]2012HUAN12[/TD][TD]2975[/TD][TD]987[/TD][TD]MasterChallenge2014[/TD][TD]1025[/TD][TD]DNF[/TD][TD]987[/TD][TD]2975[/TD][TD]1596[/TD][/TR]
[TR][TD]Drew Brads[/TD][TD]2010BRAD01[/TD][TD]2972[/TD][TD]936[/TD][TD]NewAlbany2013[/TD][TD]1381[/TD][TD]1086[/TD][TD]1136[/TD][TD]936[/TD][TD]2972[/TD][/TR]
[TR][TD]Hao-Zheng Lin (林浩正)[/TD][TD]2008LINH01[/TD][TD]2971[/TD][TD]922[/TD][TD]TaipeiOpen2011[/TD][TD]922[/TD][TD]2971[/TD][TD]1640[/TD][TD]DNF[/TD][TD]1253[/TD][/TR]
[TR][TD]Andrew Verducci[/TD][TD]2011VERD01[/TD][TD]2958[/TD][TD]852[/TD][TD]BigCubingItaly2014[/TD][TD]1053[/TD][TD]1144[/TD][TD]852[/TD][TD]2958[/TD][TD]1103[/TD][/TR]
[TR][TD]Yu Sajima (佐島優)[/TD][TD]2008SAJI01[/TD][TD]2938[/TD][TD]922[/TD][TD]JapanOpen2011[/TD][TD]1253[/TD][TD]922[/TD][TD]1202[/TD][TD]2938[/TD][TD]1065[/TD][/TR]
[TR][TD]Bhargav Narasimhan[/TD][TD]2011NARA02[/TD][TD]2910[/TD][TD]906[/TD][TD]CubingATMOSphere2013[/TD][TD]906[/TD][TD]2910[/TD][TD]1144[/TD][TD]1273[/TD][TD]1487[/TD][/TR]
[TR][TD]Eric Limeback[/TD][TD]2007LIME01[/TD][TD]2908[/TD][TD]986[/TD][TD]TorontoOpenFall2008[/TD][TD]2908[/TD][TD]986[/TD][TD]1325[/TD][TD]1344[/TD][TD]1300[/TD][/TR]
[TR][TD]Sebastian Weyer[/TD][TD]2010WEYE02[/TD][TD]2900[/TD][TD]921[/TD][TD]GermanNationals2011[/TD][TD]1050[/TD][TD]2900[/TD][TD]921[/TD][TD]958[/TD][TD]1130[/TD][/TR]
[TR][TD]Alexey Polyashov[/TD][TD]2010POLY01[/TD][TD]2896[/TD][TD]997[/TD][TD]TulaOpen2014[/TD][TD]2896[/TD][TD]1519[/TD][TD]997[/TD][TD]1103[/TD][TD]1386[/TD][/TR]
[TR][TD]James Hamory[/TD][TD]2009HAMO01[/TD][TD]2875[/TD][TD]871[/TD][TD]CaltechSpring2014[/TD][TD]1105[/TD][TD]902[/TD][TD]871[/TD][TD]1215[/TD][TD]2875[/TD][/TR]
[TR][TD]Kirt Protacio[/TD][TD]2010PROT01[/TD][TD]2868[/TD][TD]958[/TD][TD]MelbourneWinter2014[/TD][TD]1108[/TD][TD]2868[/TD][TD]1243[/TD][TD]958[/TD][TD]1065[/TD][/TR]
[TR][TD]Amos Tay Swee Hui[/TD][TD]2009SWEE01[/TD][TD]2866[/TD][TD]959[/TD][TD]TaylorCubeOpen2012[/TD][TD]1055[/TD][TD]959[/TD][TD]1021[/TD][TD]2866[/TD][TD]1478[/TD][/TR]
[TR][TD]David Gugl[/TD][TD]2009GUGL01[/TD][TD]2838[/TD][TD]944[/TD][TD]GELOpen2012[/TD][TD]1650[/TD][TD]1503[/TD][TD]944[/TD][TD]2838[/TD][TD]1552[/TD][/TR]
[TR][TD]You Hyeon-Dong (유현동)[/TD][TD]2011HYEO01[/TD][TD]2836[/TD][TD]941[/TD][TD]KoreanStyle2013[/TD][TD]2836[/TD][TD]1136[/TD][TD]963[/TD][TD]941[/TD][TD]1006[/TD][/TR]
[TR][TD]Sergey Ryabko[/TD][TD]2009RYAB01[/TD][TD]2831[/TD][TD]919[/TD][TD]KyivOpen2011[/TD][TD]2831[/TD][TD]1111[/TD][TD]919[/TD][TD]1116[/TD][TD]947[/TD][/TR]
[TR][TD]Shu-Yii Luo (駱書翊)[/TD][TD]2012LUOS01[/TD][TD]2824[/TD][TD]999[/TD][TD]TaiwanSummerOpen2014[/TD][TD]1354[/TD][TD]999[/TD][TD]1188[/TD][TD]2824[/TD][TD]1333[/TD][/TR]
[TR][TD]Boaz Floor[/TD][TD]2010FLOO01[/TD][TD]2822[/TD][TD]931[/TD][TD]N8W8Summer2012[/TD][TD]931[/TD][TD]2822[/TD][TD]1206[/TD][TD]1471[/TD][TD]1672[/TD][/TR]
[TR][TD]Przemysław Kaleta[/TD][TD]2012KALE01[/TD][TD]2821[/TD][TD]878[/TD][TD]BydgoszczSummer2014[/TD][TD]894[/TD][TD]1129[/TD][TD]2821[/TD][TD]878[/TD][TD]900[/TD][/TR]
[TR][TD]Mitsuki Gunji (郡司光貴)[/TD][TD]2006GUNJ01[/TD][TD]2815[/TD][TD]897[/TD][TD]JapanContestSpring2014[/TD][TD]2815[/TD][TD]916[/TD][TD]897[/TD][TD]1027[/TD][TD]1034[/TD][/TR]
[TR][TD]Yuxuan Wang (王宇轩)[/TD][TD]2009WANG13[/TD][TD]2811[/TD][TD]953[/TD][TD]HarbinOpen2014[/TD][TD]953[/TD][TD]1113[/TD][TD]1215[/TD][TD]2811[/TD][TD]1411[/TD][/TR]
[TR][TD]Edward Lin[/TD][TD]2008LINE02[/TD][TD]2809[/TD][TD]890[/TD][TD]CaltechFall2013[/TD][TD]2809[/TD][TD]1000[/TD][TD]1138[/TD][TD]1078[/TD][TD]890[/TD][/TR]
[TR][TD]Teo Kai Xiang[/TD][TD]2009XIAN01[/TD][TD]2806[/TD][TD]931[/TD][TD]NUS2011[/TD][TD]1208[/TD][TD]1086[/TD][TD]1019[/TD][TD]931[/TD][TD]2806[/TD][/TR]
[TR][TD]Bohdan Hromchak (Богдан Громчак)[/TD][TD]2012HROM01[/TD][TD]2796[/TD][TD]938[/TD][TD]UkrainianNationals2014[/TD][TD]1343[/TD][TD]1063[/TD][TD]938[/TD][TD]1506[/TD][TD]2796[/TD][/TR]
[TR][TD]Phillip Espinoza[/TD][TD]2007ESPI01[/TD][TD]2781[/TD][TD]966[/TD][TD]SanDiego2011[/TD][TD]1058[/TD][TD]2781[/TD][TD]1261[/TD][TD]966[/TD][TD]1255[/TD][/TR]
[TR][TD]Lin Chen (陈霖)[/TD][TD]2010CHEN20[/TD][TD]2781[/TD][TD]984[/TD][TD]QingdaoOpen2012[/TD][TD]984[/TD][TD]1366[/TD][TD]2781[/TD][TD]1069[/TD][TD]1055[/TD][/TR]
[TR][TD]Maarten Smit[/TD][TD]2008SMIT04[/TD][TD]2780[/TD][TD]936[/TD][TD]Euro2012[/TD][TD]936[/TD][TD]1047[/TD][TD]1088[/TD][TD]1102[/TD][TD]2780[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]2005AKKE01[/TD][TD]2771[/TD][TD]986[/TD][TD]BeneluxOpen2010[/TD][TD]986[/TD][TD]1043[/TD][TD]1033[/TD][TD]1259[/TD][TD]2771[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD]2007VALK01[/TD][TD]2769[/TD][TD]821[/TD][TD]N8W8Summer2012[/TD][TD]968[/TD][TD]865[/TD][TD]1194[/TD][TD]821[/TD][TD]2769[/TD][/TR]
[TR][TD]Daniel Cano Salgado[/TD][TD]2011SALG01[/TD][TD]2769[/TD][TD]953[/TD][TD]IVBogota2012[/TD][TD]DNF[/TD][TD]953[/TD][TD]1580[/TD][TD]2769[/TD][TD]1469[/TD][/TR]
[TR][TD]Shinichiro Sato (佐藤真一郎)[/TD][TD]2009SATO02[/TD][TD]2728[/TD][TD]830[/TD][TD]ThanksCubingDay2014[/TD][TD]830[/TD][TD]2728[/TD][TD]1148[/TD][TD]1076[/TD][TD]984[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]2005AKKE01[/TD][TD]2715[/TD][TD]852[/TD][TD]DutchOpen2011[/TD][TD]968[/TD][TD]931[/TD][TD]1034[/TD][TD]2715[/TD][TD]852[/TD][/TR]
[TR][TD]Ali Dadfar (علی دادفر)[/TD][TD]2011DADF01[/TD][TD]2694[/TD][TD]877[/TD][TD]IranSummerCube2013[/TD][TD]2694[/TD][TD]1086[/TD][TD]1284[/TD][TD]877[/TD][TD]1211[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]2005AKKE01[/TD][TD]2680[/TD][TD]927[/TD][TD]VCubeSpiel2011[/TD][TD]927[/TD][TD]1033[/TD][TD]2680[/TD][TD]1219[/TD][TD]1036[/TD][/TR]
[TR][TD]Nan Bai (柏楠)[/TD][TD]2011BAIN01[/TD][TD]2675[/TD][TD]986[/TD][TD]WenzhouOpen2013[/TD][TD]1734[/TD][TD]986[/TD][TD]1206[/TD][TD]2675[/TD][TD]1206[/TD][/TR]
[TR][TD]Takuma Shirahase (白波瀬拓磨)[/TD][TD]2007SHIR01[/TD][TD]2671[/TD][TD]968[/TD][TD]MatsudoSpring2011[/TD][TD]1641[/TD][TD]968[/TD][TD]1571[/TD][TD]1275[/TD][TD]2671[/TD][/TR]
[TR][TD]Kevin Hays[/TD][TD]2009HAYS01[/TD][TD]2663[/TD][TD]825[/TD][TD]VancouverOpenSummer2013[/TD][TD]2663[/TD][TD]900[/TD][TD]825[/TD][TD]971[/TD][TD]1106[/TD][/TR]
[TR][TD]Daniel Waldir Rodrigues Rosa[/TD][TD]2011ROSA06[/TD][TD]2661[/TD][TD]955[/TD][TD]GoianiaOpen2013[/TD][TD]1321[/TD][TD]2661[/TD][TD]955[/TD][TD]1046[/TD][TD]1144[/TD][/TR]
[TR][TD]Pedro Santos Guimarães[/TD][TD]2007GUIM01[/TD][TD]2652[/TD][TD]959[/TD][TD]SESCPompeia2013[/TD][TD]1303[/TD][TD]2652[/TD][TD]1190[/TD][TD]959[/TD][TD]1231[/TD][/TR]
[TR][TD]Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/TD][TD]2009CHAR03[/TD][TD]2646[/TD][TD]947[/TD][TD]PhitsanulokOpen2011[/TD][TD]947[/TD][TD]1144[/TD][TD]991[/TD][TD]1025[/TD][TD]2646[/TD][/TR]
[TR][TD]Kaijun Lin (林恺俊)[/TD][TD]2013LINK01[/TD][TD]2634[/TD][TD]994[/TD][TD]Guangzhou2013[/TD][TD]1113[/TD][TD]994[/TD][TD]DNF[/TD][TD]2634[/TD][TD]1055[/TD][/TR]
[TR][TD]Hunor Bózsing[/TD][TD]2009BOZS01[/TD][TD]2621[/TD][TD]861[/TD][TD]SerbianOpen2013[/TD][TD]861[/TD][TD]1075[/TD][TD]972[/TD][TD]971[/TD][TD]2621[/TD][/TR]
[/TABLE]

(Too lazy to format further )