Odd WCA stats/ Stats request Thread

Pro94 · Aug 29, 2014

Cale S said:
I had a successful 5BLD before a successful 3BLD. They were at the same comp, but 5BLD was held first.
It was also my second competition. Has anyone gotten a 5BLD success at their first competition?

Roman Strakhov: https://www.worldcubeassociation.org/results/p.php?i=2012STRA02
Habibi: https://www.worldcubeassociation.org/results/p.php?i=2011HABI01#555bf

Habibi on his 1st ever try, Roman on second.

tomatotrucks · Sep 1, 2014

Has anyone who's competed in OH and 3x3 been faster in OH than 3x3?

Bindedsa · Sep 1, 2014

tomatotrucks said:
Has anyone who's competed in OH and 3x3 been faster in OH than 3x3?

I know there have been more, but of the top of my head: Neil Morales. His OH single is faster than his TH single.

antoineccantin · Sep 1, 2014

tomatotrucks said:
Has anyone who's competed in OH and 3x3 been faster in OH than 3x3?

Turbo also had a faster OH than 2H single in 2012: https://www.worldcubeassociation.org/results/p.php?i=2009SUKH01

SolveThatCube · Sep 1, 2014

Bindedsa said:
I know there have been more, but of the top of my head: Neil Morales. His OH single is faster than his TH single.

wow

MTGjumper · Sep 1, 2014

Might have been asked before: which pair of people have been at the most competitions together?

Pro94 · Sep 1, 2014

tomatotrucks said:
Has anyone who's competed in OH and 3x3 been faster in OH than 3x3?

Only 6 for single:

[table="width: 500"]
[tr]
[td]Ratio[/td]
[td]Best 3x3[/td]
[td]Best 3x3 OH[/td]
[td]Name[/td]
[/tr]
[tr]
[td]1.1275[/td]
[td]28.20[/td]
[td]25.01[/td]
[td]Yanquan Wen[/td]
[/tr]
[tr]
[td]1.0721[/td]
[td]17.09[/td]
[td]15.94[/td]
[td]Yaozong Liang[/td]
[/tr]
[tr]
[td]1.0708[/td]
[td]307.36[/td]
[td]287.05[/td]
[td]Zhiquiang Hao[/td]
[/tr]
[tr]
[td]1.0624[/td]
[td]9.88[/td]
[td]9.30[/td]
[td]Neil Morales[/td]
[/tr]
[tr]
[td]1.0322[/td]
[td]16.02[/td]
[td]15.52[/td]
[td]Chun Lin[/td]
[/tr]
[tr]
[td]1.0317[/td]
[td]18.86[/td]
[td]18.28[/td]
[td]Pu Su[/td]
[/tr]
[/table]

And 2 for average:

[table="width: 500"]
[tr]
[td]Ratio[/td]
[td]Best 3x3[/td]
[td]Best 3x3 OH[/td]
[td]Name[/td]
[/tr]
[tr]
[td]1.0131[/td]
[td]26.39[/td]
[td]26.05[/td]
[td]Julia Angel Lopez Borja[/td]
[/tr]
[tr]
[td]1.0094[/td]
[td]31.17[/td]
[td]30.88[/td]
[td]Chenxi Shan[/td]
[/tr]
[/table]

guysensei1 · Sep 1, 2014

Pro94 said:
Only 6 for single:

[table="width: 500"]
[tr]
[td]Ratio[/td]
[td]Best 3x3[/td]
[td]Best 3x3 OH[/td]
[td]Name[/td]
[/tr]
[tr]
[td]1.1275[/td]
[td]28.20[/td]
[td]25.01[/td]
[td]Yanquan Wen[/td]
[/tr]
[tr]
[td]1.0721[/td]
[td]17.09[/td]
[td]15.94[/td]
[td]Yaozong Liang[/td]
[/tr]
[tr]
[td]1.0708[/td]
[td]307.36[/td]
[td]287.05[/td]
[td]Zhiquiang Hao[/td]
[/tr]
[tr]
[td]1.0624[/td]
[td]9.88[/td]
[td]9.30[/td]
[td]Neil Morales[/td]
[/tr]
[tr]
[td]1.0322[/td]
[td]16.02[/td]
[td]15.52[/td]
[td]Chun Lin[/td]
[/tr]
[tr]
[td]1.0317[/td]
[td]18.86[/td]
[td]18.28[/td]
[td]Pu Su[/td]
[/tr]
[/table]

And 2 for average:

[table="width: 500"]
[tr]
[td]Ratio[/td]
[td]Best 3x3[/td]
[td]Best 3x3 OH[/td]
[td]Name[/td]
[/tr]
[tr]
[td]1.0131[/td]
[td]26.39[/td]
[td]26.05[/td]
[td]Julia Angel Lopez Borja[/td]
[/tr]
[tr]
[td]1.0094[/td]
[td]31.17][/td]
[td]30.88[/td]
[td]Chenxi Shan[/td]
[/tr]
[/table]

heh if i dont participate in 3x3 in my next comp, that number will become 7

Stefan · Sep 1, 2014

MTGjumper said:
Might have been asked before: which pair of people have been at the most competitions together?

Using data from WCA_export458_20140901 and Stefan's WCA statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]personId[/TD][TD]personId[/TD][TD]competitions[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Maria Oey[/TD][TD="align:right"]79[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ton Dennenbroek[/TD][TD="align:right"]75[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Lars Vandenbergh[/TD][TD="align:right"]73[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]72[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Arnaud van Galen[/TD][TD="align:right"]69[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Jaclyn Sawler[/TD][TD="align:right"]68[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD]François Courtès[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Tim Reynolds[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Arnaud van Galen[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]Fumiki Koseki (古関章記)[/TD][TD]Sinpei Araki (荒木慎平)[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Lars Vandenbergh[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Erik Akkersdijk[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Hanneke Rijks[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Jeremy Fleischman[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Fumiki Koseki (古関章記)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]61[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]François Courtès[/TD][TD="align:right"]61[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Kian Barry[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Sébastien Auroux[/TD][TD="align:right"]59[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Arnaud van Galen[/TD][TD="align:right"]59[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Erik Akkersdijk[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Jan Bentlage[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Rowe Hessler[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD]Marcin Jakubowski[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Nobuaki Suga (菅信昭)[/TD][TD]Hideki Niina (新名秀樹)[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Laura Ohrndorf[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Hideki Niina (新名秀樹)[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Mats Valk[/TD][TD="align:right"]56[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Yohei Oka (岡要平)[/TD][TD="align:right"]55[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Arnaud van Galen[/TD][TD="align:right"]55[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD]Rowe Hessler[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]François Courtès[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD]Maria Oey[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Takayuki Ookusa (大艸尊之)[/TD][TD="align:right"]53[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Erik Akkersdijk[/TD][TD="align:right"]53[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Maria Oey[/TD][TD="align:right"]52[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD]Hanneke Rijks[/TD][TD="align:right"]52[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Yu Nakajima (中島悠)[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Maria Oey[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Yu Nakajima (中島悠)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Maria Oey[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Adam Zamora[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Mats Valk[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD]François Courtès[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD]Devin Corr-Robinett[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Devin Corr-Robinett[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD]Kian Barry[/TD][TD="align:right"]50[/TD][/TR]
[/TABLE]

CREATE TABLE participations
SELECT distinct Results.personId, competitionId
FROM Results
WHERE personId in (SELECT personId FROM Results GROUP BY personId HAVING count(distinct competitionId)>=50);

SELECT a.personId, b.personId, count(*) competitions
FROM participations a, participations b
WHERE a.competitionId=b.competitionId and a.personId<b.personId
GROUP BY a.personId, b.personId
HAVING competitions>=50
ORDER BY competitions desc;

DROP TABLE participations;

