• Welcome to SpeedSolving.com — the world’s largest puzzle community!

    You’re currently browsing as a guest, which means you have limited access to discussions, resources, member profiles, and community features.

    Join 50,000+ cubers and puzzle enthusiasts from around the world to ask questions, share solves, improve faster, and be part of the community.

    Registration is free, fast, and easy — create your account today.

    Already a member? Log in here to hide this message and start participating.
Rubik's Clock WR (5.27) was set 527 days ago.
ip0e8h.jpg
 
This is kind of off topic but related to Japan Open: http://jrca.cc/modules/eguide/event.php?eid=53

If you look through the results by person: http://www.worldcubeassociation.org/results/c.php?byPerson=By+Person&competitionId=JapanOpen2013

You will notice that some competitors only competed in a few events, some competed but not even in Rubik's cube. I was wondering about the competing fees. It seems to me that every event costs 500 yen unless I mistranslated something. This is roughly over £3 or $5. Seems expensive but I guess it might be normal in Japan. Who knows, maybe that's actually cheap for them...
 
http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=JapanOpen2013

Full podiums in ALL events. How many times has this happened before in other "small" competitions? (No world or continental competitions (+US nats?...))

Looks like it's the only one since removal of magics. And only one competition that had full podiums for the previously 19 events had fewer competitors:
http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=SwedishChampionship2011
(77 competitors vs Japan's 83)
Though I'd call its fewest moves podium "overfull".

Code:
It's an ugly hack, don't look.

select aaa.competitionId, count(*), competitors from
(
SELECT competitionId, eventId, sum(if(best>0,1,0)) c
FROM `Results`
WHERE roundId in ('c','f')
group by competitionId, eventId
) aaa,
(select competitionId, count(distinct personId) competitors from Results group by competitionId) bbb
where aaa.competitionId=bbb.competitionId and c>=3
GROUP BY aaa.competitionId
order by 2 desc, 3
 
You will notice that some competitors only competed in a few events, some competed but not even in Rubik's cube. I was wondering about the competing fees. It seems to me that every event costs 500 yen unless I mistranslated something. This is roughly over £3 or $5. Seems expensive but I guess it might be normal in Japan. Who knows, maybe that's actually cheap for them...

I think I vaguely remember a Japanese competition where they had a limit of four events per competitor. Maybe it was similar to that.
 
http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=JapanOpen2013

Full podiums in ALL events. How many times has this happened before in other "small" competitions? (No world or continental competitions (+US nats?...))

The Czech Open has always ALL events since 2009 and is also a 3 day competition!
2012 http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=CzechOpen2012
2011 http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=CzechOpen2011
etc

And Czech is a small competition around 50 each year

And yes 2013 will have all event, and we even will have medals for all events ....
 
Last edited:
The Czech Open has always ALL events since 2009 and is also a 3 day competition!
2012 http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=CzechOpen2012
2011 http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=CzechOpen2011
etc

And Czech is a small competition around 50 each year

And yes 2013 will have all event, and we even will have medals for all events ....

True, but for both of these, 3rd place in 5BLD doesn't have a result, it's DNF, so the podium isn't "full" which is what rob was asking about.
 
I found 525 sub2 singles done by 226 persons:
Code:
Feliks Zemdegs                               25 Australia  
Cameron Stollery                             23 Australia  
Rowe Hessler                                 23 USA        
Christopher Olson                            22 USA        
Micha? Pleskowicz                            18 Poland     
Mats Valk                                    14 Netherlands
Yinghao Wang (???)                           14 China      
Justin Jaffray                               13 Canada     
Erik Akkersdijk                              10 Netherlands
Code:
Cornelius Dieckmann                           9 Germany
Milán Baticz                                  9 Hungary    
Carlos Méndez García-Barroso                  7 Spain      
Andy Smith                                    6 USA        
Anthony Brooks                                6 USA        
Dan Dzoan                                     6 USA        
Nipat Charoenpholphant (??????? ????????????  6 Thailand   
Austin Reed                                   5 USA        
Bill Wang                                     5 Canada     
Edward Lin                                    5 USA        
John Brechon                                  5 USA        
Yu Nakajima (???)                             5 Japan      
Ben Whitmore                                  4 United King
Bence Barát                                   4 Hungary    
Forte Shinko                                  4 Canada     
Gabriel Dechichi Barbar                       4 Brazil     
Jayden McNeill                                4 Australia  
Louis Cormier                                 4 Canada     
Micha? Robaczyk                               4 Poland     
Simon Westlund                                4 Sweden     
Timothy Sun                                   4 USA        
Weixing Zhang (???)                           4 China      
Zhouheng Sun (???)                            4 China      
Antoine Piau                                  3 France     
Asia Konvittayayotin (?????? ????????????)    3 Thailand   
Eric Limeback                                 3 Canada     
Justin Adsuara                                3 USA        
Kevin Guillaumond                             3 France     
Lee Kyeong-Sub (???)                          3 Korea      
Michael Young                                 3 USA        
Philippe Virouleau                            3 France     
Tim Reynolds                                  3 USA        
Yumu Tabuchi (????)                           3 Japan      
Andrea Lo Sardo                               2 Italy      
Arifumi Fushimi (????)                        2 Japan      
Daniel Sheppard                               2 United King
Edouard Chambon                               2 France     
Erik Johnson                                  2 USA        
Henrik Buus Aagaard                           2 Denmark    
Ivan Vynnyk (???? ??????)                     2 Ukraine    
Jakub Cabaj                                   2 Poland     
Javier París                                  2 Spain      
Jorge Castillo Matas                          2 Spain      
Kevin Zhou                                    2 USA        
Kirk Nicklaus Manibuy                         2 Indonesia  
Lucas Garron                                  2 Germany    
?ukasz Cia?o?                                 2 Poland     
Marvin Llaneta                                2 Philippines
Mateusz Fydrych                               2 Poland     
Mitchell Lane                                 2 USA        
Niklas Spies                                  2 Germany    
Nikolay Evdokimov                             2 Russia     
Oskar Åsbrink                                 2 Sweden     
Patrick Jameson                               2 USA        
Péter Trombitás                               2 Hungary    
Qingbin Chen (???)                            2 China      
Ravi Fernando                                 2 USA        
Richard Jay S. Apagar                         2 Philippines
Rowan Kinneavy                                2 United King
Sébastien Auroux                              2 Germany    
Steven Turner                                 2 USA        
Thompson Clarke                               2 Canada     
Xiaofeng Zheng (???)                          2 China      
Yuxuan Wang (???)                             2 China      
Adrian Jorghy                                 1 Indonesia  
Aksel Stadel Borum                            1 Denmark    
Albert Stanula                                1 Poland     
Alberto Pérez de Rada Fiol                    1 Spain      
Alexey Oblaukhov                              1 Russia     
Alfrisa Diva Wandana                          1 Indonesia  
Alvin Febrianth                               1 Indonesia  
Anders Bogan                                  1 USA        
Andreas Pohl                                  1 Germany    
Andrés Alfaro                                 1 Chile      
Andrew Ricci                                  1 USA        
Andy Bridger                                  1 USA        
Antoine Cantin                                1 Canada     
Anton Bedrichenko                             1 Russia     
Anton Rostovikov                              1 Russia     
Arnaud van Galen                              1 Netherlands
Auguste Olivry                                1 France     
Bob Burton                                    1 USA        
Brock Hamann                                  1 Australia  
Cameron Almasi                                1 USA        
Carl Thiringer                                1 Sweden     
Chengbiao Liu (???)                           1 China      
Chia-Wei Lu (???)                             1 Taiwan     
Christian Kaserer                             1 Italy      
Daniel Adrian López de Andrade                1 Brazil     
Daniel Mazurek                                1 Poland     
Dániel Varga                                  1 Hungary    
Daniel Wu                                     1 USA        
Dario Roa Sánchez                             1 Spain      
David Gomes                                   1 USA        
David Shi                                     1 USA        
David Woner                                   1 USA        
Devin Corr-Robinett                           1 USA        
Didier Batista Ferreira                       1 Portugal   
Dmitry Kryuzban                               1 Russia     
Dmitry Zvyagintsev                            1 Russia     
Ernie Pulchny                                 1 USA        
Ethan Crislip                                 1 USA        
Fandy Ramadhan Ganefianto                     1 Indonesia  
Filip Miazek                                  1 Poland     
Filippo Brancaleoni                           1 Italy      
Frank Egan                                    1 USA        
Frédéric Meinnel                              1 France     
Gabriel Guay                                  1 Canada     
Gaël Servignat                                1 France     
Giovanni Tessari                              1 Italy      
Giulio Grammatica                             1 Italy      
Gonzalo Serrano                               1 Chile      
Guillain Potron                               1 France     
Gunnar Krig                                   1 Sweden     
Hampus Hansson                                1 Sweden     
Haowei Fan (???)                              1 China      
Hendry Cahyadi                                1 Indonesia  
Jacco Krijnen                                 1 Netherlands
Jack Johnston                                 1 USA        
Jacob Lange                                   1 Sweden     
Jai Gambhir                                   1 Canada     
Jakub Kipa                                    1 Poland     
James Creswell                                1 USA        
Jan Bentlage                                  1 Germany    
Javier Enrique Espinoza Grijalva              1 Mexico     
Javier Martínez Bautista                      1 Mexico     
Jedrick Remonde                               1 Philippines
Jessica Uribe                                 1 USA        
Jiawen Wu (???)                               1 China      
John Edison Ubaldo                            1 Philippines
John Tamanas                                  1 USA        
Jonathan Esteban Rivera Castillón             1 Mexico     
Jonathan Hamstad                              1 Norway     
Joon Cha                                      1 Korea      
José Garrido                                  1 Chile      
Joseph Dzaluk                                 1 USA        
Jules Desjardin                               1 France     
Jules Manalang                                1 USA        
Kai Han (??)                                  1 China      
Kai Liu (??)                                  1 China      
Kailong Li (???)                              1 China      
Kanneti Sae Han (????????? ???????)           1 France     
Kian Barry                                    1 USA        
Kit Clement                                   1 USA        
Kristian Muggerud                             1 Norway     
Laetitia Lemoine                              1 France     
Lars Van den broeck                           1 Belgium    
Lars Vennike Nielsson                         1 Denmark    
Loïc Petit                                    1 France     
Lorenzo Vigani Poli                           1 Italy      
Louis Sarthou                                 1 France     
?ukasz Cichecki                               1 Poland     
Maarten Smit                                  1 Netherlands
Maciej Dura?ski                               1 Poland     
Marcin Jakubowski                             1 Poland     
Marcin Zalewski                               1 Poland     
Mariusz Wi?niewski                            1 Poland     
Marwin-Peter Kurth                            1 Germany    
Matt DiPalma                                  1 USA        
Matteo Provasi                                1 Italy      
Maxim Novikov                                 1 Russia     
Michael Gottlieb                              1 USA        
Michael Nguyen                                1 USA        
Michael Perkins                               1 USA        
Micha? Matczak                                1 Poland     
Mike Kotch                                    1 USA        
Morten Arborg                                 1 Norway     
Muhammad Jihan Khalilurrahman                 1 Indonesia  
Neel Shah                                     1 Canada     
Nicola Giordani                               1 Italy      
Nicolò Simone                                 1 Italy      
Niko Ronkainen                                1 Finland    
Niño Francis Reyes                            1 Philippines
Oscar Roth Andersen                           1 Denmark    
Paolo Girotti                                 1 Italy      
Paolo Moriello                                1 Italy      
Pawe? W?oszek                                 1 Poland     
Phil Thomas                                   1 USA        
Piti Pichedpan (???? ???????????)             1 Thailand   
Przemys?aw Kaleta                             1 Poland     
Quentin Lefebvre                              1 France     
Rashdaleena Athiefa Abdul Rashid              1 Malaysia   
Rémi Esturoune                                1 France     
Robert Yau                                    1 United King
Rongjin Huang (???)                           1 China      
Sei Sugama (???)                              1 Japan      
Sergey Ryabko                                 1 Russia     
Sergi Sabat                                   1 Spain      
Shuto Ueno (????)                             1 Japan      
Sixuan Lou (???)                              1 China      
S?awomir Kapka                                1 Poland     
Sukesh Subaharan                              1 India      
Syuhei Omura (????)                           1 Japan      
Thomas Watiotienne                            1 France     
Tim Major                                     1 Australia  
Ting Sheng Bao Yang                           1 Spain      
Tomasz Kaczorowski                            1 Poland     
Tomasz Kie?basa                               1 Poland     
Tse-Kan Lin (???)                             1 Taiwan     
Uriel Gayosso Ruiz                            1 Mexico     
Vegard Seim Karstang                          1 Norway     
Vicente Albíter Alpízar                       1 Mexico     
Vidar Klungre                                 1 Norway     
Vincent Hartanto Utomo                        1 Indonesia  
Vincent Sheu                                  1 USA        
Vishal Harpalani                              1 USA        
Walker Welch                                  1 USA        
Wataru Hashimura (???)                        1 Japan      
Weimin Fang (???)                             1 China      
Weston Mizumoto                               1 USA        
Wonder Dygico                                 1 Philippines
Yan-Hung Lai (???)                            1 Taiwan     
Yinqin Li (???)                               1 China      
Yuhei Takagi (????)                           1 Japan      
Yui Tomita (????)                             1 Japan      
Yunsu Nam (???)                               1 Korea      
Zhou Yichen (???)                             1 China
By Country
Code:
USA                      134
Australia                 54
Poland                    43
China                     39
Canada                    35
Code:
Netherlands               27
France                    23
Germany                   18
Hungary                   16
Japan                     16
Spain                     15
Italy                     12
Sweden                    10
Thailand                  10
Indonesia                  9
Russia                     9
United Kingdom             9
Philippines                8
Brazil                     5
Denmark                    5
Korea                      5
Mexico                     5
Norway                     5
Chile                      3
Taiwan                     3
Ukraine                    2
Belgium                    1
Finland                    1
India                      1
Malaysia                   1
Portugal                   1
 
I found 525 sub2 singles done by 226 persons:
Code:
Feliks Zemdegs                               25 Australia  
Cameron Stollery                             23 Australia  
Rowe Hessler                                 23 USA        
Christopher Olson                            22 USA        
Micha? Pleskowicz                            18 Poland     
Mats Valk                                    14 Netherlands
Yinghao Wang (???)                           14 China      
Justin Jaffray                               13 Canada     
Erik Akkersdijk                              10 Netherlands
Code:
Cornelius Dieckmann                           9 Germany
Milán Baticz                                  9 Hungary    
Carlos Méndez García-Barroso                  7 Spain      
Andy Smith                                    6 USA        
Anthony Brooks                                6 USA        
Dan Dzoan                                     6 USA        
Nipat Charoenpholphant (??????? ????????????  6 Thailand   
Austin Reed                                   5 USA        
Bill Wang                                     5 Canada     
Edward Lin                                    5 USA        
John Brechon                                  5 USA        
Yu Nakajima (???)                             5 Japan      
Ben Whitmore                                  4 United King
Bence Barát                                   4 Hungary    
Forte Shinko                                  4 Canada     
Gabriel Dechichi Barbar                       4 Brazil     
Jayden McNeill                                4 Australia  
Louis Cormier                                 4 Canada     
Micha? Robaczyk                               4 Poland     
Simon Westlund                                4 Sweden     
Timothy Sun                                   4 USA        
Weixing Zhang (???)                           4 China      
Zhouheng Sun (???)                            4 China      
Antoine Piau                                  3 France     
Asia Konvittayayotin (?????? ????????????)    3 Thailand   
Eric Limeback                                 3 Canada     
Justin Adsuara                                3 USA        
Kevin Guillaumond                             3 France     
Lee Kyeong-Sub (???)                          3 Korea      
Michael Young                                 3 USA        
Philippe Virouleau                            3 France     
Tim Reynolds                                  3 USA        
Yumu Tabuchi (????)                           3 Japan      
Andrea Lo Sardo                               2 Italy      
Arifumi Fushimi (????)                        2 Japan      
Daniel Sheppard                               2 United King
Edouard Chambon                               2 France     
Erik Johnson                                  2 USA        
Henrik Buus Aagaard                           2 Denmark    
Ivan Vynnyk (???? ??????)                     2 Ukraine    
Jakub Cabaj                                   2 Poland     
Javier París                                  2 Spain      
Jorge Castillo Matas                          2 Spain      
Kevin Zhou                                    2 USA        
Kirk Nicklaus Manibuy                         2 Indonesia  
Lucas Garron                                  2 Germany    
?ukasz Cia?o?                                 2 Poland     
Marvin Llaneta                                2 Philippines
Mateusz Fydrych                               2 Poland     
Mitchell Lane                                 2 USA        
Niklas Spies                                  2 Germany    
Nikolay Evdokimov                             2 Russia     
Oskar Åsbrink                                 2 Sweden     
Patrick Jameson                               2 USA        
Péter Trombitás                               2 Hungary    
Qingbin Chen (???)                            2 China      
Ravi Fernando                                 2 USA        
Richard Jay S. Apagar                         2 Philippines
Rowan Kinneavy                                2 United King
Sébastien Auroux                              2 Germany    
Steven Turner                                 2 USA        
Thompson Clarke                               2 Canada     
Xiaofeng Zheng (???)                          2 China      
Yuxuan Wang (???)                             2 China      
Adrian Jorghy                                 1 Indonesia  
Aksel Stadel Borum                            1 Denmark    
Albert Stanula                                1 Poland     
Alberto Pérez de Rada Fiol                    1 Spain      
Alexey Oblaukhov                              1 Russia     
Alfrisa Diva Wandana                          1 Indonesia  
Alvin Febrianth                               1 Indonesia  
Anders Bogan                                  1 USA        
Andreas Pohl                                  1 Germany    
Andrés Alfaro                                 1 Chile      
Andrew Ricci                                  1 USA        
Andy Bridger                                  1 USA        
Antoine Cantin                                1 Canada     
Anton Bedrichenko                             1 Russia     
Anton Rostovikov                              1 Russia     
Arnaud van Galen                              1 Netherlands
Auguste Olivry                                1 France     
Bob Burton                                    1 USA        
Brock Hamann                                  1 Australia  
Cameron Almasi                                1 USA        
Carl Thiringer                                1 Sweden     
Chengbiao Liu (???)                           1 China      
Chia-Wei Lu (???)                             1 Taiwan     
Christian Kaserer                             1 Italy      
Daniel Adrian López de Andrade                1 Brazil     
Daniel Mazurek                                1 Poland     
Dániel Varga                                  1 Hungary    
Daniel Wu                                     1 USA        
Dario Roa Sánchez                             1 Spain      
David Gomes                                   1 USA        
David Shi                                     1 USA        
David Woner                                   1 USA        
Devin Corr-Robinett                           1 USA        
Didier Batista Ferreira                       1 Portugal   
Dmitry Kryuzban                               1 Russia     
Dmitry Zvyagintsev                            1 Russia     
Ernie Pulchny                                 1 USA        
Ethan Crislip                                 1 USA        
Fandy Ramadhan Ganefianto                     1 Indonesia  
Filip Miazek                                  1 Poland     
Filippo Brancaleoni                           1 Italy      
Frank Egan                                    1 USA        
Frédéric Meinnel                              1 France     
Gabriel Guay                                  1 Canada     
Gaël Servignat                                1 France     
Giovanni Tessari                              1 Italy      
Giulio Grammatica                             1 Italy      
Gonzalo Serrano                               1 Chile      
Guillain Potron                               1 France     
Gunnar Krig                                   1 Sweden     
Hampus Hansson                                1 Sweden     
Haowei Fan (???)                              1 China      
Hendry Cahyadi                                1 Indonesia  
Jacco Krijnen                                 1 Netherlands
Jack Johnston                                 1 USA        
Jacob Lange                                   1 Sweden     
Jai Gambhir                                   1 Canada     
Jakub Kipa                                    1 Poland     
James Creswell                                1 USA        
Jan Bentlage                                  1 Germany    
Javier Enrique Espinoza Grijalva              1 Mexico     
Javier Martínez Bautista                      1 Mexico     
Jedrick Remonde                               1 Philippines
Jessica Uribe                                 1 USA        
Jiawen Wu (???)                               1 China      
John Edison Ubaldo                            1 Philippines
John Tamanas                                  1 USA        
Jonathan Esteban Rivera Castillón             1 Mexico     
Jonathan Hamstad                              1 Norway     
Joon Cha                                      1 Korea      
José Garrido                                  1 Chile      
Joseph Dzaluk                                 1 USA        
Jules Desjardin                               1 France     
Jules Manalang                                1 USA        
Kai Han (??)                                  1 China      
Kai Liu (??)                                  1 China      
Kailong Li (???)                              1 China      
Kanneti Sae Han (????????? ???????)           1 France     
Kian Barry                                    1 USA        
Kit Clement                                   1 USA        
Kristian Muggerud                             1 Norway     
Laetitia Lemoine                              1 France     
Lars Van den broeck                           1 Belgium    
Lars Vennike Nielsson                         1 Denmark    
Loïc Petit                                    1 France     
Lorenzo Vigani Poli                           1 Italy      
Louis Sarthou                                 1 France     
?ukasz Cichecki                               1 Poland     
Maarten Smit                                  1 Netherlands
Maciej Dura?ski                               1 Poland     
Marcin Jakubowski                             1 Poland     
Marcin Zalewski                               1 Poland     
Mariusz Wi?niewski                            1 Poland     
Marwin-Peter Kurth                            1 Germany    
Matt DiPalma                                  1 USA        
Matteo Provasi                                1 Italy      
Maxim Novikov                                 1 Russia     
Michael Gottlieb                              1 USA        
Michael Nguyen                                1 USA        
Michael Perkins                               1 USA        
Micha? Matczak                                1 Poland     
Mike Kotch                                    1 USA        
Morten Arborg                                 1 Norway     
Muhammad Jihan Khalilurrahman                 1 Indonesia  
Neel Shah                                     1 Canada     
Nicola Giordani                               1 Italy      
Nicolò Simone                                 1 Italy      
Niko Ronkainen                                1 Finland    
Niño Francis Reyes                            1 Philippines
Oscar Roth Andersen                           1 Denmark    
Paolo Girotti                                 1 Italy      
Paolo Moriello                                1 Italy      
Pawe? W?oszek                                 1 Poland     
Phil Thomas                                   1 USA        
Piti Pichedpan (???? ???????????)             1 Thailand   
Przemys?aw Kaleta                             1 Poland     
Quentin Lefebvre                              1 France     
Rashdaleena Athiefa Abdul Rashid              1 Malaysia   
Rémi Esturoune                                1 France     
Robert Yau                                    1 United King
Rongjin Huang (???)                           1 China      
Sei Sugama (???)                              1 Japan      
Sergey Ryabko                                 1 Russia     
Sergi Sabat                                   1 Spain      
Shuto Ueno (????)                             1 Japan      
Sixuan Lou (???)                              1 China      
S?awomir Kapka                                1 Poland     
Sukesh Subaharan                              1 India      
Syuhei Omura (????)                           1 Japan      
Thomas Watiotienne                            1 France     
Tim Major                                     1 Australia  
Ting Sheng Bao Yang                           1 Spain      
Tomasz Kaczorowski                            1 Poland     
Tomasz Kie?basa                               1 Poland     
Tse-Kan Lin (???)                             1 Taiwan     
Uriel Gayosso Ruiz                            1 Mexico     
Vegard Seim Karstang                          1 Norway     
Vicente Albíter Alpízar                       1 Mexico     
Vidar Klungre                                 1 Norway     
Vincent Hartanto Utomo                        1 Indonesia  
Vincent Sheu                                  1 USA        
Vishal Harpalani                              1 USA        
Walker Welch                                  1 USA        
Wataru Hashimura (???)                        1 Japan      
Weimin Fang (???)                             1 China      
Weston Mizumoto                               1 USA        
Wonder Dygico                                 1 Philippines
Yan-Hung Lai (???)                            1 Taiwan     
Yinqin Li (???)                               1 China      
Yuhei Takagi (????)                           1 Japan      
Yui Tomita (????)                             1 Japan      
Yunsu Nam (???)                               1 Korea      
Zhou Yichen (???)                             1 China
By Country
Code:
USA                      134
Australia                 54
Poland                    43
China                     39
Canada                    35
Code:
Netherlands               27
France                    23
Germany                   18
Hungary                   16
Japan                     16
Spain                     15
Italy                     12
Sweden                    10
Thailand                  10
Indonesia                  9
Russia                     9
United Kingdom             9
Philippines                8
Brazil                     5
Denmark                    5
Korea                      5
Mexico                     5
Norway                     5
Chile                      3
Taiwan                     3
Ukraine                    2
Belgium                    1
Finland                    1
India                      1
Malaysia                   1
Portugal                   1

Wow, that's cool that I'm equal second. :D And that Australia is second in the countries, only to the US which is so much bigger.

I can't do queries or anything but I might as well add a hand generated list of most appearances in the 2x2 top 100 average results:

Code:
Rank  Name                        Country      Appearances
1     Christopher Olson           USA          15
1     Cameron Stollery            Australia    15
3     Feliks Zemdegs              Australia    10
4     Michal Pleskowicz           Poland       6
4     Justin Jaffray              Canada       6
4     Rowe Hessler                USA          6
7     Yinghao Wang                China        5
8     Carlos Méndez García-BarrosoSpain        4
8     Mats Valk                   Netherlands  4
8     Edward Lin                  USA          4
8     Bill Wang                   Canada       4
11    Zhou Yichen                 China        3
12    Gabriel Dechichi Barbar     Brazil       2
12    Qingbin Chen                China        2
12    Yu Nakajima                 Japan        2
12    	Lee Kyeong-Sub            Korea        2
12    Bence Barát                 Hungary      2
12    Cornelius Dieckmann         Netherlands  2
17    Dan Cohen                   USA          1
17    Ben Whitmore                UK           1
17    Milán Baticz                Hungary      1
17    John Brechon                USA          1
17    Andy Smith                  USA          1
17    Nipat Charoenpholphant      Thailand     1
17    Jayden McNeil               Australia    1
Code:
Rank  Country      Appearances
1     USA          28
2     Australia    26
3     Canada       10
3     China        10
5     Poland       6
6     Netherlands  6
7     Spain        4
8     Hungary      3
9     Brazil       2
9     Japan        2
9     Korea        2
12    UK           1
12    Thailand     1

Grr Australia is so close to #1. :/

It's amazing that 45% of the top 100 results are by just 3 people, and 54% are by just 2 countries.

Yeah, I basically did this because I knew me and Australia would be around the top. :p

Edit: Can someone please make a list of top 1 or top 3 podiums for every event? So like this but with all events.
 
Last edited:
It's amazing that 45% of the top 100 results are by just 3 people, and 54% are by just 2 countries.

Without even reading anything about the topic at hand, I am going to make a wild guess:
Australia and NL
Faz, Mats+Erik

(coincidentally they both have roughly the same amount of people living there)
 
I would like to see a list of competitors who could/would have witnessed the most world records.
(not taking into account that some comps are 2/3 days and someone may have only been to the comp for example on Sunday when the WR was set on Saturday)

I don't know if it's possible to exclude the person the set the WR, else Faz would probably be first place :)
 
I would like to see a list of competitors who could/would have witnessed the most world records.
(not taking into account that some comps are 2/3 days and someone may have only been to the comp for example on Sunday when the WR was set on Saturday)

I don't know if it's possible to exclude the person the set the WR, else Faz would probably be first place :)

Top 100 (and Faz is 63rd place):
(whoa, after Lars the next six are from the Netherlands)
Code:
238 Lars Vandenbergh
230 Ton Dennenbroek
210 Ron van Bruchem
164 Arnaud van Galen
158 Jaap Scherphuis
154 Erik Akkersdijk
148 Joël van Noort
134 Bob Burton
130 Clément Gallet
130 Chris Hardwick
128 István Kocza
124 Anders Larsson
116 Frédérick Badie
114 Shotaro Makisumi (?????)
114 Dan Harris
110 Milán Baticz
108 Stefan Pochmann
106 Edouard Chambon
106 Shelley Chang
104 Lars Petrus
102 Leyan Lo
102 Frank Morris
102 Maria Oey
100 Jasmine Lee
 96 Adam Zamora
 92 Jean-Louis Mathieu
 92 Rama Temmink
 92 Olivér Nagy
 90 Gilles van den Peereboom
 88 Gunnar Krig
 86 Guus Razoux Schultz
 86 Peter Jansen
 84 Kåre Krig
 84 Tyson Mao (???)
 82 Joey Gouly
 80 Rune Wesström
 80 Zbigniew Zborowski
 78 Arjan Bosse
 76 Tomasz Zolnowski
 76 Henrik Buus Aagaard
 76 François Courtès
 74 Olivér Perge
 74 Hans van der Zijden
 74 Dror Vomberg
 74 Gábor Szabó
 72 Oliver Wolff
 72 Ian Winokur
 70 Tim Reynolds
 70 Doug Li
 70 Máté Horváth
 68 Bertalan Bodor
 68 Ryan Patricio
 68 Koen Heltzel
 68 Alexander Ooms
 66 Keith Sauer
 66 Bence Barát
 66 Tommy Gustavsson
 64 Mátyás Kuti
 64 Masayuki Akimoto (????)
 64 Mats Valk
 62 Peter Still
 62 Brent Morgan
 60 Feliks Zemdegs
 60 Sébastien Auroux
 60 Michael Grimsley
 58 Jason Baum
 58 Markus Pirzer
 58 Pawel Wloszek
 58 Richard Patterson
 56 Dave Campbell
 56 Róbert Örkényi
 56 Sinpei Araki (????)
 56 Dan Dzoan
 54 Tim McMahon
 54 Sanio Kasumovic
 54 Tim Major
 54 Cameron Stollery
 54 Thibaut Jacquinot
 54 Zane Carney
 54 Wiktoria Zborowska
 52 Kirstine Buus Aagaard
 52 Fumiki Koseki (????)
 52 Ernesto Fernández Regueira
 52 Yumu Tabuchi (????)
 52 Dániel Varga
 52 Michel Hop
 52 Andy Camann
 52 Takao Hashimoto (????)
 52 Chris Krueger
 52 Braden Helmer
 52 Breandan Vallance
 50 Clancy Cochran
 50 Michal Halczuk
 50 Oscar Roth Andersen
 50 Jon Morris
 50 Joe Allen
 50 Lukasz Cialon
 50 Hanneke Rijks
 48 Michal Robaczyk
 48 Brúnó Bereczki

SELECT sum(wrs) witnessed, personName FROM

(SELECT * FROM (SELECT competitionId, sum(if(regionalSingleRecord='WR',1,0)+if(regionalSingleRecord='WR',1,0)) wrs FROM Results GROUP BY competitionId) tmp WHERE wrs) a,
(SELECT distinct personName, personId, competitionId FROM Results) b

WHERE a.competitionId=b.competitionId
GROUP BY personId
ORDER BY witnessed desc
LIMIT 100
 
Could someone make a ranking for the total of official solves ever done (by persons)? (we have that just by year in the WCA statistics)
Thanks! :)