Using data from WCA_export458_20140901 and Stefan's WCA statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]personId[/TD][TD]personId[/TD][TD]personId[/TD][TD]competitions[/TD][/TR]
[TR][TD]Fumiki Koseki (古関章記)[/TD][TD]Sinpei Araki (荒木慎平)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ton Dennenbroek[/TD][TD]Lars Vandenbergh[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD]Hideki Niina (新名秀樹)[/TD][TD="align:right"]53[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Arnaud van Galen[/TD][TD]Maria Oey[/TD][TD="align:right"]52[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ton Dennenbroek[/TD][TD]Erik Akkersdijk[/TD][TD="align:right"]52[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Erik Akkersdijk[/TD][TD]Maria Oey[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Lars Vandenbergh[/TD][TD]Maria Oey[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Mats Valk[/TD][TD]Hanneke Rijks[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ton Dennenbroek[/TD][TD]Maria Oey[/TD][TD="align:right"]50[/TD][/TR]
[/TABLE]

CREATE TABLE participations
SELECT distinct Results.personId, competitionId
FROM Results
WHERE personId in (SELECT personId FROM Results GROUP BY personId HAVING count(distinct competitionId)>=50);

SELECT a.personId, b.personId, c.personId, count(*) competitions
FROM participations a, participations b, participations c
WHERE a.competitionId=b.competitionId and a.competitionId=c.competitionId and a.personId<b.personId and b.personId<c.personId
GROUP BY a.personId, b.personId, c.personId
HAVING competitions>=50
ORDER BY competitions desc;

DROP TABLE participations;

Robert-Y · Sep 1, 2014

Thanks Stefan! I was thinking of this request too but I never asked because I just assumed that perhaps it's too hard to fulfil. I have a (weird) related request.

Longest time taken for any two competitors to "reunite"? e.g. Competitors A and B compete in 2009 and never compete with each other again until 2014. So the time taken for them to reunite is 5 years.

Cale S · Sep 1, 2014

Robert-Y said:
Longest time taken for any two competitors to "reunite"? e.g. Competitors A and B compete in 2009 and never compete with each other again until 2014. So the time taken for them to reunite is 5 years.

21 years for Jessica Fridrich and Lars Petrus. Not sure who it'd be if you don't include WC1982.

How many people have WCA profiles but no results other than DNF or DNS?

TMOY · Sep 1, 2014

Cale S said:
21 years for Jessica Fridrich and Lars Petrus. Not sure who it'd be if you don't include WC1982.

Not sure of who it would be if you included the comps of ths 80s (including only WC82 is artificial), but my guess is 31 years for Guus Razoux Schulz and Marc Waterman. My own PB is 26 years 10 months (with Stéphane Escaich).

Mike Hughey · Sep 1, 2014

Having fun trying out Stefan's tool:

Using data from WCA_export458_20140901 and Stefan's WCA forum statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]rank[/TD][TD]name[/TD][TD]year[/TD][TD]personIds[/TD][/TR]
[TR][TD]1[/TD][TD]World Rubik's Cube Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]580[/TD][/TR]
[TR][TD]2[/TD][TD]US Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]497[/TD][/TR]
[TR][TD]3[/TD][TD]World Rubik's Cube Championship 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]327[/TD][/TR]
[TR][TD]4[/TD][TD]World Rubik's Cube Championship 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]292[/TD][/TR]
[TR][TD]5[/TD][TD]European Rubik's Cube Championship 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]285[/TD][/TR]
[TR][TD]6[/TD][TD]Rubik's Cube European Championships 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]269[/TD][/TR]
[TR][TD]7[/TD][TD]United States National Championships 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]259[/TD][/TR]
[TR][TD]8[/TD][TD]Aachen Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]230[/TD][/TR]
[TR][TD]9[/TD][TD]United States Rubik's Cube Championships 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]227[/TD][/TR]
[TR][TD]10[/TD][TD]European Rubik's Cube Championship 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]227[/TD][/TR]
[TR][TD]11[/TD][TD]Polish Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]218[/TD][/TR]
[TR][TD]12[/TD][TD]World Rubik's Cube Championship 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]214[/TD][/TR]
[TR][TD]13[/TD][TD]United States National Championships 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]204[/TD][/TR]
[TR][TD]14[/TD][TD]Shaastra Cube Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]203[/TD][/TR]
[TR][TD]15[/TD][TD]MPEI Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]198[/TD][/TR]
[TR][TD]16[/TD][TD]Fénix 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]195[/TD][/TR]
[TR][TD]17[/TD][TD]Guangdong Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]190[/TD][/TR]
[TR][TD]18[/TD][TD]Polish Nationals 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]182[/TD][/TR]
[TR][TD]19[/TD][TD]SLS Gliwice 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]180[/TD][/TR]
[TR][TD]20[/TD][TD]Indian Cube Challenge 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]178[/TD][/TR]
[TR][TD]21[/TD][TD]MPEI Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]166[/TD][/TR]
[TR][TD]22[/TD][TD]Guangdong Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]162[/TD][/TR]
[TR][TD]23[/TD][TD]SLS Chorzow 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]162[/TD][/TR]
[TR][TD]24[/TD][TD]Beijing Summer Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]162[/TD][/TR]
[TR][TD]25[/TD][TD]Spanish Championship 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]158[/TD][/TR]
[TR][TD]26[/TD][TD]Indian Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]158[/TD][/TR]
[TR][TD]27[/TD][TD]Iran Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]154[/TD][/TR]
[TR][TD]28[/TD][TD]Aachen Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]154[/TD][/TR]
[TR][TD]29[/TD][TD]ShenYang Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]154[/TD][/TR]
[TR][TD]30[/TD][TD]Suzhou Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]153[/TD][/TR]
[TR][TD]31[/TD][TD]Jakarta Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]152[/TD][/TR]
[TR][TD]32[/TD][TD]Malaysian Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]151[/TD][/TR]
[TR][TD]33[/TD][TD]San Francisco Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]150[/TD][/TR]
[TR][TD]34[/TD][TD]Guangdong Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]149[/TD][/TR]
[TR][TD]35[/TD][TD]Rubik's World Championship 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]149[/TD][/TR]
[TR][TD]36[/TD][TD]Beijing Metropolis Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]149[/TD][/TR]
[TR][TD]37[/TD][TD]Indonesian Championship 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]148[/TD][/TR]
[TR][TD]38[/TD][TD]Philippines Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]147[/TD][/TR]
[TR][TD]39[/TD][TD]SLS Jastrzebie 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]147[/TD][/TR]
[TR][TD]40[/TD][TD]German Nationals 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]146[/TD][/TR]
[TR][TD]41[/TD][TD]Shanghai Summer 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]146[/TD][/TR]
[TR][TD]42[/TD][TD]Hungarian Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]144[/TD][/TR]
[TR][TD]43[/TD][TD]Polish Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]141[/TD][/TR]
[TR][TD]44[/TD][TD]Asian Championship 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]141[/TD][/TR]
[TR][TD]45[/TD][TD]Pantheon Cube Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]139[/TD][/TR]
[TR][TD]46[/TD][TD]SLS Bielsko-Biala 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]136[/TD][/TR]
[TR][TD]47[/TD][TD]SLS Tarnowskie Gory 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]136[/TD][/TR]
[TR][TD]48[/TD][TD]Thailand Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]136[/TD][/TR]
[TR][TD]49[/TD][TD]US Nationals 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]135[/TD][/TR]
[TR][TD]50[/TD][TD]Shanghai Summer 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]134[/TD][/TR]
[TR][TD]51[/TD][TD]Liberty Science Center Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]134[/TD][/TR]
[TR][TD]52[/TD][TD]Malaysian Cube Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]133[/TD][/TR]
[TR][TD]53[/TD][TD]Prasadz ICC Juniors 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]132[/TD][/TR]
[TR][TD]54[/TD][TD]SLS Rybnik 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]132[/TD][/TR]
[TR][TD]55[/TD][TD]P3 Grand Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]131[/TD][/TR]
[TR][TD]56[/TD][TD]Warsaw Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]130[/TD][/TR]
[TR][TD]57[/TD][TD]Speed Cubing Mumbai Unlimited 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]130[/TD][/TR]
[TR][TD]58[/TD][TD]Asian Championship 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]129[/TD][/TR]
[TR][TD]59[/TD][TD]Hungarian Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]129[/TD][/TR]
[TR][TD]60[/TD][TD]Ukraine Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]127[/TD][/TR]
[TR][TD]61[/TD][TD]Alpha Cube BUAA Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]127[/TD][/TR]
[TR][TD]62[/TD][TD]German Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]127[/TD][/TR]
[TR][TD]63[/TD][TD]National Cubing Region Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]127[/TD][/TR]
[TR][TD]64[/TD][TD]NULAU Kharkiv Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]124[/TD][/TR]
[TR][TD]65[/TD][TD]Iran Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]123[/TD][/TR]
[TR][TD]66[/TD][TD]MPEI Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]123[/TD][/TR]
[TR][TD]67[/TD][TD]German Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]123[/TD][/TR]
[TR][TD]68[/TD][TD]Shaastra Cube Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]122[/TD][/TR]
[TR][TD]69[/TD][TD]Indonesian Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]122[/TD][/TR]
[TR][TD]70[/TD][TD]Carte Blanche Kube Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]122[/TD][/TR]
[TR][TD]71[/TD][TD]Indiana 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]121[/TD][/TR]
[TR][TD]72[/TD][TD]French Championship 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]121[/TD][/TR]
[TR][TD]73[/TD][TD]Taiwan Summer Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]120[/TD][/TR]
[TR][TD]74[/TD][TD]SESC/Santos 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]120[/TD][/TR]
[TR][TD]75[/TD][TD]Cross-strait Cubing Exchange 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]119[/TD][/TR]
[TR][TD]76[/TD][TD]Duanwu Festival Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]119[/TD][/TR]
[TR][TD]77[/TD][TD]Canadian Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]119[/TD][/TR]
[TR][TD]78[/TD][TD]Tokyo Open 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]118[/TD][/TR]
[TR][TD]79[/TD][TD]DJ Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]118[/TD][/TR]
[TR][TD]80[/TD][TD]European Championship 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]117[/TD][/TR]
[TR][TD]81[/TD][TD]Guangzhou CCSA Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]116[/TD][/TR]
[TR][TD]82[/TD][TD]Toronto Open Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]116[/TD][/TR]
[TR][TD]83[/TD][TD]Brasileiro Etapa de Verão 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]116[/TD][/TR]
[TR][TD]84[/TD][TD]CMI Fiesta Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]116[/TD][/TR]
[TR][TD]85[/TD][TD]Pragyan Cube Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]115[/TD][/TR]
[TR][TD]86[/TD][TD]KCA Korea Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]115[/TD][/TR]
[TR][TD]87[/TD][TD]Jakarta Ceria Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]112[/TD][/TR]
[TR][TD]88[/TD][TD]Indian Cube Challenge 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]112[/TD][/TR]
[TR][TD]89[/TD][TD]Kielce Cube Attack 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]112[/TD][/TR]
[TR][TD]90[/TD][TD]Taiwan Summer Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]112[/TD][/TR]
[TR][TD]91[/TD][TD]Campeonato Brasileiro de Cubo Mágico 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]112[/TD][/TR]
[TR][TD]92[/TD][TD]Munich Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]111[/TD][/TR]
[TR][TD]93[/TD][TD]SLS Czestochowa 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]111[/TD][/TR]
[TR][TD]94[/TD][TD]CanadianCUBING Fifty 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]110[/TD][/TR]
[TR][TD]95[/TD][TD]Hungarian Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]110[/TD][/TR]
[TR][TD]96[/TD][TD]SAFRA Singapore Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]110[/TD][/TR]
[TR][TD]97[/TD][TD]Campeonato Profecía 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]110[/TD][/TR]
[TR][TD]98[/TD][TD]Bydgoszcz Summer 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]109[/TD][/TR]
[TR][TD]99[/TD][TD]SESC Santos 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]109[/TD][/TR]
[TR][TD]100[/TD][TD]Spanish Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]109[/TD][/TR]
[TR][TD]101[/TD][TD]Caltech Fall Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]108[/TD][/TR]
[TR][TD]102[/TD][TD]German Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]108[/TD][/TR]
[TR][TD]103[/TD][TD]Kharkiv Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]108[/TD][/TR]
[TR][TD]104[/TD][TD]Berkeley Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]108[/TD][/TR]
[TR][TD]105[/TD][TD]Toronto Open Winter 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]107[/TD][/TR]
[TR][TD]106[/TD][TD]SESC Santo Amaro 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]107[/TD][/TR]
[TR][TD]107[/TD][TD]Moscow North-West Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]107[/TD][/TR]
[TR][TD]108[/TD][TD]SLS Zaglebie 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]107[/TD][/TR]
[TR][TD]109[/TD][TD]National TPoly Rubik's Cube Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]107[/TD][/TR]
[TR][TD]110[/TD][TD]Hungarian Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]106[/TD][/TR]
[TR][TD]111[/TD][TD]Pragyan Cube Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]106[/TD][/TR]
[TR][TD]112[/TD][TD]30th Anniversary MegaHouse Cup 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]105[/TD][/TR]
[TR][TD]113[/TD][TD]Cubing Fest 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]105[/TD][/TR]
[TR][TD]114[/TD][TD]Canadian Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]104[/TD][/TR]
[TR][TD]115[/TD][TD]US Nationals and Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]104[/TD][/TR]
[TR][TD]116[/TD][TD]Beijing Spring Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]103[/TD][/TR]
[TR][TD]117[/TD][TD]Munich Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]103[/TD][/TR]
[TR][TD]118[/TD][TD]Bangkok Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]103[/TD][/TR]
[TR][TD]119[/TD][TD]Brasileiro Etapa de Inverno 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]103[/TD][/TR]
[TR][TD]120[/TD][TD]Hong Kong Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]121[/TD][TD]Harbin Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]122[/TD][TD]Guangdong Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]123[/TD][TD]Aachen Summer Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]124[/TD][TD]German Nationals 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]125[/TD][TD]Caltech Winter competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]126[/TD][TD]French Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]127[/TD][TD]Kuikuiltik 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]128[/TD][TD]Shanghai Weisuo Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]101[/TD][/TR]
[TR][TD]129[/TD][TD]Canadian Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]101[/TD][/TR]
[TR][TD]130[/TD][TD]Toronto Open Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]101[/TD][/TR]
[TR][TD]131[/TD][TD]São Paulo Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]101[/TD][/TR]
[TR][TD]132[/TD][TD]Toronto Open Winter 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]100[/TD][/TR]
[TR][TD]133[/TD][TD]Princeton Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]100[/TD][/TR]
[TR][TD]134[/TD][TD]DJ SpeedCubing Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]100[/TD][/TR]
[TR][TD]135[/TD][TD]Toronto Open Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]100[/TD][/TR]
[TR][TD]136[/TD][TD]Colombia Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]99[/TD][/TR]
[TR][TD]137[/TD][TD]Oficina Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]99[/TD][/TR]
[TR][TD]138[/TD][TD]German Nationals 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]99[/TD][/TR]
[TR][TD]139[/TD][TD]Russia Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]99[/TD][/TR]
[TR][TD]140[/TD][TD]Iran Rubikup 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]98[/TD][/TR]
[TR][TD]141[/TD][TD]Princeton Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]98[/TD][/TR]
[TR][TD]142[/TD][TD]Nanjing Normal University 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]97[/TD][/TR]
[TR][TD]143[/TD][TD]Taiwan Winter Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]97[/TD][/TR]
[TR][TD]144[/TD][TD]Shenzhen Summer Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]97[/TD][/TR]
[TR][TD]145[/TD][TD]Hungarian Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]97[/TD][/TR]
[TR][TD]146[/TD][TD]SLS Swierklany 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]97[/TD][/TR]
[TR][TD]147[/TD][TD]VIT Rubik's Challenge 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]97[/TD][/TR]
[TR][TD]148[/TD][TD]Nanjing Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]96[/TD][/TR]
[TR][TD]149[/TD][TD]Ukrainian Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]96[/TD][/TR]
[TR][TD]150[/TD][TD]Harbin Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]96[/TD][/TR]
[TR][TD]151[/TD][TD]Indiana 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]152[/TD][TD]Australian Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]153[/TD][TD]Taiwan Summer Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]154[/TD][TD]Dutch Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]155[/TD][TD]Japan Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]156[/TD][TD]Indiana 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]157[/TD][TD]Newark Winter competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]158[/TD][TD]GLS Summer 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]159[/TD][TD]Nanjing Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]160[/TD][TD]Japan Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]161[/TD][TD]Japan Open 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]162[/TD][TD]Hefei Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]163[/TD][TD]ChangChun 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]164[/TD][TD]European Rubik's Cube Championship 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]165[/TD][TD]Nanjing Spring Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]93[/TD][/TR]
[TR][TD]166[/TD][TD]Spanish Championship 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]93[/TD][/TR]
[TR][TD]167[/TD][TD]Rybnik Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]93[/TD][/TR]
[TR][TD]168[/TD][TD]Beijing Summer Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]93[/TD][/TR]
[TR][TD]169[/TD][TD]Dnepr Cube Day 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]93[/TD][/TR]
[TR][TD]170[/TD][TD]Toronto Open Summer 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]93[/TD][/TR]
[TR][TD]171[/TD][TD]Hangzhou Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]172[/TD][TD]MIT Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]173[/TD][TD]Cubing ATMOSphere 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]174[/TD][TD]Israel Championship 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]175[/TD][TD]Kharkiv Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]176[/TD][TD]Polish Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]177[/TD][TD]Caltech Winter Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]178[/TD][TD]Beijing Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]91[/TD][/TR]
[TR][TD]179[/TD][TD]Aguascalientes Summer 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]91[/TD][/TR]
[TR][TD]180[/TD][TD]Singapore Rubik's Cube Competition 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]91[/TD][/TR]
[TR][TD]181[/TD][TD]São Paulo Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]91[/TD][/TR]
[TR][TD]182[/TD][TD]Nanjing Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]183[/TD][TD]Henan Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]184[/TD][TD]Xi'an Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]185[/TD][TD]Changchun Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]186[/TD][TD]Hong Kong Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]187[/TD][TD]German Nationals 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]188[/TD][TD]Shanghai Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]189[/TD][TD]Japan Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]89[/TD][/TR]
[TR][TD]190[/TD][TD]CMI Fiesta Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]89[/TD][/TR]
[TR][TD]191[/TD][TD]Japan Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]89[/TD][/TR]
[TR][TD]192[/TD][TD]Princeton Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]89[/TD][/TR]
[TR][TD]193[/TD][TD]Hungarian Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]89[/TD][/TR]
[TR][TD]194[/TD][TD]World Rubik's Games Championship 2003[/TD][TD="align:right"]2003[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]195[/TD][TD]Chojnice Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]196[/TD][TD]Campeonato Nacional Chile 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]197[/TD][TD]Palacio del Cubo 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]198[/TD][TD]Aachen Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]199[/TD][TD]Speed Cubing Mumbai Unlimited 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]200[/TD][TD]Thailand Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]88[/TD][/TR]
[/TABLE]

SELECT Competitions.name, year, count(personId) personIds

FROM

(SELECT competitionId, personId

FROM Results

GROUP BY personId, competitionId

) tmp

JOIN Competitions ON Competitions.id = competitionId

GROUP BY Competitions.name

ORDER BY personIds DESC;

Using data from WCA_export458_20140901 and Stefan's WCA forum statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]rank[/TD][TD]name[/TD][TD]year[/TD][TD]personIds[/TD][/TR]
[TR][TD]1[/TD][TD]World Rubik's Cube Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]580[/TD][/TR]
[TR][TD]2[/TD][TD]US Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]497[/TD][/TR]
[TR][TD]3[/TD][TD]United States National Championships 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]259[/TD][/TR]
[TR][TD]4[/TD][TD]United States Rubik's Cube Championships 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]227[/TD][/TR]
[TR][TD]5[/TD][TD]United States National Championships 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]204[/TD][/TR]
[TR][TD]6[/TD][TD]San Francisco Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]150[/TD][/TR]
[TR][TD]7[/TD][TD]Rubik's World Championship 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]149[/TD][/TR]
[TR][TD]8[/TD][TD]US Nationals 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]135[/TD][/TR]
[TR][TD]9[/TD][TD]Liberty Science Center Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]134[/TD][/TR]
[TR][TD]10[/TD][TD]Indiana 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]121[/TD][/TR]
[TR][TD]11[/TD][TD]Berkeley Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]108[/TD][/TR]
[TR][TD]12[/TD][TD]Caltech Fall Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]108[/TD][/TR]
[TR][TD]13[/TD][TD]US Nationals and Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]104[/TD][/TR]
[TR][TD]14[/TD][TD]Caltech Winter competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]102[/TD][/TR]
[TR][TD]15[/TD][TD]Princeton Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]100[/TD][/TR]
[TR][TD]16[/TD][TD]Princeton Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]98[/TD][/TR]
[TR][TD]17[/TD][TD]Indiana 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]18[/TD][TD]Indiana 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]19[/TD][TD]Newark Winter competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]20[/TD][TD]MIT Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]21[/TD][TD]Caltech Winter Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]22[/TD][TD]Princeton Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]89[/TD][/TR]
[TR][TD]23[/TD][TD]Bay Area Speedcubin' 2 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]24[/TD][TD]Caltech Winter Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]86[/TD][/TR]
[TR][TD]25[/TD][TD]Princeton Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]86[/TD][/TR]
[TR][TD]26[/TD][TD]Berkeley Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]85[/TD][/TR]
[TR][TD]27[/TD][TD]US Nationals 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]85[/TD][/TR]
[TR][TD]28[/TD][TD]Princeton Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]85[/TD][/TR]
[TR][TD]29[/TD][TD]Jersey Shore Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]83[/TD][/TR]
[TR][TD]30[/TD][TD]Berkeley Spring competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]82[/TD][/TR]
[TR][TD]31[/TD][TD]Yale Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]82[/TD][/TR]
[TR][TD]32[/TD][TD]Princeton Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]82[/TD][/TR]
[TR][TD]33[/TD][TD]River Hill Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]80[/TD][/TR]
[TR][TD]34[/TD][TD]Caltech Fall competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]80[/TD][/TR]
[TR][TD]35[/TD][TD]MIT Fall 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]79[/TD][/TR]
[TR][TD]36[/TD][TD]Caltech Winter 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]79[/TD][/TR]
[TR][TD]37[/TD][TD]Washington DC Winter 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]77[/TD][/TR]
[TR][TD]38[/TD][TD]Caltech Spring Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]77[/TD][/TR]
[TR][TD]39[/TD][TD]Liberty Science Center Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]76[/TD][/TR]
[TR][TD]40[/TD][TD]Liberty Science Center Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]76[/TD][/TR]
[TR][TD]41[/TD][TD]Berkeley Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]75[/TD][/TR]
[TR][TD]42[/TD][TD]New Albany 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]75[/TD][/TR]
[TR][TD]43[/TD][TD]Dixon Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]75[/TD][/TR]
[TR][TD]44[/TD][TD]Michigan 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]74[/TD][/TR]
[TR][TD]45[/TD][TD]Michigan May Madness 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]73[/TD][/TR]
[TR][TD]46[/TD][TD]Harvard Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]73[/TD][/TR]
[TR][TD]47[/TD][TD]Caltech Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]72[/TD][/TR]
[TR][TD]48[/TD][TD]Indiana 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]72[/TD][/TR]
[TR][TD]49[/TD][TD]BASC 3: Flagj Day 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]72[/TD][/TR]
[TR][TD]50[/TD][TD]Liberty Science Center Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]72[/TD][/TR]
[TR][TD]51[/TD][TD]Newark Head to Head 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]71[/TD][/TR]
[TR][TD]52[/TD][TD]Chesapeake Science Point Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]53[/TD][TD]Levittown Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]54[/TD][TD]Berkeley Fall competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]55[/TD][TD]Indiana Winter 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]56[/TD][TD]Harvard Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]57[/TD][TD]Monmouth County Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]58[/TD][TD]MIT Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]59[/TD][TD]River Hill Winter 2012 competition[/TD][TD="align:right"]2012[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]60[/TD][TD]Cube Kingdom II 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]61[/TD][TD]US Open 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]62[/TD][TD]MIT Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]63[/TD][TD]River Hill Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]69[/TD][/TR]
[TR][TD]64[/TD][TD]CCFC Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]69[/TD][/TR]
[TR][TD]65[/TD][TD]Slow 'n Steady Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]69[/TD][/TR]
[TR][TD]66[/TD][TD]Iowa Corn Lovers 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]69[/TD][/TR]
[TR][TD]67[/TD][TD]Lexington Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]68[/TD][/TR]
[TR][TD]68[/TD][TD]River Hill Summer 2012 competition[/TD][TD="align:right"]2012[/TD][TD="align:right"]68[/TD][/TR]
[TR][TD]69[/TD][TD]EPGY Stanford Winter 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]68[/TD][/TR]
[TR][TD]70[/TD][TD]Chesapeake Science Point Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]68[/TD][/TR]
[TR][TD]71[/TD][TD]Caltech Spring competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]67[/TD][/TR]
[TR][TD]72[/TD][TD]Nisei Week 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]67[/TD][/TR]
[TR][TD]73[/TD][TD]Cubetcha 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]66[/TD][/TR]
[TR][TD]74[/TD][TD]Berkeley Winter 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]66[/TD][/TR]
[TR][TD]75[/TD][TD]Berkeley Autumn 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]76[/TD][TD]Caltech Discovery Spring competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]77[/TD][TD]Caltech Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]78[/TD][TD]Harvard Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]79[/TD][TD]Chesapeake Science Point Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]80[/TD][TD]Caltech Fall competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]81[/TD][TD]Newark Head to Head 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]82[/TD][TD]MIT Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]83[/TD][TD]Stanford Fall competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]84[/TD][TD]Newark Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]85[/TD][TD]Chicago Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]63[/TD][/TR]
[TR][TD]86[/TD][TD]Captain's Cove competition 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]63[/TD][/TR]
[TR][TD]87[/TD][TD]Starlight Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]63[/TD][/TR]
[TR][TD]88[/TD][TD]Antelope Valley Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]63[/TD][/TR]
[TR][TD]89[/TD][TD]Tree Town 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]63[/TD][/TR]
[TR][TD]90[/TD][TD]MIT Spring 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]63[/TD][/TR]
[TR][TD]91[/TD][TD]Berkeley Fall competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]63[/TD][/TR]
[TR][TD]92[/TD][TD]Cornell Open Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]93[/TD][TD]Houston Winter Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]94[/TD][TD]Nisei Week Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]95[/TD][TD]Winona Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]96[/TD][TD]UC Berkeley Fall competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]97[/TD][TD]Vidar Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]98[/TD][TD]Newark Head to Head 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]99[/TD][TD]Harvard Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]100[/TD][TD]Caltech Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]60[/TD][/TR]
[/TABLE]

SELECT Competitions.name, year, count(personId) personIds

FROM

(SELECT competitionId, personId

FROM Results

GROUP BY personId, competitionId

) tmp

JOIN Competitions ON Competitions.id = competitionId

WHERE Competitions.countryId = 'USA'

GROUP BY Competitions.name

ORDER BY personIds DESC;

Mike Hughey · Sep 1, 2014

Another try with it:

Using data from WCA_export458_20140901 and Stefan's WCA forum statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]rank[/TD][TD]name[/TD][TD]year[/TD][TD]totalSolves[/TD][/TR]
[TR][TD]1[/TD][TD]World Rubik's Cube Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]17664[/TD][/TR]
[TR][TD]2[/TD][TD]US Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]15511[/TD][/TR]
[TR][TD]3[/TD][TD]Rubik's Cube European Championships 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]10338[/TD][/TR]
[TR][TD]4[/TD][TD]United States National Championships 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]10087[/TD][/TR]
[TR][TD]5[/TD][TD]World Rubik's Cube Championship 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]9162[/TD][/TR]
[TR][TD]6[/TD][TD]European Rubik's Cube Championship 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]9136[/TD][/TR]
[TR][TD]7[/TD][TD]United States Rubik's Cube Championships 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]7908[/TD][/TR]
[TR][TD]8[/TD][TD]United States National Championships 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]7119[/TD][/TR]
[TR][TD]9[/TD][TD]World Rubik's Cube Championship 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]6628[/TD][/TR]
[TR][TD]10[/TD][TD]European Rubik's Cube Championship 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]6451[/TD][/TR]
[TR][TD]11[/TD][TD]Aachen Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]5652[/TD][/TR]
[TR][TD]12[/TD][TD]Polish Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]5209[/TD][/TR]
[TR][TD]13[/TD][TD]Fénix 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]4979[/TD][/TR]
[TR][TD]14[/TD][TD]US Nationals 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]4728[/TD][/TR]
[TR][TD]15[/TD][TD]Indian Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]4691[/TD][/TR]
[TR][TD]16[/TD][TD]SLS Gliwice 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]4483[/TD][/TR]
[TR][TD]17[/TD][TD]Asian Championship 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]4362[/TD][/TR]
[TR][TD]18[/TD][TD]Polish Nationals 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]4351[/TD][/TR]
[TR][TD]19[/TD][TD]Warsaw Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]4340[/TD][/TR]
[TR][TD]20[/TD][TD]Kielce Cube Attack 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]4312[/TD][/TR]
[TR][TD]21[/TD][TD]Polish Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]4241[/TD][/TR]
[TR][TD]22[/TD][TD]Hungarian Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]3921[/TD][/TR]
[TR][TD]23[/TD][TD]SLS Chorzow 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3859[/TD][/TR]
[TR][TD]24[/TD][TD]MPEI Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]3858[/TD][/TR]
[TR][TD]25[/TD][TD]Cubing Fest 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3827[/TD][/TR]
[TR][TD]26[/TD][TD]Guangdong Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]3732[/TD][/TR]
[TR][TD]27[/TD][TD]Kuikuiltik 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]3690[/TD][/TR]
[TR][TD]28[/TD][TD]Munich Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]3675[/TD][/TR]
[TR][TD]29[/TD][TD]Indian Cube Challenge 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]3661[/TD][/TR]
[TR][TD]30[/TD][TD]MPEI Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]3615[/TD][/TR]
[TR][TD]31[/TD][TD]German Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]3555[/TD][/TR]
[TR][TD]32[/TD][TD]German Nationals 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]3534[/TD][/TR]
[TR][TD]33[/TD][TD]SLS Rybnik 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3512[/TD][/TR]
[TR][TD]34[/TD][TD]Indonesian Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]3493[/TD][/TR]
[TR][TD]35[/TD][TD]Asian Championship 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]3382[/TD][/TR]
[TR][TD]36[/TD][TD]World Rubik's Cube Championship 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]3339[/TD][/TR]
[TR][TD]37[/TD][TD]German Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]3337[/TD][/TR]
[TR][TD]38[/TD][TD]NULAU Kharkiv Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]3287[/TD][/TR]
[TR][TD]39[/TD][TD]Taiwan Summer Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3278[/TD][/TR]
[TR][TD]40[/TD][TD]Hungarian Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]3270[/TD][/TR]
[TR][TD]41[/TD][TD]Guangdong Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]3254[/TD][/TR]
[TR][TD]42[/TD][TD]Ukrainian Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3185[/TD][/TR]
[TR][TD]43[/TD][TD]SLS Zaglebie 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]3177[/TD][/TR]
[TR][TD]44[/TD][TD]Canadian Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]3147[/TD][/TR]
[TR][TD]45[/TD][TD]Kharkiv Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3141[/TD][/TR]
[TR][TD]46[/TD][TD]Taiwan Summer Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]3136[/TD][/TR]
[TR][TD]47[/TD][TD]European Championship 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]3136[/TD][/TR]
[TR][TD]48[/TD][TD]German Nationals 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]3102[/TD][/TR]
[TR][TD]49[/TD][TD]Canadian Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]3096[/TD][/TR]
[TR][TD]50[/TD][TD]Moscow North-West Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]3085[/TD][/TR]
[TR][TD]51[/TD][TD]Cross-strait Cubing Exchange 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3066[/TD][/TR]
[TR][TD]52[/TD][TD]Bydgoszcz Summer 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3059[/TD][/TR]
[TR][TD]53[/TD][TD]Aguascalientes Summer 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]3001[/TD][/TR]
[TR][TD]54[/TD][TD]Brasileiro Etapa de Inverno 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2997[/TD][/TR]
[TR][TD]55[/TD][TD]Spanish Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2979[/TD][/TR]
[TR][TD]56[/TD][TD]Frankfurt Cube Days 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2966[/TD][/TR]
[TR][TD]57[/TD][TD]Aachen Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2955[/TD][/TR]
[TR][TD]58[/TD][TD]German Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2941[/TD][/TR]
[TR][TD]59[/TD][TD]Hessen Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2923[/TD][/TR]
[TR][TD]60[/TD][TD]Jura Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2889[/TD][/TR]
[TR][TD]61[/TD][TD]Speed Cubing Mumbai Unlimited 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2886[/TD][/TR]
[TR][TD]62[/TD][TD]Dutch Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2880[/TD][/TR]
[TR][TD]63[/TD][TD]MIT Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2879[/TD][/TR]
[TR][TD]64[/TD][TD]Aachen Summer Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2864[/TD][/TR]
[TR][TD]65[/TD][TD]Chojnice Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2859[/TD][/TR]
[TR][TD]66[/TD][TD]Warszawa Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2853[/TD][/TR]
[TR][TD]67[/TD][TD]Austrian Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2841[/TD][/TR]
[TR][TD]68[/TD][TD]Hungarian Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2839[/TD][/TR]
[TR][TD]69[/TD][TD]Munich Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2838[/TD][/TR]
[TR][TD]70[/TD][TD]SESC Santos 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2836[/TD][/TR]
[TR][TD]71[/TD][TD]Indonesian Championship 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2836[/TD][/TR]
[TR][TD]72[/TD][TD]São Paulo Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2834[/TD][/TR]
[TR][TD]73[/TD][TD]Cologne Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2832[/TD][/TR]
[TR][TD]74[/TD][TD]Kharkiv Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2808[/TD][/TR]
[TR][TD]75[/TD][TD]Hungarian Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2806[/TD][/TR]
[TR][TD]76[/TD][TD]Düsseldorf Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2787[/TD][/TR]
[TR][TD]77[/TD][TD]ABHC 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2782[/TD][/TR]
[TR][TD]78[/TD][TD]Czech Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2778[/TD][/TR]
[TR][TD]79[/TD][TD]Franconia Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2767[/TD][/TR]
[TR][TD]80[/TD][TD]SLS Jastrzebie 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2759[/TD][/TR]
[TR][TD]81[/TD][TD]Chojnice Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2749[/TD][/TR]
[TR][TD]82[/TD][TD]Indian Cube Challenge 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2744[/TD][/TR]
[TR][TD]83[/TD][TD]Polish Nationals 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2742[/TD][/TR]
[TR][TD]84[/TD][TD]Polish Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2725[/TD][/TR]
[TR][TD]85[/TD][TD]Hessen Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2723[/TD][/TR]
[TR][TD]86[/TD][TD]Munich Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2708[/TD][/TR]
[TR][TD]87[/TD][TD]Hessen Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2677[/TD][/TR]
[TR][TD]88[/TD][TD]Shanghai Summer 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2669[/TD][/TR]
[TR][TD]89[/TD][TD]SLS Bielsko-Biala 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2667[/TD][/TR]
[TR][TD]90[/TD][TD]Colombia Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2618[/TD][/TR]
[TR][TD]91[/TD][TD]Ukraine Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2607[/TD][/TR]
[TR][TD]92[/TD][TD]BW Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2605[/TD][/TR]
[TR][TD]93[/TD][TD]SLS Tarnowskie Gory 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2605[/TD][/TR]
[TR][TD]94[/TD][TD]German Nationals 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2603[/TD][/TR]
[TR][TD]95[/TD][TD]Welwyn Garden City Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2589[/TD][/TR]
[TR][TD]96[/TD][TD]German Nationals 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2585[/TD][/TR]
[TR][TD]97[/TD][TD]Iran Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2581[/TD][/TR]
[TR][TD]98[/TD][TD]Rumia Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2553[/TD][/TR]
[TR][TD]99[/TD][TD]Shaastra Cube Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2543[/TD][/TR]
[TR][TD]100[/TD][TD]Saarland Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2543[/TD][/TR]
[TR][TD]101[/TD][TD]Malaysian Cube Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2543[/TD][/TR]
[TR][TD]102[/TD][TD]Hefei Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2536[/TD][/TR]
[TR][TD]103[/TD][TD]Iran Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2534[/TD][/TR]
[TR][TD]104[/TD][TD]São Paulo Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2533[/TD][/TR]
[TR][TD]105[/TD][TD]MPEI Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2524[/TD][/TR]
[TR][TD]106[/TD][TD]Campeonato Brasileiro de Cubo Mágico 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2520[/TD][/TR]
[TR][TD]107[/TD][TD]Hefei Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2513[/TD][/TR]
[TR][TD]108[/TD][TD]UK Rubik's Cube Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2505[/TD][/TR]
[TR][TD]109[/TD][TD]Danish Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2500[/TD][/TR]
[TR][TD]110[/TD][TD]Munich Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2493[/TD][/TR]
[TR][TD]111[/TD][TD]Düsseldorf Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2484[/TD][/TR]
[TR][TD]112[/TD][TD]Zonhoven Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2482[/TD][/TR]
[TR][TD]113[/TD][TD]Campeonato Profecía 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2463[/TD][/TR]
[TR][TD]114[/TD][TD]Hamburg Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2459[/TD][/TR]
[TR][TD]115[/TD][TD]Polish Nationals 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2459[/TD][/TR]
[TR][TD]116[/TD][TD]Nottingham Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2419[/TD][/TR]
[TR][TD]117[/TD][TD]BW Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2412[/TD][/TR]
[TR][TD]118[/TD][TD]Michigan 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2411[/TD][/TR]
[TR][TD]119[/TD][TD]Taiwan Summer Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2411[/TD][/TR]
[TR][TD]120[/TD][TD]Cube Factory 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2407[/TD][/TR]
[TR][TD]121[/TD][TD]Swedish Championship 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2401[/TD][/TR]
[TR][TD]122[/TD][TD]Indiana 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2398[/TD][/TR]
[TR][TD]123[/TD][TD]UK Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2389[/TD][/TR]
[TR][TD]124[/TD][TD]Czech Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2375[/TD][/TR]
[TR][TD]125[/TD][TD]Benelux Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2343[/TD][/TR]
[TR][TD]126[/TD][TD]Aleksandrus Cube 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2343[/TD][/TR]
[TR][TD]127[/TD][TD]Czech Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2341[/TD][/TR]
[TR][TD]128[/TD][TD]Russia Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2340[/TD][/TR]
[TR][TD]129[/TD][TD]Hungarian Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2331[/TD][/TR]
[TR][TD]130[/TD][TD]Jakarta Ceria Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2328[/TD][/TR]
[TR][TD]131[/TD][TD]Brasileiro Etapa de Verão 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2326[/TD][/TR]
[TR][TD]132[/TD][TD]Guangdong Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2325[/TD][/TR]
[TR][TD]133[/TD][TD]Minx Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2315[/TD][/TR]
[TR][TD]134[/TD][TD]Japan Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2312[/TD][/TR]
[TR][TD]135[/TD][TD]Polish Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2299[/TD][/TR]
[TR][TD]136[/TD][TD]Czech Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2298[/TD][/TR]
[TR][TD]137[/TD][TD]Slovenian Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2295[/TD][/TR]
[TR][TD]138[/TD][TD]Frankfurt Cube Days 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2293[/TD][/TR]
[TR][TD]139[/TD][TD]UK Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2264[/TD][/TR]
[TR][TD]140[/TD][TD]French Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]2258[/TD][/TR]
[TR][TD]141[/TD][TD]Chongqing Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2252[/TD][/TR]
[TR][TD]142[/TD][TD]Australian Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2236[/TD][/TR]
[TR][TD]143[/TD][TD]Kansai Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2232[/TD][/TR]
[TR][TD]144[/TD][TD]SLS Czestochowa 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2229[/TD][/TR]
[TR][TD]145[/TD][TD]Tula Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2229[/TD][/TR]
[TR][TD]146[/TD][TD]US Nationals and Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]2224[/TD][/TR]
[TR][TD]147[/TD][TD]Hefei Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2217[/TD][/TR]
[TR][TD]148[/TD][TD]Bialystok Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2207[/TD][/TR]
[TR][TD]149[/TD][TD]Japan Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2205[/TD][/TR]
[TR][TD]150[/TD][TD]Altbier 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2203[/TD][/TR]
[TR][TD]151[/TD][TD]Altbier 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2203[/TD][/TR]
[TR][TD]152[/TD][TD]Spanish Championship 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2201[/TD][/TR]
[TR][TD]153[/TD][TD]French Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2200[/TD][/TR]
[TR][TD]154[/TD][TD]Ukrainian Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2198[/TD][/TR]
[TR][TD]155[/TD][TD]SESC/Santos 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2194[/TD][/TR]
[TR][TD]156[/TD][TD]DJ Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2185[/TD][/TR]
[TR][TD]157[/TD][TD]Oleksandriia Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2184[/TD][/TR]
[TR][TD]158[/TD][TD]Iran Rubikup 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2181[/TD][/TR]
[TR][TD]159[/TD][TD]Polish Nationals 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2181[/TD][/TR]
[TR][TD]160[/TD][TD]Beijing Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2181[/TD][/TR]
[TR][TD]161[/TD][TD]Hong Kong Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]2169[/TD][/TR]
[TR][TD]162[/TD][TD]PLS Sopot 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2162[/TD][/TR]
[TR][TD]163[/TD][TD]Hasselt Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2150[/TD][/TR]
[TR][TD]164[/TD][TD]N8W8 Summer 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2146[/TD][/TR]
[TR][TD]165[/TD][TD]Suzhou Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2138[/TD][/TR]
[TR][TD]166[/TD][TD]German Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2137[/TD][/TR]
[TR][TD]167[/TD][TD]Back to the Palace 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2136[/TD][/TR]
[TR][TD]168[/TD][TD]Hungarian Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]2135[/TD][/TR]
[TR][TD]169[/TD][TD]Nanjing Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2133[/TD][/TR]
[TR][TD]170[/TD][TD]East German Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2131[/TD][/TR]
[TR][TD]171[/TD][TD]Polish Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]2125[/TD][/TR]
[TR][TD]172[/TD][TD]SLS Swierklany 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2121[/TD][/TR]
[TR][TD]173[/TD][TD]Canadian Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]2120[/TD][/TR]
[TR][TD]174[/TD][TD]Hong Kong Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2119[/TD][/TR]
[TR][TD]175[/TD][TD]Spanish Championship 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2113[/TD][/TR]
[TR][TD]176[/TD][TD]Alpha Cube BUAA Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2108[/TD][/TR]
[TR][TD]177[/TD][TD]Didas Brest 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2106[/TD][/TR]
[TR][TD]178[/TD][TD]Guangdong Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2104[/TD][/TR]
[TR][TD]179[/TD][TD]Danish Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2097[/TD][/TR]
[TR][TD]180[/TD][TD]Norwegian Championship 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2094[/TD][/TR]
[TR][TD]181[/TD][TD]German Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]2094[/TD][/TR]
[TR][TD]182[/TD][TD]Jakarta Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2091[/TD][/TR]
[TR][TD]183[/TD][TD]Grudziadz Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2079[/TD][/TR]
[TR][TD]184[/TD][TD]Austrian Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2074[/TD][/TR]
[TR][TD]185[/TD][TD]Nottingham Summer 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2069[/TD][/TR]
[TR][TD]186[/TD][TD]Oleksandriia Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2068[/TD][/TR]
[TR][TD]187[/TD][TD]N8W8 Summer 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2066[/TD][/TR]
[TR][TD]188[/TD][TD]CanadianCUBING Fifty 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2065[/TD][/TR]
[TR][TD]189[/TD][TD]Toronto Open Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2059[/TD][/TR]
[TR][TD]190[/TD][TD]Madrid Open Rubik 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2059[/TD][/TR]
[TR][TD]191[/TD][TD]Beijing Summer Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]2056[/TD][/TR]
[TR][TD]192[/TD][TD]Indiana 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2054[/TD][/TR]
[TR][TD]193[/TD][TD]Czech Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]2053[/TD][/TR]
[TR][TD]194[/TD][TD]Philippines Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]2053[/TD][/TR]
[TR][TD]195[/TD][TD]Borneo Championship 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2049[/TD][/TR]
[TR][TD]196[/TD][TD]Spanish Championship 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]2049[/TD][/TR]
[TR][TD]197[/TD][TD]Human Rights Day 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2049[/TD][/TR]
[TR][TD]198[/TD][TD]N8W8 Summer 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2048[/TD][/TR]
[TR][TD]199[/TD][TD]Swedish Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2048[/TD][/TR]
[TR][TD]200[/TD][TD]Dvina Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2039[/TD][/TR]
[TR][TD]201[/TD][TD]National Cubing Region Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2038[/TD][/TR]
[TR][TD]202[/TD][TD]German Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2038[/TD][/TR]
[TR][TD]203[/TD][TD]Montpellier Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]2036[/TD][/TR]
[TR][TD]204[/TD][TD]Masterpress Summer 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2029[/TD][/TR]
[TR][TD]205[/TD][TD]Belgian Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]2027[/TD][/TR]
[TR][TD]206[/TD][TD]Zonhoven Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2027[/TD][/TR]
[TR][TD]207[/TD][TD]GLS Autumn Reda 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2025[/TD][/TR]
[TR][TD]208[/TD][TD]Vesoul Open Rubik 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2016[/TD][/TR]
[TR][TD]209[/TD][TD]Twente Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2015[/TD][/TR]
[TR][TD]210[/TD][TD]Podolian Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2007[/TD][/TR]
[TR][TD]211[/TD][TD]Franconia Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2006[/TD][/TR]
[TR][TD]212[/TD][TD]Indiana 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2004[/TD][/TR]
[/TABLE]

SELECT Competitions.name, year, sum(solves) totalSolves

FROM

(SELECT
competitionId,

sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves

FROM Results

GROUP BY competitionId) tmp

JOIN Competitions ON Competitions.id = competitionId

GROUP BY Competitions.name

ORDER BY totalSolves DESC
;