EDIT:
Top 100 (and Faz is 63rd place):
(whoa, after Lars the next six are from the Netherlands)
Code:
238 Lars Vandenbergh
230 Ton Dennenbroek
210 Ron van Bruchem
164 Arnaud van Galen
158 Jaap Scherphuis
154 Erik Akkersdijk
148 Joël van Noort
134 Bob Burton
130 Clément Gallet
130 Chris Hardwick
128 István Kocza
124 Anders Larsson
116 Frédérick Badie
114 Shotaro Makisumi (?????)
114 Dan Harris
110 Milán Baticz
108 Stefan Pochmann
106 Edouard Chambon
106 Shelley Chang
104 Lars Petrus
102 Leyan Lo
102 Frank Morris
102 Maria Oey
100 Jasmine Lee
 96 Adam Zamora
 92 Jean-Louis Mathieu
 92 Rama Temmink
 92 Olivér Nagy
 90 Gilles van den Peereboom
 88 Gunnar Krig
 86 Guus Razoux Schultz
 86 Peter Jansen
 84 Kåre Krig
 84 Tyson Mao (???)
 82 Joey Gouly
 80 Rune Wesström
 80 Zbigniew Zborowski
 78 Arjan Bosse
 76 Tomasz Zolnowski
 76 Henrik Buus Aagaard
 76 François Courtès
 74 Olivér Perge
 74 Hans van der Zijden
 74 Dror Vomberg
 74 Gábor Szabó
 72 Oliver Wolff
 72 Ian Winokur
 70 Tim Reynolds
 70 Doug Li
 70 Máté Horváth
 68 Bertalan Bodor
 68 Ryan Patricio
 68 Koen Heltzel
 68 Alexander Ooms
 66 Keith Sauer
 66 Bence Barát
 66 Tommy Gustavsson
 64 Mátyás Kuti
 64 Masayuki Akimoto (????)
 64 Mats Valk
 62 Peter Still
 62 Brent Morgan
 60 Feliks Zemdegs
 60 Sébastien Auroux
 60 Michael Grimsley
 58 Jason Baum
 58 Markus Pirzer
 58 Pawel Wloszek
 58 Richard Patterson
 56 Dave Campbell
 56 Róbert Örkényi
 56 Sinpei Araki (????)
 56 Dan Dzoan
 54 Tim McMahon
 54 Sanio Kasumovic
 54 Tim Major
 54 Cameron Stollery
 54 Thibaut Jacquinot
 54 Zane Carney
 54 Wiktoria Zborowska
 52 Kirstine Buus Aagaard
 52 Fumiki Koseki (????)
 52 Ernesto Fernández Regueira
 52 Yumu Tabuchi (????)
 52 Dániel Varga
 52 Michel Hop
 52 Andy Camann
 52 Takao Hashimoto (????)
 52 Chris Krueger
 52 Braden Helmer
 52 Breandan Vallance
 50 Clancy Cochran
 50 Michal Halczuk
 50 Oscar Roth Andersen
 50 Jon Morris
 50 Joe Allen
 50 Lukasz Cialon
 50 Hanneke Rijks
 48 Michal Robaczyk
 48 Brúnó Bereczki

SELECT sum(wrs) witnessed, personName FROM

(SELECT * FROM (SELECT competitionId, sum(if(regionalSingleRecord='WR',1,0)+if(regionalSingleRecord='WR',1,0)) wrs FROM Results GROUP BY competitionId) tmp WHERE wrs) a,
(SELECT distinct personName, personId, competitionId FROM Results) b

WHERE a.competitionId=b.competitionId
GROUP BY personId
ORDER BY witnessed desc
LIMIT 100
Top-7: a belgian ans 6 dutch people. We know were we have to travel to see WR :) (well, we already knew, but this is quite impressive with this stat)
 
Last edited:
Back
Top