Using data from WCA_export458_20140901 and Stefan's WCA forum statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]rank[/TD][TD]name[/TD][TD]year[/TD][TD]totalSolves[/TD][/TR]
[TR][TD]1[/TD][TD]World Rubik's Cube Championship 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]17664[/TD][/TR]
[TR][TD]2[/TD][TD]US Nationals 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]15511[/TD][/TR]
[TR][TD]3[/TD][TD]United States National Championships 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]10087[/TD][/TR]
[TR][TD]4[/TD][TD]United States Rubik's Cube Championships 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]7908[/TD][/TR]
[TR][TD]5[/TD][TD]United States National Championships 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]7119[/TD][/TR]
[TR][TD]6[/TD][TD]US Nationals 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]4728[/TD][/TR]
[TR][TD]7[/TD][TD]MIT Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2879[/TD][/TR]
[TR][TD]8[/TD][TD]Michigan 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2411[/TD][/TR]
[TR][TD]9[/TD][TD]Indiana 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]2398[/TD][/TR]
[TR][TD]10[/TD][TD]US Nationals and Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]2224[/TD][/TR]
[TR][TD]11[/TD][TD]Indiana 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]2054[/TD][/TR]
[TR][TD]12[/TD][TD]Indiana 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]2004[/TD][/TR]
[TR][TD]13[/TD][TD]Princeton Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1939[/TD][/TR]
[TR][TD]14[/TD][TD]Princeton Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1934[/TD][/TR]
[TR][TD]15[/TD][TD]Princeton Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1932[/TD][/TR]
[TR][TD]16[/TD][TD]Princeton Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1923[/TD][/TR]
[TR][TD]17[/TD][TD]Indiana 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1765[/TD][/TR]
[TR][TD]18[/TD][TD]Caltech Fall Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1724[/TD][/TR]
[TR][TD]19[/TD][TD]Princeton Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1665[/TD][/TR]
[TR][TD]20[/TD][TD]Liberty Science Center Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1587[/TD][/TR]
[TR][TD]21[/TD][TD]Caltech Winter Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1587[/TD][/TR]
[TR][TD]22[/TD][TD]San Francisco Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1580[/TD][/TR]
[TR][TD]23[/TD][TD]Levittown Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1549[/TD][/TR]
[TR][TD]24[/TD][TD]Jersey Shore Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1535[/TD][/TR]
[TR][TD]25[/TD][TD]MIT Fall 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1528[/TD][/TR]
[TR][TD]26[/TD][TD]Blizzard Town 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1517[/TD][/TR]
[TR][TD]27[/TD][TD]New Albany 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1514[/TD][/TR]
[TR][TD]28[/TD][TD]Berkeley Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1502[/TD][/TR]
[TR][TD]29[/TD][TD]Slow 'n Steady Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1492[/TD][/TR]
[TR][TD]30[/TD][TD]Long Island 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1483[/TD][/TR]
[TR][TD]31[/TD][TD]Rubik's World Championship 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]1472[/TD][/TR]
[TR][TD]32[/TD][TD]Newark Winter competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1457[/TD][/TR]
[TR][TD]33[/TD][TD]River Hill Summer 2012 competition[/TD][TD="align:right"]2012[/TD][TD="align:right"]1448[/TD][/TR]
[TR][TD]34[/TD][TD]Chesapeake Science Point Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1446[/TD][/TR]
[TR][TD]35[/TD][TD]Harvard Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1435[/TD][/TR]
[TR][TD]36[/TD][TD]Yale Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1426[/TD][/TR]
[TR][TD]37[/TD][TD]River Hill Winter 2012 competition[/TD][TD="align:right"]2012[/TD][TD="align:right"]1422[/TD][/TR]
[TR][TD]38[/TD][TD]River Hill Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1403[/TD][/TR]
[TR][TD]39[/TD][TD]MIT Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1402[/TD][/TR]
[TR][TD]40[/TD][TD]Caltech Winter 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1390[/TD][/TR]
[TR][TD]41[/TD][TD]River Hill Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1375[/TD][/TR]
[TR][TD]42[/TD][TD]Harvard Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1372[/TD][/TR]
[TR][TD]43[/TD][TD]Harvard Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1370[/TD][/TR]
[TR][TD]44[/TD][TD]Washington DC Winter 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1366[/TD][/TR]
[TR][TD]45[/TD][TD]New Albany 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1354[/TD][/TR]
[TR][TD]46[/TD][TD]CCFC Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1345[/TD][/TR]
[TR][TD]47[/TD][TD]MIT Spring 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1345[/TD][/TR]
[TR][TD]48[/TD][TD]Chicago Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1339[/TD][/TR]
[TR][TD]49[/TD][TD]Cubetcha 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1332[/TD][/TR]
[TR][TD]50[/TD][TD]Yale Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1328[/TD][/TR]
[TR][TD]51[/TD][TD]US Open 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]1319[/TD][/TR]
[TR][TD]52[/TD][TD]Caltech Winter Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1318[/TD][/TR]
[TR][TD]53[/TD][TD]Iowa Corn Lovers 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1317[/TD][/TR]
[TR][TD]54[/TD][TD]Virginia Open Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1306[/TD][/TR]
[TR][TD]55[/TD][TD]Starlight Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1305[/TD][/TR]
[TR][TD]56[/TD][TD]UIUC Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1301[/TD][/TR]
[TR][TD]57[/TD][TD]Berkeley Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1295[/TD][/TR]
[TR][TD]58[/TD][TD]Liberty Science Center Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1295[/TD][/TR]
[TR][TD]59[/TD][TD]St. Joseph's College Winter 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1294[/TD][/TR]
[TR][TD]60[/TD][TD]Liberty Science Center Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1291[/TD][/TR]
[TR][TD]61[/TD][TD]Lexington Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1285[/TD][/TR]
[TR][TD]62[/TD][TD]BASC 3: Flagj Day 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1285[/TD][/TR]
[TR][TD]63[/TD][TD]Bridgewater Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1282[/TD][/TR]
[TR][TD]64[/TD][TD]Newark Head to Head 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1281[/TD][/TR]
[TR][TD]65[/TD][TD]St. Joseph's College Summer 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1278[/TD][/TR]
[TR][TD]66[/TD][TD]MIT Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1272[/TD][/TR]
[TR][TD]67[/TD][TD]Indiana Winter 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1269[/TD][/TR]
[TR][TD]68[/TD][TD]Caltech Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1261[/TD][/TR]
[TR][TD]69[/TD][TD]Stanford Fall competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1257[/TD][/TR]
[TR][TD]70[/TD][TD]Cornell Open Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1233[/TD][/TR]
[TR][TD]71[/TD][TD]Caltech Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1231[/TD][/TR]
[TR][TD]72[/TD][TD]Yale Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1227[/TD][/TR]
[TR][TD]73[/TD][TD]Hillsdale Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1223[/TD][/TR]
[TR][TD]74[/TD][TD]River Hill Spring 2011 competition[/TD][TD="align:right"]2011[/TD][TD="align:right"]1221[/TD][/TR]
[TR][TD]75[/TD][TD]Liberty Science Center Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1217[/TD][/TR]
[TR][TD]76[/TD][TD]Bay Area Speedcubin' 2 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1213[/TD][/TR]
[TR][TD]77[/TD][TD]Tree Town 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1211[/TD][/TR]
[TR][TD]78[/TD][TD]Winona Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1210[/TD][/TR]
[TR][TD]79[/TD][TD]Fort Lee Winter 2009 competition[/TD][TD="align:right"]2009[/TD][TD="align:right"]1207[/TD][/TR]
[TR][TD]80[/TD][TD]Caltech Spring Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1202[/TD][/TR]
[TR][TD]81[/TD][TD]Harvard Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1191[/TD][/TR]
[TR][TD]82[/TD][TD]Dixon Summer 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1181[/TD][/TR]
[TR][TD]83[/TD][TD]Yale Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1168[/TD][/TR]
[TR][TD]84[/TD][TD]Park Ridge Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1164[/TD][/TR]
[TR][TD]85[/TD][TD]Leaf Town 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1162[/TD][/TR]
[TR][TD]86[/TD][TD]US Nationals 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]1157[/TD][/TR]
[TR][TD]87[/TD][TD]Princeton Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]1156[/TD][/TR]
[TR][TD]88[/TD][TD]Caltech Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1154[/TD][/TR]
[TR][TD]89[/TD][TD]Captain's Cove competition 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1152[/TD][/TR]
[TR][TD]90[/TD][TD]Ohio Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1151[/TD][/TR]
[TR][TD]91[/TD][TD]Caltech Fall competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]1150[/TD][/TR]
[TR][TD]92[/TD][TD]MIT Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1148[/TD][/TR]
[TR][TD]93[/TD][TD]Dixon Spring 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1146[/TD][/TR]
[TR][TD]94[/TD][TD]Hackley Summer 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1144[/TD][/TR]
[TR][TD]95[/TD][TD]Dixon Summer 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1138[/TD][/TR]
[TR][TD]96[/TD][TD]Cube Kingdom II 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1132[/TD][/TR]
[TR][TD]97[/TD][TD]Holy Toledo Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1123[/TD][/TR]
[TR][TD]98[/TD][TD]Yale Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1110[/TD][/TR]
[TR][TD]99[/TD][TD]Lexington Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1109[/TD][/TR]
[TR][TD]100[/TD][TD]Williams Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1103[/TD][/TR]
[TR][TD]101[/TD][TD]River Hill Fall 2010 competition[/TD][TD="align:right"]2010[/TD][TD="align:right"]1100[/TD][/TR]
[TR][TD]102[/TD][TD]Dixon Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1100[/TD][/TR]
[TR][TD]103[/TD][TD]Berkeley Summer 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1096[/TD][/TR]
[TR][TD]104[/TD][TD]Houston Winter Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1092[/TD][/TR]
[TR][TD]105[/TD][TD]Newark Head to Head 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1088[/TD][/TR]
[TR][TD]106[/TD][TD]Newport Cube Day 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1081[/TD][/TR]
[TR][TD]107[/TD][TD]Michigan May Madness 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1078[/TD][/TR]
[TR][TD]108[/TD][TD]St. Joseph's College Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1077[/TD][/TR]
[TR][TD]109[/TD][TD]Antelope Valley Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1076[/TD][/TR]
[TR][TD]110[/TD][TD]EPGY Stanford Winter 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1067[/TD][/TR]
[TR][TD]111[/TD][TD]Dixon Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1066[/TD][/TR]
[TR][TD]112[/TD][TD]Cubetcha 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1066[/TD][/TR]
[TR][TD]113[/TD][TD]Monmouth County Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1061[/TD][/TR]
[TR][TD]114[/TD][TD]San Diego Summer Splash 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1059[/TD][/TR]
[TR][TD]115[/TD][TD]Ohio Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1056[/TD][/TR]
[TR][TD]116[/TD][TD]Berkeley Winter 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1054[/TD][/TR]
[TR][TD]117[/TD][TD]Berkeley Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1052[/TD][/TR]
[TR][TD]118[/TD][TD]Caltech Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1050[/TD][/TR]
[TR][TD]119[/TD][TD]Motor City Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1040[/TD][/TR]
[TR][TD]120[/TD][TD]Cubetcha 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1038[/TD][/TR]
[TR][TD]121[/TD][TD]Hillsdale Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1036[/TD][/TR]
[TR][TD]122[/TD][TD]Chesapeake Science Point Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1035[/TD][/TR]
[TR][TD]123[/TD][TD]Berkeley Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1034[/TD][/TR]
[TR][TD]124[/TD][TD]MIT Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]1032[/TD][/TR]
[TR][TD]125[/TD][TD]Caltech Winter competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]1032[/TD][/TR]
[TR][TD]126[/TD][TD]Cubetcha 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]1027[/TD][/TR]
[TR][TD]127[/TD][TD]Caltech Fall Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1024[/TD][/TR]
[TR][TD]128[/TD][TD]Ohio Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1023[/TD][/TR]
[TR][TD]129[/TD][TD]Carroll Spring Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1014[/TD][/TR]
[TR][TD]130[/TD][TD]Dayton Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]1014[/TD][/TR]
[TR][TD]131[/TD][TD]Connecticut Summer Competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1009[/TD][/TR]
[TR][TD]132[/TD][TD]Minnesota Cube Melt 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]1008[/TD][/TR]
[TR][TD]133[/TD][TD]Harvard Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]1007[/TD][/TR]
[TR][TD]134[/TD][TD]Berkeley Spring competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]1004[/TD][/TR]
[TR][TD]135[/TD][TD]UIUC Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]999[/TD][/TR]
[TR][TD]136[/TD][TD]Oklahoma Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]996[/TD][/TR]
[TR][TD]137[/TD][TD]Berkeley Autumn 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]995[/TD][/TR]
[TR][TD]138[/TD][TD]MIT Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]994[/TD][/TR]
[TR][TD]139[/TD][TD]Keep Austin Weird 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]987[/TD][/TR]
[TR][TD]140[/TD][TD]Safe Haven competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]984[/TD][/TR]
[TR][TD]141[/TD][TD]Dayton Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]979[/TD][/TR]
[TR][TD]142[/TD][TD]Newark Head to Head 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]977[/TD][/TR]
[TR][TD]143[/TD][TD]Caltech Spring Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]977[/TD][/TR]
[TR][TD]144[/TD][TD]Berkeley Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]971[/TD][/TR]
[TR][TD]145[/TD][TD]Minnesota Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]969[/TD][/TR]
[TR][TD]146[/TD][TD]Caltech Winter 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]969[/TD][/TR]
[TR][TD]147[/TD][TD]Newark Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]968[/TD][/TR]
[TR][TD]148[/TD][TD]Berkeley Fall competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]966[/TD][/TR]
[TR][TD]149[/TD][TD]Raleigh Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]956[/TD][/TR]
[TR][TD]150[/TD][TD]EPGY Stanford Winter 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]954[/TD][/TR]
[TR][TD]151[/TD][TD]Berkeley Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]953[/TD][/TR]
[TR][TD]152[/TD][TD]Baltimore Spring competition 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]952[/TD][/TR]
[TR][TD]153[/TD][TD]UIUC Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]940[/TD][/TR]
[TR][TD]154[/TD][TD]Brown Cubing Day 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]939[/TD][/TR]
[TR][TD]155[/TD][TD]Yale Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]939[/TD][/TR]
[TR][TD]156[/TD][TD]Groovik's Cube Seattle 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]937[/TD][/TR]
[TR][TD]157[/TD][TD]Westchester Fall 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]937[/TD][/TR]
[TR][TD]158[/TD][TD]Cube Kingdom 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]935[/TD][/TR]
[TR][TD]159[/TD][TD]Chesapeake Science Point Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]931[/TD][/TR]
[TR][TD]160[/TD][TD]Cornell Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]926[/TD][/TR]
[TR][TD]161[/TD][TD]Starlight Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]924[/TD][/TR]
[TR][TD]162[/TD][TD]Stanford Fall 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]924[/TD][/TR]
[TR][TD]163[/TD][TD]Berkeley Summer 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]922[/TD][/TR]
[TR][TD]164[/TD][TD]San Diego Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]920[/TD][/TR]
[TR][TD]165[/TD][TD]Dixon Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]919[/TD][/TR]
[TR][TD]166[/TD][TD]Iowa Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]919[/TD][/TR]
[TR][TD]167[/TD][TD]New Albany Open 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]916[/TD][/TR]
[TR][TD]168[/TD][TD]Harvard Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]914[/TD][/TR]
[TR][TD]169[/TD][TD]Washington DC Spring 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]914[/TD][/TR]
[TR][TD]170[/TD][TD]Armonk Spring competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]912[/TD][/TR]
[TR][TD]171[/TD][TD]Berkeley Spring competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]909[/TD][/TR]
[TR][TD]172[/TD][TD]Cat and Mouse 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]908[/TD][/TR]
[TR][TD]173[/TD][TD]Carnegie Mellon Fall 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]904[/TD][/TR]
[TR][TD]174[/TD][TD]Caltech Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]901[/TD][/TR]
[TR][TD]175[/TD][TD]Caltech Fall competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]896[/TD][/TR]
[TR][TD]176[/TD][TD]EPGY Stanford Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]892[/TD][/TR]
[TR][TD]177[/TD][TD]Raleigh Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]889[/TD][/TR]
[TR][TD]178[/TD][TD]Stanford Spring 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]883[/TD][/TR]
[TR][TD]179[/TD][TD]EPGY California Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]883[/TD][/TR]
[TR][TD]180[/TD][TD]Pleasantville Fall competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]880[/TD][/TR]
[TR][TD]181[/TD][TD]Remember The Alamo 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]878[/TD][/TR]
[TR][TD]182[/TD][TD]Cornell Open Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]874[/TD][/TR]
[TR][TD]183[/TD][TD]Southwest Showdown 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]873[/TD][/TR]
[TR][TD]184[/TD][TD]Berkeley Spring 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]870[/TD][/TR]
[TR][TD]185[/TD][TD]Berkeley Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]869[/TD][/TR]
[TR][TD]186[/TD][TD]Carnegie Mellon Fall 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]867[/TD][/TR]
[TR][TD]187[/TD][TD]Thankscubing Day 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]864[/TD][/TR]
[TR][TD]188[/TD][TD]UIndy Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]862[/TD][/TR]
[TR][TD]189[/TD][TD]Minnesota Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]860[/TD][/TR]
[TR][TD]190[/TD][TD]Da Vinci Science Center competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]860[/TD][/TR]
[TR][TD]191[/TD][TD]Berkeley Fall competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]860[/TD][/TR]
[TR][TD]192[/TD][TD]Indiana Summer Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]857[/TD][/TR]
[TR][TD]193[/TD][TD]Vidar Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]855[/TD][/TR]
[TR][TD]194[/TD][TD]EPGY Stanford Winter 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]853[/TD][/TR]
[TR][TD]195[/TD][TD]Berkeley Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]853[/TD][/TR]
[TR][TD]196[/TD][TD]CCFC BLD Day 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]835[/TD][/TR]
[TR][TD]197[/TD][TD]Iowa Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]830[/TD][/TR]
[TR][TD]198[/TD][TD]Mid-Columbia Cubing Competition 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]829[/TD][/TR]
[TR][TD]199[/TD][TD]Caltech Summer competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]828[/TD][/TR]
[TR][TD]200[/TD][TD]Hillsdale Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]825[/TD][/TR]
[TR][TD]201[/TD][TD]Berkeley Fall competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]825[/TD][/TR]
[TR][TD]202[/TD][TD]Bay Area Speedcubin' Summer 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]821[/TD][/TR]
[TR][TD]203[/TD][TD]Berkeley Summer competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]814[/TD][/TR]
[TR][TD]204[/TD][TD]Caltech Fall competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]812[/TD][/TR]
[TR][TD]205[/TD][TD]Berkeley Mind Sports 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]811[/TD][/TR]
[TR][TD]206[/TD][TD]Kansas Cube Off 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]810[/TD][/TR]
[TR][TD]207[/TD][TD]Marymount Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]805[/TD][/TR]
[TR][TD]208[/TD][TD]Bayview Hills Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]799[/TD][/TR]
[TR][TD]209[/TD][TD]Lynden Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]795[/TD][/TR]
[TR][TD]210[/TD][TD]Berkeley Summer 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]792[/TD][/TR]
[TR][TD]211[/TD][TD]Virginia Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]787[/TD][/TR]
[TR][TD]212[/TD][TD]Marietta Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]785[/TD][/TR]
[TR][TD]213[/TD][TD]Washington DC Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]784[/TD][/TR]
[TR][TD]214[/TD][TD]Appalachia 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]783[/TD][/TR]
[TR][TD]215[/TD][TD]Berkeley Winter 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]782[/TD][/TR]
[TR][TD]216[/TD][TD]Captain's Cove competition 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]781[/TD][/TR]
[TR][TD]217[/TD][TD]Antelope Valley Summer 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]781[/TD][/TR]
[TR][TD]218[/TD][TD]Battle of Appalachia 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]781[/TD][/TR]
[TR][TD]219[/TD][TD]Caltech Spring competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]779[/TD][/TR]
[TR][TD]220[/TD][TD]CCFC Winter 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]778[/TD][/TR]
[TR][TD]221[/TD][TD]Ohio Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]775[/TD][/TR]
[TR][TD]222[/TD][TD]Couve Cubing 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]770[/TD][/TR]
[TR][TD]223[/TD][TD]Brown Cubing Day 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]769[/TD][/TR]
[TR][TD]224[/TD][TD]Eagle Peak - San Diego Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]765[/TD][/TR]
[TR][TD]225[/TD][TD]Dayton Blind 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]759[/TD][/TR]
[TR][TD]226[/TD][TD]Minnesota Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]759[/TD][/TR]
[TR][TD]227[/TD][TD]Cornell Open Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]758[/TD][/TR]
[TR][TD]228[/TD][TD]Dallas Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]755[/TD][/TR]
[TR][TD]229[/TD][TD]Stanford Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]753[/TD][/TR]
[TR][TD]230[/TD][TD]UIUC Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]753[/TD][/TR]
[TR][TD]231[/TD][TD]Coastal Cubing 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]751[/TD][/TR]
[TR][TD]232[/TD][TD]Carnegie Mellon Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]751[/TD][/TR]
[TR][TD]233[/TD][TD]Mall of America 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]750[/TD][/TR]
[TR][TD]234[/TD][TD]Berkeley Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]746[/TD][/TR]
[TR][TD]235[/TD][TD]San Diego 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]746[/TD][/TR]
[TR][TD]236[/TD][TD]Captain's Cove competition 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]743[/TD][/TR]
[TR][TD]237[/TD][TD]Brown Cubing Day 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]743[/TD][/TR]
[TR][TD]238[/TD][TD]Dayton Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]741[/TD][/TR]
[TR][TD]239[/TD][TD]Berkeley Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]741[/TD][/TR]
[TR][TD]240[/TD][TD]Cumberland Valley Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]739[/TD][/TR]
[TR][TD]241[/TD][TD]Colorado Springs 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]737[/TD][/TR]
[TR][TD]242[/TD][TD]San Diego Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]734[/TD][/TR]
[TR][TD]243[/TD][TD]Virginia Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]728[/TD][/TR]
[TR][TD]244[/TD][TD]Houston Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]727[/TD][/TR]
[TR][TD]245[/TD][TD]Carnegie Mellon Spring 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]724[/TD][/TR]
[TR][TD]246[/TD][TD]San Diego Summer Splash 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]723[/TD][/TR]
[TR][TD]247[/TD][TD]UC Berkeley Fall competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]722[/TD][/TR]
[TR][TD]248[/TD][TD]Discovery Science Center competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]721[/TD][/TR]
[TR][TD]249[/TD][TD]Berkeley Spring competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]720[/TD][/TR]
[TR][TD]250[/TD][TD]Stanford Fall 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]718[/TD][/TR]
[TR][TD]251[/TD][TD]Cubetcha 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]717[/TD][/TR]
[TR][TD]252[/TD][TD]Diamond Bar Open 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]716[/TD][/TR]
[TR][TD]253[/TD][TD]Minnesota Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]715[/TD][/TR]
[TR][TD]254[/TD][TD]Dayton Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]712[/TD][/TR]
[TR][TD]255[/TD][TD]Battle of Lexington 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]712[/TD][/TR]
[TR][TD]256[/TD][TD]Safe Haven competition 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]710[/TD][/TR]
[TR][TD]257[/TD][TD]DeVry University Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]705[/TD][/TR]
[TR][TD]258[/TD][TD]Nebraska Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]703[/TD][/TR]
[TR][TD]259[/TD][TD]Utah Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]700[/TD][/TR]
[TR][TD]260[/TD][TD]Boulder 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]697[/TD][/TR]
[TR][TD]261[/TD][TD]UPenn Spring competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]674[/TD][/TR]
[TR][TD]262[/TD][TD]Harvard Fall 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]672[/TD][/TR]
[TR][TD]263[/TD][TD]Caltech Fall competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]666[/TD][/TR]
[TR][TD]264[/TD][TD]Marietta Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]664[/TD][/TR]
[TR][TD]265[/TD][TD]Drexel Winter competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]663[/TD][/TR]
[TR][TD]266[/TD][TD]Captain's Cove competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]655[/TD][/TR]
[TR][TD]267[/TD][TD]Dallas Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]654[/TD][/TR]
[TR][TD]268[/TD][TD]Drexel Fall 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]654[/TD][/TR]
[TR][TD]269[/TD][TD]Austin Fall competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]648[/TD][/TR]
[TR][TD]270[/TD][TD]Stanford Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]641[/TD][/TR]
[TR][TD]271[/TD][TD]Carnegie Mellon Spring 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]639[/TD][/TR]
[TR][TD]272[/TD][TD]Denver Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]639[/TD][/TR]
[TR][TD]273[/TD][TD]Diamond Bar Spring Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]633[/TD][/TR]
[TR][TD]274[/TD][TD]Antelope Valley Winter 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]632[/TD][/TR]
[TR][TD]275[/TD][TD]South Texas Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]627[/TD][/TR]
[TR][TD]276[/TD][TD]Rutgers Fall competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]624[/TD][/TR]
[TR][TD]277[/TD][TD]Twin Cities Cubing Classic 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]623[/TD][/TR]
[TR][TD]278[/TD][TD]Carnegie Mellon Spring 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]621[/TD][/TR]
[TR][TD]279[/TD][TD]Kearny Kardinal competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]620[/TD][/TR]
[TR][TD]280[/TD][TD]Utah Cubing Fall Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]619[/TD][/TR]
[TR][TD]281[/TD][TD]Antelope Valley Spring Open 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]619[/TD][/TR]
[TR][TD]282[/TD][TD]Austin Spring competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]608[/TD][/TR]
[TR][TD]283[/TD][TD]Discovery Science Center competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]606[/TD][/TR]
[TR][TD]284[/TD][TD]Captain's Cove competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]604[/TD][/TR]
[TR][TD]285[/TD][TD]Arizona Showdown 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]602[/TD][/TR]
[TR][TD]286[/TD][TD]San Diego competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]597[/TD][/TR]
[TR][TD]287[/TD][TD]Horizons Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]592[/TD][/TR]
[TR][TD]288[/TD][TD]Carnegie Mellon Spring 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]587[/TD][/TR]
[TR][TD]289[/TD][TD]Cincinnati Spring Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]582[/TD][/TR]
[TR][TD]290[/TD][TD]San Diego Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]581[/TD][/TR]
[TR][TD]291[/TD][TD]Chattahoochee Spring competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]579[/TD][/TR]
[TR][TD]292[/TD][TD]Rutgers Spring competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]578[/TD][/TR]
[TR][TD]293[/TD][TD]UCSD Summer competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]575[/TD][/TR]
[TR][TD]294[/TD][TD]Kansas Cube-Off 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]570[/TD][/TR]
[TR][TD]295[/TD][TD]Virginia Open 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]567[/TD][/TR]
[TR][TD]296[/TD][TD]Aurora Summer competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]564[/TD][/TR]
[TR][TD]297[/TD][TD]Colorado Springs Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]564[/TD][/TR]
[TR][TD]298[/TD][TD]Chattahoochee Spring competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]563[/TD][/TR]
[TR][TD]299[/TD][TD]Minnesota Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]562[/TD][/TR]
[TR][TD]300[/TD][TD]Colorado Springs 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]559[/TD][/TR]
[TR][TD]301[/TD][TD]Discovery Science Center competition 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]559[/TD][/TR]
[TR][TD]302[/TD][TD]Arizona Winter 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]555[/TD][/TR]
[TR][TD]303[/TD][TD]Nisei Week 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]547[/TD][/TR]
[TR][TD]304[/TD][TD]Caltech Discovery Spring competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]546[/TD][/TR]
[TR][TD]305[/TD][TD]Denver Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]539[/TD][/TR]
[TR][TD]306[/TD][TD]Caltech Winter competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]535[/TD][/TR]
[TR][TD]307[/TD][TD]Indiana Winter Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]534[/TD][/TR]
[TR][TD]308[/TD][TD]Boulder 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]533[/TD][/TR]
[TR][TD]309[/TD][TD]Arizona Open 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]528[/TD][/TR]
[TR][TD]310[/TD][TD]UCSD competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]524[/TD][/TR]
[TR][TD]311[/TD][TD]San Diego competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]507[/TD][/TR]
[TR][TD]312[/TD][TD]Cincinnati Summer Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]504[/TD][/TR]
[TR][TD]313[/TD][TD]Rutgers Fall competition 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]504[/TD][/TR]
[TR][TD]314[/TD][TD]Carnegie Mellon Fall 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]489[/TD][/TR]
[TR][TD]315[/TD][TD]Cornell Spring competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]487[/TD][/TR]
[TR][TD]316[/TD][TD]Lexington Fall Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]486[/TD][/TR]
[TR][TD]317[/TD][TD]Houston Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]483[/TD][/TR]
[TR][TD]318[/TD][TD]Trumbull Spring competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]482[/TD][/TR]
[TR][TD]319[/TD][TD]Horace Mann Spring competition 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]480[/TD][/TR]
[TR][TD]320[/TD][TD]Houston Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]479[/TD][/TR]
[TR][TD]321[/TD][TD]Cornell Spring competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]475[/TD][/TR]
[TR][TD]322[/TD][TD]Caltech Fall competition 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]452[/TD][/TR]
[TR][TD]323[/TD][TD]Stetson Spring competition 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]449[/TD][/TR]
[TR][TD]324[/TD][TD]Wisconsin Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]444[/TD][/TR]
[TR][TD]325[/TD][TD]Washington DC Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]437[/TD][/TR]
[TR][TD]326[/TD][TD]Captains Cove competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]435[/TD][/TR]
[TR][TD]327[/TD][TD]US Nationals 2004[/TD][TD="align:right"]2004[/TD][TD="align:right"]435[/TD][/TR]
[TR][TD]328[/TD][TD]Utah Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]434[/TD][/TR]
[TR][TD]329[/TD][TD]Missouri Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]432[/TD][/TR]
[TR][TD]330[/TD][TD]Caltech Dallas Summer competition 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]431[/TD][/TR]
[TR][TD]331[/TD][TD]Utah Summer 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]430[/TD][/TR]
[TR][TD]332[/TD][TD]Small Cubes Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]414[/TD][/TR]
[TR][TD]333[/TD][TD]Moose Lodge 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]406[/TD][/TR]
[TR][TD]334[/TD][TD]Big Cubes Summer competition 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]400[/TD][/TR]
[TR][TD]335[/TD][TD]Rutgers Spring competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]382[/TD][/TR]
[TR][TD]336[/TD][TD]Nisei Week Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]379[/TD][/TR]
[TR][TD]337[/TD][TD]Discovery Science Center 10th Anniversary 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]359[/TD][/TR]
[TR][TD]338[/TD][TD]Nisei Week 2013[/TD][TD="align:right"]2013[/TD][TD="align:right"]357[/TD][/TR]
[TR][TD]339[/TD][TD]Caltech Spring competition 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]356[/TD][/TR]
[TR][TD]340[/TD][TD]Austin Open 2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]355[/TD][/TR]
[TR][TD]341[/TD][TD]Utah Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]350[/TD][/TR]
[TR][TD]342[/TD][TD]G-Wiz Fall competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]350[/TD][/TR]
[TR][TD]343[/TD][TD]Reno/Lake Tahoe Winter 2010 Cube Competition[/TD][TD="align:right"]2010[/TD][TD="align:right"]348[/TD][/TR]
[TR][TD]344[/TD][TD]Caltech Prefrosh 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]333[/TD][/TR]
[TR][TD]345[/TD][TD]Drexel's Winter 2010 Rubik's Cube Competition[/TD][TD="align:right"]2010[/TD][TD="align:right"]325[/TD][/TR]
[TR][TD]346[/TD][TD]Caltech Winter competition 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]322[/TD][/TR]
[TR][TD]347[/TD][TD]Full Sail Spring 2011[/TD][TD="align:right"]2011[/TD][TD="align:right"]318[/TD][/TR]
[TR][TD]348[/TD][TD]Minnesota Open 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]314[/TD][/TR]
[TR][TD]349[/TD][TD]Nisei Week 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]311[/TD][/TR]
[TR][TD]350[/TD][TD]Denver Open 2010[/TD][TD="align:right"]2010[/TD][TD="align:right"]309[/TD][/TR]
[TR][TD]351[/TD][TD]Northern California Fall Open 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]298[/TD][/TR]
[TR][TD]352[/TD][TD]Caltech Fall competition 2004[/TD][TD="align:right"]2004[/TD][TD="align:right"]293[/TD][/TR]
[TR][TD]353[/TD][TD]Cal Day 2012[/TD][TD="align:right"]2012[/TD][TD="align:right"]285[/TD][/TR]
[TR][TD]354[/TD][TD]Chattahoochee Spring competition 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]279[/TD][/TR]
[TR][TD]355[/TD][TD]Nisei Week Open 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]272[/TD][/TR]
[TR][TD]356[/TD][TD]Idaho Open 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]239[/TD][/TR]
[TR][TD]357[/TD][TD]Midwest competition 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]225[/TD][/TR]
[TR][TD]358[/TD][TD]Discovery Science Center Winter 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]223[/TD][/TR]
[TR][TD]359[/TD][TD]Fantastic Michigan Competition 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]221[/TD][/TR]
[TR][TD]360[/TD][TD]Caltech Spring competition 2004[/TD][TD="align:right"]2004[/TD][TD="align:right"]205[/TD][/TR]
[TR][TD]361[/TD][TD]Draughons Eastern competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]198[/TD][/TR]
[TR][TD]362[/TD][TD]Decatur Open2008[/TD][TD="align:right"]2008[/TD][TD="align:right"]196[/TD][/TR]
[TR][TD]363[/TD][TD]Florida Open 2007[/TD][TD="align:right"]2007[/TD][TD="align:right"]170[/TD][/TR]
[TR][TD]364[/TD][TD]Chattahoochee Spring competition 2006[/TD][TD="align:right"]2006[/TD][TD="align:right"]166[/TD][/TR]
[TR][TD]365[/TD][TD]Caltech Winter competition 2004[/TD][TD="align:right"]2004[/TD][TD="align:right"]136[/TD][/TR]
[TR][TD]366[/TD][TD]Idaho Open 2005[/TD][TD="align:right"]2005[/TD][TD="align:right"]128[/TD][/TR]
[TR][TD]367[/TD][TD]San Diego Science Festival 2009[/TD][TD="align:right"]2009[/TD][TD="align:right"]87[/TD][/TR]
[TR][TD]368[/TD][TD]Kennedy Middle School Fall competition 2004[/TD][TD="align:right"]2004[/TD][TD="align:right"]84[/TD][/TR]
[TR][TD]369[/TD][TD]MIT FMC 2014[/TD][TD="align:right"]2014[/TD][TD="align:right"]19[/TD][/TR]
[/TABLE]

SELECT Competitions.name, year, sum(solves) totalSolves

FROM

(SELECT
competitionId,

sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves

FROM Results

GROUP BY competitionId) tmp

JOIN Competitions ON Competitions.id = competitionId

WHERE Competitions.countryId = 'USA'

GROUP BY Competitions.name

ORDER BY totalSolves DESC
;

Stefan · Sep 1, 2014

Cale S said:
21 years for Jessica Fridrich and Lars Petrus.

Nope, that's second place. Try again, you have a couple minutes left

TMOY · Sep 1, 2014

I think you mean Lars Petrus and Guus Razoux Schulz. But once again, counting WC 1982 and no other 80s comp leads to a totally meaningless result.

Cale S · Sep 1, 2014

Stefan said:
Nope, that's second place. Try again, you have a couple minutes left

Just found it, Guus Razoux Schultz and Lars Petrus did after 25 years. I should learn how to use a statistics finding program to avoid mistakes like that.

Stefan · Sep 2, 2014

TMOY said:
I think you mean Lars Petrus and Guus Razoux Schulz. But once again, counting WC 1982 and no other 80s comp leads to a totally meaningless result.

Yes, Lars and Guus. And I'd say it's not meaningless, it does has the meaning it does have (i.e., considering WCA data (which is appropriate in a thread about WCA data)).

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Cuber[/TD][TD]~Years[/TD][TD]From[/TD][TD]To[/TD][/TR]
[TR][TD]Lars Petrus[/TD][TD]Guus Razoux Schultz[/TD][TD="align:right"]25.33[/TD][TD]WC1982[/TD][TD]WC2007[/TD][/TR]
[TR][TD]Jessica Fridrich[/TD][TD]Lars Petrus[/TD][TD="align:right"]21.21[/TD][TD]WC1982[/TD][TD]WC2003[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Bob Burton[/TD][TD="align:right"]9.92[/TD][TD]WC2003[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Chris Hardwick[/TD][TD="align:right"]9.92[/TD][TD]WC2003[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Ron van Bruchem[/TD][TD="align:right"]9.92[/TD][TD]WC2003[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Anders Larsson[/TD][TD="align:right"]9.92[/TD][TD]WC2003[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Ian Winokur[/TD][TD="align:right"]9.92[/TD][TD]WC2003[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Jasmine Lee[/TD][TD="align:right"]9.92[/TD][TD]WC2003[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Lars Vandenbergh[/TD][TD="align:right"]9.92[/TD][TD]WC2003[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Michael Grimsley[/TD][TD="align:right"]8.77[/TD][TD]CaltechFall2004[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lars Petrus[/TD][TD]Kenneth Brandon[/TD][TD="align:right"]8.77[/TD][TD]CaltechFall2004[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Shelley Chang[/TD][TD="align:right"]8.77[/TD][TD]CaltechFall2004[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Adam Zamora[/TD][TD="align:right"]8.77[/TD][TD]CaltechFall2004[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Shotaro Makisumi (牧角章太郎)[/TD][TD="align:right"]8.77[/TD][TD]CaltechFall2004[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kenneth Brandon[/TD][TD]Tyson Mao (毛台勝)[/TD][TD="align:right"]8.77[/TD][TD]CaltechFall2004[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lacey Burton[/TD][TD]Daniel Lo[/TD][TD="align:right"]8.64[/TD][TD]Rutgers2005[/TD][TD]USNationals2014[/TD][/TR]
[TR][TD]Adam Zamora[/TD][TD]Lacey Burton[/TD][TD="align:right"]8.64[/TD][TD]Rutgers2005[/TD][TD]USNationals2014[/TD][/TR]
[TR][TD]Bob Burton Sr.[/TD][TD]Daniel Lo[/TD][TD="align:right"]8.64[/TD][TD]Rutgers2005[/TD][TD]USNationals2014[/TD][/TR]
[TR][TD]Adam Zamora[/TD][TD]Bob Burton Sr.[/TD][TD="align:right"]8.64[/TD][TD]Rutgers2005[/TD][TD]USNationals2014[/TD][/TR]
[TR][TD]Antonio Gallego Zambrano[/TD][TD]Jesús Masanet García[/TD][TD="align:right"]8.08[/TD][TD]Spain2004[/TD][TD]SpanishChampionship2012[/TD][/TR]
[TR][TD]István Kocza[/TD][TD]Martin Daněk[/TD][TD="align:right"]7.96[/TD][TD]CzechOpen2006[/TD][TD]CzechOpen2014[/TD][/TR]
[TR][TD]Martin Daněk[/TD][TD]Hana Kotinova[/TD][TD="align:right"]7.96[/TD][TD]CzechOpen2006[/TD][TD]CzechOpen2014[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Greg Austin[/TD][TD="align:right"]7.72[/TD][TD]UKOpen2006[/TD][TD]Euro2014[/TD][/TR]
[TR][TD]Stefan Pochmann[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Casey Pernsteiner[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Jasmine Lee[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ian Winokur[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Anders Larsson[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ian Winokur[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Jasmine Lee[/TD][TD]Michael Grimsley[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Anders Larsson[/TD][TD]Casey Pernsteiner[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Peter Still[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Michael Grimsley[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Anders Larsson[/TD][TD]Ian Winokur[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Dave Campbell[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ian Winokur[/TD][TD]Michael Grimsley[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD]Peter Still[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Casey Pernsteiner[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Daniel Lo[/TD][TD="align:right"]7.72[/TD][TD]WC2005[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Andy Camann[/TD][TD]Ian Winokur[/TD][TD="align:right"]7.45[/TD][TD]WC2005[/TD][TD]YaleSpring2013[/TD][/TR]
[TR][TD]Tadayoshi Hirota (廣田忠宣)[/TD][TD]Takayuki Ookusa (大艸尊之)[/TD][TD="align:right"]7.39[/TD][TD]OGU2006[/TD][TD]KansaiOpen2014[/TD][/TR]
[TR][TD]Tadayoshi Hirota (廣田忠宣)[/TD][TD]Yohei Suzuki (鈴木洋平)[/TD][TD="align:right"]7.39[/TD][TD]OGU2006[/TD][TD]KansaiOpen2014[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Tadayoshi Hirota (廣田忠宣)[/TD][TD="align:right"]7.39[/TD][TD]OGU2006[/TD][TD]KansaiOpen2014[/TD][/TR]
[TR][TD]Yu Araki (荒木由布)[/TD][TD]Tadayoshi Hirota (廣田忠宣)[/TD][TD="align:right"]7.39[/TD][TD]OGU2006[/TD][TD]KansaiOpen2014[/TD][/TR]
[TR][TD]Tadayoshi Hirota (廣田忠宣)[/TD][TD]Yohei Oka (岡要平)[/TD][TD="align:right"]7.39[/TD][TD]OGU2006[/TD][TD]KansaiOpen2014[/TD][/TR]
[TR][TD]Alan Chang[/TD][TD]Chris Dzoan[/TD][TD="align:right"]7.30[/TD][TD]BerkeleySpring2007[/TD][TD]USNationals2014[/TD][/TR]
[TR][TD]Shotaro Makisumi (牧角章太郎)[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]7.28[/TD][TD]CaltechSpring2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Kåre Krig[/TD][TD]Greg Austin[/TD][TD="align:right"]7.27[/TD][TD]GermanOpen2007[/TD][TD]Euro2014[/TD][/TR]
[TR][TD]Gunnar Krig[/TD][TD]Greg Austin[/TD][TD="align:right"]7.27[/TD][TD]GermanOpen2007[/TD][TD]Euro2014[/TD][/TR]
[TR][TD]István Kocza[/TD][TD]Hana Kotinova[/TD][TD="align:right"]6.99[/TD][TD]CzechOpen2007[/TD][TD]CzechOpen2014[/TD][/TR]
[TR][TD]Hana Kotinova[/TD][TD]Jan Hetych[/TD][TD="align:right"]6.99[/TD][TD]CzechOpen2007[/TD][TD]CzechOpen2014[/TD][/TR]
[TR][TD]Daniel Hermansson[/TD][TD]István Kocza[/TD][TD="align:right"]6.97[/TD][TD]SwedishCubeDay2006[/TD][TD]SwedishCubeDays2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Ernie Valdés[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD]Ravi Fernando[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Chris Hardwick[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD]Tim Reynolds[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ravi Fernando[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Chris Hardwick[/TD][TD]Ernie Valdés[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Chris Hardwick[/TD][TD]Michael Grimsley[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD]Bruce Norskog[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Tim Reynolds[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Casey Pernsteiner[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Bruce Norskog[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Ambie Valdés[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD]Casey Pernsteiner[/TD][TD="align:right"]6.97[/TD][TD]US2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]John George[/TD][TD]Riley Woo[/TD][TD="align:right"]6.93[/TD][TD]CaltechSummer2007[/TD][TD]USNationals2014[/TD][/TR]
[TR][TD]Ryosuke Higo (肥後亮佑)[/TD][TD]Kou Oobatake (大畠功)[/TD][TD="align:right"]6.90[/TD][TD]Osaka2007[/TD][TD]KantoOpen2014[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Mads Mohr Christensen[/TD][TD="align:right"]6.83[/TD][TD]WC2007[/TD][TD]Euro2014[/TD][/TR]
[TR][TD]Gergely Csányi[/TD][TD]Joffrey Lenoble[/TD][TD="align:right"]6.83[/TD][TD]WC2007[/TD][TD]Euro2014[/TD][/TR]
[TR][TD]Anders Larsson[/TD][TD]Gergely Csányi[/TD][TD="align:right"]6.83[/TD][TD]WC2007[/TD][TD]Euro2014[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Joffrey Lenoble[/TD][TD="align:right"]6.83[/TD][TD]WC2007[/TD][TD]Euro2014[/TD][/TR]
[TR][TD]Micael Hellberg[/TD][TD]Gunnar Krig[/TD][TD="align:right"]6.80[/TD][TD]Sweden2004[/TD][TD]SwedishChampionship2011[/TD][/TR]
[TR][TD]Micael Hellberg[/TD][TD]Kåre Krig[/TD][TD="align:right"]6.80[/TD][TD]Sweden2004[/TD][TD]SwedishChampionship2011[/TD][/TR]
[TR][TD]Anders Larsson[/TD][TD]Bertalan Bodor[/TD][TD="align:right"]6.78[/TD][TD]WC2007[/TD][TD]CroatianOpen2014[/TD][/TR]
[TR][TD]Ryosuke Higo (肥後亮佑)[/TD][TD]Mina Tomita (富田美菜)[/TD][TD="align:right"]6.75[/TD][TD]JapanOpen2007[/TD][TD]JapanContestSpring2014[/TD][/TR]
[TR][TD]Gracie Baird[/TD][TD]Harris Karsch[/TD][TD="align:right"]6.74[/TD][TD]PleasantvilleFall2007[/TD][TD]USNationals2014[/TD][/TR]
[TR][TD]Jasmine Lee[/TD][TD]Jeremy Dixon[/TD][TD="align:right"]6.74[/TD][TD]WC2005[/TD][TD]USNationals2012[/TD][/TR]
[TR][TD]Jeremy Dixon[/TD][TD]Peter Still[/TD][TD="align:right"]6.74[/TD][TD]WC2005[/TD][TD]USNationals2012[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD]Ernie Valdés[/TD][TD="align:right"]6.70[/TD][TD]CaltechFall2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Shotaro Makisumi (牧角章太郎)[/TD][TD]Michael Grimsley[/TD][TD="align:right"]6.70[/TD][TD]CaltechFall2006[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Julien Rischard[/TD][TD="align:right"]6.65[/TD][TD]Euro2006[/TD][TD]HEMMariCubikOpen2013[/TD][/TR]
[TR][TD]Anthony Hsu[/TD][TD]Daniel Lo[/TD][TD="align:right"]6.64[/TD][TD]Rutgers2005[/TD][TD]USNationals2012[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD]Raiza Mativo[/TD][TD="align:right"]6.63[/TD][TD]RutgersFall2006[/TD][TD]CanadianOpen2013[/TD][/TR]
[TR][TD]Choi Go-Ho (최고호)[/TD][TD]Shin Hyo-Eun (신효은)[/TD][TD="align:right"]6.61[/TD][TD]KCAKoreaOpen2008[/TD][TD]BusanSummer2014[/TD][/TR]
[TR][TD]Shin Hyo-Eun (신효은)[/TD][TD]Yunsu Nam (남윤수)[/TD][TD="align:right"]6.61[/TD][TD]KCAKoreaOpen2008[/TD][TD]BusanSummer2014[/TD][/TR]
[TR][TD]JaeYoung Chun (천재영)[/TD][TD]Shin Hyo-Eun (신효은)[/TD][TD="align:right"]6.61[/TD][TD]KCAKoreaOpen2008[/TD][TD]BusanSummer2014[/TD][/TR]
[TR][TD]Shin Hyo-Eun (신효은)[/TD][TD]JaeMin Kim (김재민)[/TD][TD="align:right"]6.61[/TD][TD]KCAKoreaOpen2008[/TD][TD]BusanSummer2014[/TD][/TR]
[TR][TD]Edouard Chambon[/TD][TD]Norbert Hantos[/TD][TD="align:right"]6.59[/TD][TD]GermanOpen2007[/TD][TD]HungarianOpen2013[/TD][/TR]
[TR][TD]Junya Tomita (富田純也)[/TD][TD]Ryosuke Higo (肥後亮佑)[/TD][TD="align:right"]6.57[/TD][TD]JapanOpen2007[/TD][TD]KantoOpen2014[/TD][/TR]
[TR][TD]Ryosuke Higo (肥後亮佑)[/TD][TD]Yui Tomita (富田唯依)[/TD][TD="align:right"]6.57[/TD][TD]JapanOpen2007[/TD][TD]KantoOpen2014[/TD][/TR]
[TR][TD]Alan Chang[/TD][TD]Jeremy Dixon[/TD][TD="align:right"]6.55[/TD][TD]CaltechWinter2006[/TD][TD]USNationals2012[/TD][/TR]
[TR][TD]Alan Chang[/TD][TD]Casey Pernsteiner[/TD][TD="align:right"]6.55[/TD][TD]CaltechWinter2006[/TD][TD]USNationals2012[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Daniel Lo[/TD][TD="align:right"]6.53[/TD][TD]CaltechWinter2007[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD]Jim Mertens[/TD][TD="align:right"]6.53[/TD][TD]CaltechWinter2007[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Alexander Lin[/TD][TD="align:right"]6.53[/TD][TD]CaltechWinter2007[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Jim Mertens[/TD][TD="align:right"]6.53[/TD][TD]CaltechWinter2007[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Toby Mao (毛台立)[/TD][TD]Lauren Hanrahan[/TD][TD="align:right"]6.53[/TD][TD]CaltechWinter2007[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]David Gomes[/TD][TD="align:right"]6.53[/TD][TD]CaltechWinter2007[/TD][TD]WC2013[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD]David Gomes[/TD][TD="align:right"]6.53[/TD][TD]CaltechWinter2007[/TD][TD]WC2013[/TD][/TR]
[/TABLE]

Code:

[NOPARSE]from wca import *
from itertools import combinations

q = '''
SELECT distinct competitionId, date(year*10000+month*100+day) date, date(year*10000+endMonth*100+endDay) endDate, personId
FROM Results join Competitions on Competitions.id=competitionId
ORDER BY date, competitionId, personId'''

last_together = {}
longest_gap = defaultdict(lambda:(0,))
for competitionId, entries in group(query(q), 0):
    for a, b in combinations(entries, 2):
        date, endDate = a[1:3]
        pair = (a[3], b[3])
        if pair in last_together:
            last_date, last_comp = last_together[pair]
            gap = ((date - last_date).days - 1, last_comp, competitionId)
            longest_gap[pair] = max(longest_gap[pair], gap)
            last_together[pair] = max(last_together[pair], (endDate, competitionId))
        else:
            last_together[pair] = (endDate, competitionId)

create_post('Longest time taken for any two competitors to reunite.py',
            'Cuber Cuber ~Years From To'.split(),
            (pair + ('%.2f' % (gap[0] / 365.25),) + gap[1:]
             for pair, gap in sorted(longest_gap.items(), key=lambda pg: -pg[1][0])
             if gap[0] >= 2385))
[/NOPARSE]

Robert-Y · Sep 2, 2014

Wow, thanks again Stefan! I wonder how many of these pairs actually acknowledged each other

EDIT: I wonder if it would be "better" to measure how many competitions have passed by before the pair of competitors reunited?

Sebastien · Sep 2, 2014

Stefan said:
Using data from WCA_export458_20140901 and Stefan's WCA statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]personId[/TD][TD]personId[/TD][TD]competitions[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Maria Oey[/TD][TD="align:right"]79[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ton Dennenbroek[/TD][TD="align:right"]75[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Lars Vandenbergh[/TD][TD="align:right"]73[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]72[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Arnaud van Galen[/TD][TD="align:right"]69[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Jaclyn Sawler[/TD][TD="align:right"]68[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD]François Courtès[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Tim Reynolds[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Arnaud van Galen[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]Fumiki Koseki (古関章記)[/TD][TD]Sinpei Araki (荒木慎平)[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Lars Vandenbergh[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Erik Akkersdijk[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Hanneke Rijks[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Jeremy Fleischman[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Fumiki Koseki (古関章記)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]61[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]François Courtès[/TD][TD="align:right"]61[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Kian Barry[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Sébastien Auroux[/TD][TD="align:right"]59[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Arnaud van Galen[/TD][TD="align:right"]59[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Erik Akkersdijk[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Jan Bentlage[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Rowe Hessler[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD]Marcin Jakubowski[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Nobuaki Suga (菅信昭)[/TD][TD]Hideki Niina (新名秀樹)[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Laura Ohrndorf[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Hideki Niina (新名秀樹)[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Mats Valk[/TD][TD="align:right"]56[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Yohei Oka (岡要平)[/TD][TD="align:right"]55[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Arnaud van Galen[/TD][TD="align:right"]55[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD]Rowe Hessler[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]François Courtès[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD]Maria Oey[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Takayuki Ookusa (大艸尊之)[/TD][TD="align:right"]53[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Erik Akkersdijk[/TD][TD="align:right"]53[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Maria Oey[/TD][TD="align:right"]52[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD]Hanneke Rijks[/TD][TD="align:right"]52[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Yu Nakajima (中島悠)[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Maria Oey[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Yu Nakajima (中島悠)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Maria Oey[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Adam Zamora[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Mats Valk[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD]François Courtès[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD]Devin Corr-Robinett[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Devin Corr-Robinett[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD]Kian Barry[/TD][TD="align:right"]50[/TD][/TR]
[/TABLE]

CREATE TABLE participations
SELECT distinct Results.personId, competitionId
FROM Results
WHERE personId in (SELECT personId FROM Results GROUP BY personId HAVING count(distinct competitionId)>=50);

SELECT a.personId, b.personId, count(*) competitions
FROM participations a, participations b
WHERE a.competitionId=b.competitionId and a.personId<b.personId
GROUP BY a.personId, b.personId
HAVING competitions>=50
ORDER BY competitions desc;

DROP TABLE participations;

Using data from WCA_export458_20140901 and Stefan's WCA statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]personId[/TD][TD]personId[/TD][TD]personId[/TD][TD]competitions[/TD][/TR]
[TR][TD]Fumiki Koseki (古関章記)[/TD][TD]Sinpei Araki (荒木慎平)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ton Dennenbroek[/TD][TD]Lars Vandenbergh[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Nobuaki Suga (菅信昭)[/TD][TD]Hideki Niina (新名秀樹)[/TD][TD="align:right"]53[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Arnaud van Galen[/TD][TD]Maria Oey[/TD][TD="align:right"]52[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ton Dennenbroek[/TD][TD]Erik Akkersdijk[/TD][TD="align:right"]52[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Erik Akkersdijk[/TD][TD]Maria Oey[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Lars Vandenbergh[/TD][TD]Maria Oey[/TD][TD="align:right"]51[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Mats Valk[/TD][TD]Hanneke Rijks[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Ton Dennenbroek[/TD][TD]Maria Oey[/TD][TD="align:right"]50[/TD][/TR]
[/TABLE]

CREATE TABLE participations
SELECT distinct Results.personId, competitionId
FROM Results
WHERE personId in (SELECT personId FROM Results GROUP BY personId HAVING count(distinct competitionId)>=50);

SELECT a.personId, b.personId, c.personId, count(*) competitions
FROM participations a, participations b, participations c
WHERE a.competitionId=b.competitionId and a.competitionId=c.competitionId and a.personId<b.personId and b.personId<c.personId
GROUP BY a.personId, b.personId, c.personId
HAVING competitions>=50
ORDER BY competitions desc;

DROP TABLE participations;

How about most competitions of people, that have at least one other person that has been at each of their competitions?

Odd WCA stats/ Stats request Thread

Veteran

Regular

Veteran

Legend

Veteran

Veteran

Veteran

Legend

Legend

Legend

Veteran

Veteran

Administrator

Administrator

Legend

Veteran

Veteran

Legend

Legend

Premium Member

Similar threads