Odd WCA stats/ Stats request Thread

Carrot · Jul 20, 2012

ben1996123 said:
933,120 on pyraminx, 1,283,918,464,548,864 on clock.

Since when did we not scramble tips at competition for pyraminx?

EDIT: If we are judging by number of positions (according to the wca scrambling system):
Magic: 1
Master Magic: 1
2x2x2: 3,674,160
Pyraminx: 75,582,720

vcuber13 · Jul 20, 2012

in my opinion the starting positions for the tips is the same as the pins on a clock, idk if ben accounted for them.

ps your no longer 11th

Stefan · Jul 20, 2012

vcuber13 said:
idk if ben accounted for them.

https://www.google.de/#q=12^14

ben1996123 · Jul 22, 2012

Who has the lowest average amount of days between competitions?

Sebastien · Jul 22, 2012

I bet this will be TMOY, I should be ranked pretty high as well though. I also wouldn't wonder to see Zoé in the Top 5.

Stefan · Jul 22, 2012

ben1996123 said:
Who has the lowest average amount of days between competitions?

Sebastien said:
I bet this will be TMOY, I should be ranked pretty high as well though. I also wouldn't wonder to see Zoé in the Top 5.

Days "between" would be a little more difficult, I hope you're content with totalSpan/(competitions-1). The top 100 for that:

Code:

+-----------+----------+--------+-------------+--------------------------------------------+
| firstDate | lastDate | number | avgDistance | personName                                 |
+-----------+----------+--------+-------------+--------------------------------------------+
|  20120429 | 20120504 |      2 |        5.00 | Junpei Inomata (????)                      |
|  20120520 | 20120526 |      2 |        6.00 | Andi Malik Burhannudin                     |
|  20111211 | 20111217 |      2 |        6.00 | Flavio Di Giorgio                          |
|  20090314 | 20090321 |      2 |        7.00 | Alex Kelly                                 |
|  20120520 | 20120527 |      2 |        7.00 | Jing Liao (??)                             |
|  20091114 | 20091121 |      2 |        7.00 | Maria Gloria Deranis                       |
|  20120616 | 20120623 |      2 |        7.00 | Jared Benson                               |
|  20111224 | 20120107 |      3 |        7.00 | Sung Hyun Park (???)                       |
|  20110226 | 20110305 |      2 |        7.00 | Miguel Sanhueza                            |
|  20120519 | 20120526 |      2 |        7.00 | Dane De Pasquale                           |
|  20120520 | 20120527 |      2 |        7.00 | Guoyang Zhou (???)                         |
|  20100502 | 20100509 |      2 |        7.00 | Xueyan Wang (???)                          |
|  20100904 | 20100911 |      2 |        7.00 | Frederik Stühring                          |
|  20120127 | 20120203 |      2 |        7.00 | Velidi Venkata Jagan Mohana Murali Krishna |
|  20120602 | 20120616 |      3 |        7.00 | Zainal Abidin                              |
|  20120520 | 20120527 |      2 |        7.00 | Haoran Xu 2 (???)                          |
|  20111224 | 20111231 |      2 |        7.00 | Young Joon Kim (???)                       |
|  20110226 | 20110305 |      2 |        7.00 | Claudio Merino Beseler                     |
|  20100131 | 20100207 |      2 |        7.00 | Peng Wu (??)                               |
|  20120616 | 20120623 |      2 |        7.00 | Hayden Hasenberg                           |
|  20111030 | 20111106 |      2 |        7.00 | Tianmi Dong (???)                          |
|  20080322 | 20080329 |      2 |        7.00 | Andy Kang                                  |
|  20111224 | 20120115 |      4 |        7.33 | SeungWook Eun (???)                        |
|  20100724 | 20100801 |      2 |        8.00 | Zhaoyi Zhou (???)                          |
|  20120713 | 20120721 |      2 |        8.00 | Barry Bower                                |
|  20120713 | 20120721 |      2 |        8.00 | Caleb Stairs                               |
|  20120713 | 20120721 |      2 |        8.00 | Isaiah Stairs                              |
|  20090507 | 20090516 |      2 |        9.00 | Christian Reyes                            |
|  20090507 | 20090516 |      2 |        9.00 | Bianca Lantajo                             |
|  20120506 | 20120526 |      3 |       10.00 | Daiki Hashimoto                            |
|  20120404 | 20120415 |      2 |       11.00 | Hanyu Fang (???)                           |
|  20120602 | 20120624 |      3 |       11.00 | Rizal Wahyu Kurniawan                      |
|  20111224 | 20120115 |      3 |       11.00 | Ui-Min Park (???)                          |
|  20111224 | 20120115 |      3 |       11.00 | Ju-Seung Baek (???)                        |
|  20120404 | 20120415 |      2 |       11.00 | Anyu Zhang (???)                           |
|  20111224 | 20120115 |      3 |       11.00 | Doo Hyun Kwon (???)                        |
|  20120325 | 20120407 |      2 |       13.00 | Huaidong Zhou (???)                        |
|  20091107 | 20091121 |      2 |       14.00 | John Crowden                               |
|  20120602 | 20120616 |      2 |       14.00 | Kevin Ferguson                             |
|  20111224 | 20120107 |      2 |       14.00 | Jun Hyun Song (???)                        |
|  20120218 | 20120303 |      2 |       14.00 | Joey Karlin                                |
|  20120218 | 20120303 |      2 |       14.00 | Andrew Malling                             |
|  20081108 | 20081122 |      2 |       14.00 | Daniel Li                                  |
|  20081115 | 20081129 |      2 |       14.00 | Martijn Jansen                             |
|  20120602 | 20120616 |      2 |       14.00 | Young Kim                                  |
|  20090822 | 20090905 |      2 |       14.00 | Sheng-Yung Guo                             |
|  20120519 | 20120602 |      2 |       14.00 | Gabriel Gratton                            |
|  20090822 | 20090905 |      2 |       14.00 | Shiue Ling Fu (???)                        |
|  20090822 | 20090905 |      2 |       14.00 | Chin-Hao Kao                               |
|  20081108 | 20081122 |      2 |       14.00 | Rob Smith                                  |
|  20100509 | 20100523 |      2 |       14.00 | Shuo Wang (??)                             |
|  20081115 | 20081129 |      2 |       14.00 | Jules Gimbrère                             |
|  20081115 | 20081129 |      2 |       14.00 | Bart Eefting                               |
|  20111224 | 20120107 |      2 |       14.00 | Lee Jae Young (???)                        |
|  20110514 | 20110528 |      2 |       14.00 | Erika Santana                              |
|  20120602 | 20120616 |      2 |       14.00 | Dae San Kim                                |
|  20081108 | 20081122 |      2 |       14.00 | Colby Oleksy                               |
|  20100130 | 20100213 |      2 |       14.00 | Junien Labrousse                           |
|  20081115 | 20081129 |      2 |       14.00 | Regi Vermeij                               |
|  20120602 | 20120616 |      2 |       14.00 | Alexander Hall                             |
|  20120519 | 20120602 |      2 |       14.00 | Nicholas Chan                              |
|  20111224 | 20120107 |      2 |       14.00 | Junhee Lee                                 |
|  20110212 | 20110227 |      2 |       15.00 | Chet Lin                                   |
|  20120310 | 20120325 |      2 |       15.00 | Bixuan Li (???)                            |
|  20120310 | 20120325 |      2 |       15.00 | Jie Jin (??)                               |
|  20120310 | 20120325 |      2 |       15.00 | Zichao Ye (???)                            |
|  20110212 | 20110227 |      2 |       15.00 | Max Hsiao                                  |
|  20110212 | 20110227 |      2 |       15.00 | Shane Kent                                 |
|  20120310 | 20120325 |      2 |       15.00 | Juehui Zhang (???)                         |
|  20120310 | 20120325 |      2 |       15.00 | Miao He (??)                               |
|  20120310 | 20120325 |      2 |       15.00 | Hongyu Zhou (???)                          |
|  20101219 | 20110104 |      2 |       16.00 | Budi Setiawan Paramata                     |
|  20080411 | 20120720 |     95 |       16.61 | François Courtès                           |
|  20090307 | 20090530 |      6 |       16.80 | Yaroslav Egorov                            |
|  20110319 | 20110423 |      3 |       17.50 | Brian McCauley                             |
|  20090718 | 20090822 |      3 |       17.50 | Tam Hou Meng (???)                         |
|  20091016 | 20091121 |      3 |       18.00 | Martin Gröller                             |
|  20120421 | 20120616 |      4 |       18.67 | Monicka Manni                              |
|  20080727 | 20080815 |      2 |       19.00 | Yi Min-Gyu                                 |
|  20080727 | 20080815 |      2 |       19.00 | Sim Kwan-Yong                              |
|  20090418 | 20090507 |      2 |       19.00 | Justin Sinel                               |
|  20100206 | 20100424 |      5 |       19.25 | Kristoffer Lauderbaugh                     |
|  20120226 | 20120317 |      2 |       20.00 | Robbie Garden                              |
|  20120226 | 20120317 |      2 |       20.00 | Jenny Liu                                  |
|  20120324 | 20120504 |      3 |       20.50 | Takuya Emori (????)                        |
|  20080329 | 20080419 |      2 |       21.00 | Richard Davison                            |
|  20071103 | 20071124 |      2 |       21.00 | Celeste Compion                            |
|  20090207 | 20090321 |      3 |       21.00 | Max Nachamkin                              |
|  20091031 | 20091121 |      2 |       21.00 | Christian Gröller                          |
|  20100206 | 20100227 |      2 |       21.00 | Jared Collins                              |
|  20110409 | 20110430 |      2 |       21.00 | Calvin Chau                                |
|  20120414 | 20120505 |      2 |       21.00 | Leandro Noguti Magiori                     |
|  20111015 | 20111105 |      2 |       21.00 | Brandon Shutt                              |
|  20111015 | 20111105 |      2 |       21.00 | Jacob Cafolla                              |
|  20111029 | 20111119 |      2 |       21.00 | Nico Viaene                                |
|  20110409 | 20110430 |      2 |       21.00 | Christoph Tegtmeier                        |
|  20100724 | 20100814 |      2 |       21.00 | Jian Wang (??)                             |
|  20110416 | 20110507 |      2 |       21.00 | Christopher Sheedy                         |
|  20070505 | 20070526 |      2 |       21.00 | Trey Westrich                              |
|  20120414 | 20120505 |      2 |       21.00 | Bruno Menoni                               |
+-----------+----------+--------+-------------+--------------------------------------------+

SELECT firstDate, lastDate, number, round(datediff(lastDate,firstDate)/(number-1),2) avgDistance, personName FROM

(SELECT
  min(year*10000+month*100+day) firstDate,
  max(year*10000+month*100+day) lastDate,
  count(distinct competitionId) number,
  personName
FROM
  Results, Competitions
WHERE
  Competitions.id = competitionId
GROUP BY
  personId) tmp

WHERE number >= 2
ORDER BY avgDistance

And considering only people with at least 10 competitions:

Code:

+-----------+----------+--------+-------------+----------------------------------------+
| firstDate | lastDate | number | avgDistance | personName                             |
+-----------+----------+--------+-------------+----------------------------------------+
|  20080411 | 20120720 |     95 |       16.61 | François Courtès                       |
|  20080419 | 20120713 |     70 |       22.41 | Sébastien Auroux                       |
|  20060506 | 20120713 |     96 |       23.79 | Arnaud van Galen                       |
|  20071005 | 20120623 |     70 |       24.97 | Takao Hashimoto (????)                 |
|  20100806 | 20120616 |     25 |       28.33 | Phil Yu                                |
|  20090221 | 20120623 |     43 |       29.00 | Fabian Auroux                          |
|  20080502 | 20100724 |     29 |       29.04 | Haiyan Zhuang (???)                    |
|  20051029 | 20120713 |     85 |       29.15 | Erik Akkersdijk                        |
|  20090314 | 20120623 |     41 |       29.93 | Berit Brüster                          |
|  20100227 | 20120713 |     29 |       30.96 | Zoé de Moffarts                        |
|  20100116 | 20120713 |     30 |       31.34 | Jan Bentlage                           |
|  20110305 | 20120519 |     15 |       31.50 | Josh Flagg                             |
|  20070224 | 20120713 |     63 |       31.71 | Maria Oey                              |
|  20040416 | 20120720 |     96 |       31.76 | Clément Gallet                         |
|  20090912 | 20100703 |     10 |       32.67 | Sachi Schuricht                        |
|  20090912 | 20120623 |     32 |       32.74 | Niklas Spies                           |
|  20081220 | 20100529 |     17 |       32.81 | Keanu László Vestil                    |
|  20080823 | 20120331 |     41 |       32.90 | Bence Barát                            |
|  20061118 | 20120616 |     62 |       33.39 | Jaclyn Sawler                          |
|  20100501 | 20120616 |     24 |       33.78 | Mike Kotch                             |
|  20030823 | 20120616 |     95 |       34.26 | Bob Burton                             |
|  20110521 | 20120707 |     13 |       34.42 | Ryohei Yoshioka (????)                 |
|  20081101 | 20120602 |     39 |       34.45 | Justin Jaffray                         |
|  20070422 | 20120526 |     55 |       34.46 | Kian Barry                             |
|  20080719 | 20120721 |     43 |       34.83 | Hanneke Rijks                          |
|  20090425 | 20111022 |     27 |       35.00 | Alexander Springhorn                   |
|  20101218 | 20120526 |     16 |       35.00 | Zach Goldman                           |
|  20070331 | 20120429 |     54 |       35.02 | Rowe Hessler                           |
|  20051210 | 20120721 |     69 |       35.51 | Tim Reynolds                           |
|  20100522 | 20120713 |     23 |       35.59 | Geert Bicler                           |
|  20060415 | 20120616 |     64 |       35.78 | Devin Corr-Robinett                    |
|  20090425 | 20120623 |     33 |       36.09 | Nora Christ                            |
|  20090816 | 20120527 |     29 |       36.25 | Ming Zheng (??)                        |
|  20060415 | 20120526 |     62 |       36.61 | Chris Krueger                          |
|  20080621 | 20120415 |     39 |       36.68 | Filippo Brancaleoni                    |
|  20101031 | 20120609 |     17 |       36.69 | Michael Volpe Mayerle                  |
|  20071124 | 20120519 |     45 |       37.23 | Mats Valk                              |
|  20070616 | 20120616 |     50 |       37.29 | Dan Cohen                              |
|  20070728 | 20120708 |     49 |       37.65 | Nobuaki Suga (???)                     |
|  20030823 | 20120713 |     87 |       37.76 | Ton Dennenbroek                        |
|  20071005 | 20120714 |     47 |       37.91 | Joey Gouly                             |
|  20091121 | 20120414 |     24 |       38.04 | Tobias Droste                          |
|  20090221 | 20120519 |     32 |       38.16 | Donglei Li (???)                       |
|  20071005 | 20120414 |     44 |       38.44 | Olivér Perge                           |
|  20030823 | 20120721 |     85 |       38.75 | Ron van Bruchem                        |
|  20100806 | 20120526 |     18 |       38.76 | Andrew Ricci                           |
|  20100613 | 20111105 |     14 |       39.23 | Ryan Reese                             |
|  20060305 | 20120708 |     60 |       39.27 | Sinpei Araki (????)                    |
|  20071222 | 20120630 |     43 |       39.33 | Gaël Dusser                            |
|  20040403 | 20120506 |     76 |       39.40 | Shelley Chang                          |
|  20110319 | 20120526 |     12 |       39.45 | Daniel Selzer                          |
|  20100206 | 20120623 |     23 |       39.45 | John Brechon                           |
|  20030823 | 20120713 |     83 |       39.60 | Lars Vandenbergh                       |
|  20090919 | 20120609 |     26 |       39.76 | Paolo Moriello                         |
|  20110430 | 20120602 |     11 |       39.90 | Natán Riggenbach                       |
|  20080906 | 20120420 |     34 |       40.06 | Kanneti Sae Han (????????? ???????)    |
|  20100116 | 20120225 |     20 |       40.53 | Daniel Becker                          |
|  20090221 | 20120623 |     31 |       40.60 | Maximilian Neitzel                     |
|  20110212 | 20120506 |     12 |       40.82 | Courtney Louie                         |
|  20090221 | 20120527 |     30 |       41.07 | Fangyuan Chang (???)                   |
|  20081025 | 20120721 |     34 |       41.36 | Brúnó Bereczki                         |
|  20090621 | 20120713 |     28 |       41.41 | Tomoaki Okayama (????)                 |
|  20050416 | 20120519 |     63 |       41.77 | Jeremy Fleischman                      |
|  20080607 | 20120721 |     37 |       41.81 | Dániel Varga                           |
|  20110416 | 20120720 |     12 |       41.91 | Fabien Lebailly                        |
|  20100501 | 20120526 |     19 |       42.00 | Ernie Pulchny                          |
|  20100724 | 20120708 |     18 |       42.06 | Kotaro Terada (?????)                  |
|  20090425 | 20120721 |     29 |       42.25 | Sanio Kasumovic                        |
|  20061014 | 20120303 |     47 |       42.76 | Rama Temmink                           |
|  20070901 | 20120512 |     41 |       42.88 | Laetitia Lemoine                       |
|  20051105 | 20120602 |     57 |       42.88 | Dave Campbell                          |
|  20101222 | 20120114 |     10 |       43.11 | Muhammad Arsyad Maulana                |
|  20110219 | 20120721 |     13 |       43.17 | Corey Sakowski                         |
|  20100130 | 20120616 |     21 |       43.40 | Ethan Crislip                          |
|  20040403 | 20120211 |     67 |       43.48 | Adam Zamora                            |
|  20081025 | 20120526 |     31 |       43.63 | Piotr Micha? Padlewski                 |
|  20100417 | 20110813 |     12 |       43.91 | Shauly Ramin                           |
|  20091219 | 20120519 |     21 |       44.10 | Quentin Lefebvre                       |
|  20090816 | 20120527 |     24 |       44.13 | Weifeng Cheng (???)                    |
|  20101205 | 20120407 |     12 |       44.45 | Huan Yuan (??)                         |
|  20090207 | 20120526 |     28 |       44.59 | Frank Severinsen                       |
|  20090809 | 20111210 |     20 |       44.89 | Yan Xuan (??)                          |
|  20091009 | 20120623 |     23 |       44.91 | Björn Korbanka                         |
|  20051119 | 20120713 |     55 |       44.96 | István Kocza                           |
|  20080712 | 20120506 |     32 |       44.97 | Edward Lin                             |
|  20070422 | 20111203 |     38 |       45.57 | John Tamanas                           |
|  20060114 | 20111203 |     48 |       45.72 | Dan Dzoan                              |
|  20100612 | 20120623 |     17 |       46.38 | Philipp Weyer                          |
|  20090307 | 20100806 |     12 |       47.00 | Greg French                            |
|  20090830 | 20120701 |     23 |       47.09 | Ardianto Satriawan                     |
|  20060429 | 20120526 |     48 |       47.21 | Bruce Norskog                          |
|  20091121 | 20120623 |     21 |       47.25 | Laura Ohrndorf                         |
|  20081102 | 20100102 |     10 |       47.33 | Liping Shang (???)                     |
|  20100911 | 20120707 |     15 |       47.50 | Helmut Heilig                          |
|  20071222 | 20120407 |     34 |       47.52 | Antoine Perdereau                      |
|  20071103 | 20120407 |     35 |       47.56 | Gavin Nelson                           |
|  20071110 | 20120414 |     35 |       47.56 | Breandan Vallance                      |
|  20110108 | 20120428 |     11 |       47.60 | Natthaphat Mahtani (??????? ?? ??????) |
|  20090830 | 20120714 |     23 |       47.68 | Riadi Arsandi                          |
|  20110114 | 20120623 |     12 |       47.82 | Kai Retzmann                           |
+-----------+----------+--------+-------------+----------------------------------------+

And the top 100 highest distance:

Code:

+-----------+----------+--------+-------------+--------------------------------+
| firstDate | lastDate | number | avgDistance | personName                     |
+-----------+----------+--------+-------------+--------------------------------+
|  19820605 | 20120519 |     26 |      437.64 | Guus Razoux Schultz            |
|  19820605 | 20120128 |     28 |      401.07 | Lars Petrus                    |
|  20040807 | 20120218 |     10 |      305.67 | Eivind Fonn                    |
|  20050115 | 20111203 |     10 |      279.22 | Yu Yang Hsieh                  |
|  20060122 | 20120115 |     10 |      242.67 | SeungWoon Lee (???)            |
|  20040424 | 20101001 |     11 |      235.10 | Oliver Wolff                   |
|  20041010 | 20120414 |     13 |      228.58 | Sean Connolly                  |
|  20030823 | 20120526 |     15 |      228.50 | Ian Winokur                    |
|  20050903 | 20110410 |     10 |      227.22 | Hideaki Tomoyori (????)        |
|  20051210 | 20120225 |     11 |      226.80 | Bob Burton Sr.                 |
|  20030823 | 20101016 |     13 |      217.58 | Peter Jansen                   |
|  20051203 | 20120505 |     12 |      213.18 | Alexandre Toledo Guillén       |
|  20060305 | 20110326 |     10 |      205.22 | Yuuki Ishikawa (????)          |
|  20060114 | 20110807 |     11 |      203.10 | James Ouyang                   |
|  20051119 | 20111119 |     12 |      199.18 | Eszter Szabó                   |
|  20041023 | 20100903 |     12 |      194.64 | Angelo Federico                |
|  20070331 | 20120707 |     11 |      192.50 | Kou Oobatake (???)             |
|  20030823 | 20120707 |     18 |      190.65 | Masayuki Akimoto (????)        |
|  20030823 | 20111126 |     17 |      188.56 | Jasmine Lee                    |
|  20050903 | 20101023 |     11 |      187.60 | Kazuya Kawamoto (????)         |
|  20050903 | 20101023 |     11 |      187.60 | Takeshi Akuzawa (?????)        |
|  20070414 | 20120519 |     11 |      186.20 | Peter Hung                     |
|  20050710 | 20110730 |     13 |      184.25 | Keisuke Shimura (????)         |
|  20060421 | 20110507 |     11 |      184.20 | Tobias Daneels                 |
|  20041211 | 20120630 |     16 |      183.87 | Alan Chang                     |
|  20031011 | 20091017 |     13 |      183.17 | Koen Heltzel                   |
|  20051016 | 20111014 |     13 |      182.42 | Peter Still                    |
|  20070812 | 20120115 |     10 |      179.67 | Yi Seung-Woo (???)             |
|  20070616 | 20120407 |     11 |      175.70 | Isaac Wappes                   |
|  20070714 | 20120414 |     11 |      173.60 | Christopher Ness               |
|  20070819 | 20120429 |     11 |      171.50 | Tatsuya Tsukamoto (????)       |
|  20060916 | 20111105 |     12 |      170.55 | Stefan ?apicki                 |
|  20080505 | 20120708 |     10 |      169.44 | Shuto Ueno (????)              |
|  20070812 | 20111014 |     10 |      169.33 | Kiyoshi Takahashi              |
|  20050813 | 20110812 |     14 |      168.46 | Casey Pernsteiner              |
|  20051105 | 20120407 |     15 |      167.50 | Chris Pelley                   |
|  20050903 | 20110819 |     14 |      167.38 | Hiroshi Ishino (????)          |
|  20071110 | 20111217 |     10 |      166.44 | Alex Mason                     |
|  20071215 | 20111225 |     10 |      163.44 | Xiaowei Wang (???)             |
|  20070819 | 20120707 |     12 |      162.18 | Takuma Akutsu (?????)          |
|  20040124 | 20090523 |     13 |      162.17 | Frank Chang                    |
|  20080614 | 20120610 |     10 |      161.89 | Vincent Yim                    |
|  20030823 | 20100911 |     17 |      161.00 | Rune Wesström                  |
|  20071208 | 20120505 |     11 |      161.00 | Willian Fidêncio               |
|  20060610 | 20110917 |     13 |      160.42 | Örjan Johansson                |
|  20071215 | 20111126 |     10 |      160.22 | Mattias Claesson               |
|  20080223 | 20120707 |     11 |      159.60 | Tomás Hernández Pastor         |
|  20070428 | 20110903 |     11 |      158.90 | Péter Róka                     |
|  20061118 | 20120714 |     14 |      158.85 | Thom Barlow                    |
|  20070818 | 20111210 |     11 |      157.50 | Otto von Hellens               |
|  20071005 | 20120623 |     12 |      156.64 | Michael Layher                 |
|  20050129 | 20120506 |     18 |      156.12 | Ravi Fernando                  |
|  20080502 | 20120218 |     10 |      154.11 | Weinan Li (???)                |
|  20060415 | 20100130 |     10 |      154.00 | Kevin Jorgensen                |
|  20050917 | 20101009 |     13 |      154.00 | Lauren Hanrahan                |
|  20080217 | 20120428 |     11 |      153.20 | Jarle Kvåle                    |
|  20070714 | 20110918 |     11 |      152.70 | Dániel Fodor                   |
|  20070819 | 20120324 |     12 |      152.64 | Masahiro Daidai (????)         |
|  20050423 | 20091121 |     12 |      152.09 | Thomas Bossmann                |
|  20050813 | 20120407 |     17 |      151.81 | Daniel Hayes                   |
|  20041113 | 20120505 |     19 |      151.67 | Pedro Luis Muñoz Yañez         |
|  20071222 | 20110916 |     10 |      151.56 | Simon Bourigault               |
|  20060311 | 20110730 |     14 |      151.31 | Andrew Kang                    |
|  20060421 | 20110903 |     14 |      150.85 | Róbert Örkényi                 |
|  20051203 | 20120707 |     17 |      150.50 | Carlos Angosto Hernández       |
|  20050422 | 20120420 |     18 |      150.29 | Antoine Simon-Chautemps        |
|  20080405 | 20111216 |     10 |      150.00 | Jorge Morata Carrasco          |
|  20070505 | 20120408 |     13 |      150.00 | Raku Watari (???)              |
|  20061118 | 20101218 |     11 |      149.10 | Stanley Wong                   |
|  20050903 | 20100724 |     13 |      148.75 | Kaho Idekawa (????)            |
|  20050903 | 20100724 |     13 |      148.75 | Satoshi Idekawa (????)         |
|  20041211 | 20111113 |     18 |      148.71 | Toby Mao (???)                 |
|  20030823 | 20120630 |     23 |      147.00 | Zbigniew Zborowski             |
|  20071208 | 20120505 |     12 |      146.36 | Carlos Alberto de Alcântara Jr |
|  20080919 | 20120428 |     10 |      146.33 | Stéphane Escaich               |
|  20040416 | 20120420 |     21 |      146.30 | François Sechet                |
|  20060527 | 20101016 |     12 |      145.73 | Joshua Satterfield             |
|  20070923 | 20120211 |     12 |      145.64 | Yueh-Lin Tsai (???)            |
|  20060305 | 20100724 |     12 |      145.64 | Rei Idekawa (???)              |
|  20080120 | 20120115 |     11 |      145.60 | Yunsu Nam (???)                |
|  20040807 | 20111008 |     19 |      145.44 | Hans van der Zijden            |
|  20060318 | 20110917 |     15 |      143.50 | Erik Johansson                 |
|  20070825 | 20111217 |     12 |      143.18 | James Benedict Cañares         |
|  20070825 | 20120506 |     13 |      143.00 | Steven Xu                      |
|  20071005 | 20110903 |     11 |      142.90 | Gábor Róka                     |
|  20050710 | 20090112 |     10 |      142.44 | Syoji Takamatsu (????)         |
|  20050903 | 20120408 |     18 |      141.71 | Junya Tomita (????)            |
|  20071001 | 20120527 |     13 |      141.67 | Yi Wei (??)                    |
|  20090112 | 20120707 |     10 |      141.33 | Haruo Aoki (????)              |
|  20081214 | 20120527 |     10 |      140.00 | Shuai Liu (??)                 |
|  20080426 | 20120225 |     11 |      140.00 | Felix Kung                     |
|  20070825 | 20120331 |     13 |      140.00 | Uriel Gayosso Ruiz             |
|  20040416 | 20120420 |     22 |      139.33 | Gilles Roux                    |
|  20080727 | 20120520 |     11 |      139.30 | Chio Wai Cheng (???)           |
|  20060305 | 20120408 |     17 |      139.13 | Mina Tomita (????)             |
|  20070526 | 20111217 |     13 |      138.83 | Filippo Bertolotti             |
|  20070414 | 20111105 |     13 |      138.83 | Brendan Blackwell              |
|  20060730 | 20120408 |     16 |      138.60 | Yui Tomita (????)              |
|  20030823 | 20100605 |     19 |      137.67 | Dan Harris                     |
|  20060804 | 20111105 |     15 |      137.07 | Tristan Wright                 |
+-----------+----------+--------+-------------+--------------------------------+

And highest, not requiring at least 10 comps:

Code:

+-----------+----------+--------+-------------+-------------------------+
| firstDate | lastDate | number | avgDistance | personName              |
+-----------+----------+--------+-------------+-------------------------+
|  19820605 | 20070331 |      4 |     3021.67 | Jessica Fridrich        |
|  20041023 | 20110924 |      2 |     2527.00 | Pierre Vandendriessche  |
|  20041127 | 20110917 |      2 |     2485.00 | Micael Hellberg         |
|  20050710 | 20120218 |      2 |     2414.00 | Satoru Noda (???)       |
|  20060421 | 20110903 |      2 |     1961.00 | Zsolt Vincze            |
|  20041113 | 20091205 |      2 |     1848.00 | Álvaro Ibánez Blas      |
|  20040416 | 20090410 |      2 |     1820.00 | Jean Pecassou           |
|  20030823 | 20080719 |      2 |     1792.00 | Jim Mittan              |
|  20070113 | 20110827 |      2 |     1687.00 | Chris Thiessen          |
|  20070519 | 20110522 |      2 |     1464.00 | Zebedee Weetaluktuk     |
|  20080217 | 20120218 |      2 |     1462.00 | Emile Rusten            |
|  20080216 | 20120127 |      2 |     1441.00 | Abhimanyu Singh Udawat  |
|  20080705 | 20120513 |      2 |     1408.00 | Ser Loisse Mortel       |
|  20030823 | 20070519 |      2 |     1365.00 | Carvo Grant             |
|  20081025 | 20120630 |      2 |     1344.00 | Kamil Fus               |
|  20080705 | 20120218 |      2 |     1323.00 | Patrick Garcin          |
|  20060804 | 20100227 |      2 |     1303.00 | Justin Chen             |
|  20080802 | 20120218 |      2 |     1295.00 | Takehiro Sato (????)    |
|  20081207 | 20120602 |      2 |     1273.00 | Ki Yeun Kim             |
|  20030823 | 20100724 |      3 |     1263.50 | Michiel van der Blonk   |
|  20080216 | 20110709 |      2 |     1239.00 | Deep Parikh             |
|  20051105 | 20090307 |      2 |     1218.00 | Nicole Morgante         |
|  20040807 | 20071124 |      2 |     1204.00 | Klaas Steenhuis         |
|  20081220 | 20120331 |      2 |     1197.00 | Patrick Buelink         |
|  20090328 | 20120707 |      2 |     1197.00 | Ryo Shimizu (???)       |
|  20040403 | 20101009 |      3 |     1190.00 | Evan Gates              |
|  20090117 | 20120414 |      2 |     1183.00 | João Lucas Lima Moraes  |
|  20080705 | 20110829 |      2 |     1150.00 | Keith Beja              |
|  20081025 | 20111210 |      2 |     1141.00 | Donato Marro            |
|  20090307 | 20120421 |      2 |     1141.00 | Michael Dijamco         |
|  20090502 | 20120513 |      2 |     1107.00 | Yaofei Zhao (???)       |
|  20080419 | 20110430 |      2 |     1106.00 | Gunnar Krupp            |
|  20051203 | 20111216 |      3 |     1102.00 | Alfonso Perez Arnal     |
|  20070526 | 20100529 |      2 |     1099.00 | Tony Heaton             |
|  20080322 | 20110319 |      2 |     1092.00 | Mathew Tan              |
|  20071005 | 20101001 |      2 |     1092.00 | Péter Sándor            |
|  20080217 | 20110212 |      2 |     1091.00 | Halvor Lund             |
|  20090328 | 20120303 |      2 |     1071.00 | Matthew Fontana         |
|  20030823 | 20120505 |      4 |     1059.33 | David Barr              |
|  20081025 | 20110903 |      2 |     1043.00 | Tamás Kozaróczy         |
|  20081025 | 20110903 |      2 |     1043.00 | Márton Attila Kiss      |
|  20090725 | 20120602 |      2 |     1043.00 | Evan Cornuelle          |
|  20030823 | 20060610 |      2 |     1022.00 | David Wesley            |
|  20090502 | 20120218 |      2 |     1022.00 | Chaonan Cheng (???)     |
|  20060916 | 20090627 |      2 |     1015.00 | Bartosz Bielecki        |
|  20080517 | 20110219 |      2 |     1008.00 | Dan Pham                |
|  20090912 | 20120610 |      2 |     1002.00 | Grayson Warren          |
|  20090816 | 20120513 |      2 |     1001.00 | Fei Lan (??)            |
|  20090816 | 20120513 |      2 |     1001.00 | Xiaoling Yang (???)     |
|  20071215 | 20100828 |      2 |      987.00 | Xiujun Wang (???)       |
|  20070616 | 20100227 |      2 |      987.00 | Phil Senour             |
|  20080405 | 20101217 |      2 |      986.00 | Rubén Vadillo Lebrero   |
|  20090418 | 20111217 |      2 |      973.00 | Vicente Lorenzo Cabahug |
|  20090502 | 20111225 |      2 |      967.00 | Ying Ma (??)            |
|  20080419 | 20101207 |      2 |      962.00 | Harries Andaya          |
|  20061118 | 20090628 |      2 |      953.00 | Jing Zhang (??)         |
|  20090502 | 20111210 |      2 |      952.00 | Yu Du (??)              |
|  20041016 | 20091219 |      3 |      945.00 | Roger Lee               |
|  20060527 | 20081220 |      2 |      938.00 | Jonathan Sosulski       |
|  20080127 | 20100821 |      2 |      937.00 | Henry Chen Loc          |
|  20060723 | 20090208 |      2 |      931.00 | Yu-Hsien Lee (???)      |
|  20090919 | 20120407 |      2 |      931.00 | David Musante           |
|  20070505 | 20120526 |      3 |      924.00 | Tim Wong                |
|  20050129 | 20100206 |      3 |      917.00 | Albert Kroschel         |
|  20060804 | 20090118 |      2 |      898.00 | Richard Truong          |
|  20060916 | 20090221 |      2 |      889.00 | Erwin Joks              |
|  20090207 | 20110618 |      2 |      861.00 | Claes Hedin             |
|  20071117 | 20100327 |      2 |      861.00 | Ryota Ohmae (????)      |
|  20051210 | 20080419 |      2 |      861.00 | Edward Zhu              |
|  20090321 | 20110730 |      2 |      861.00 | Siavash Ahmadi          |
|  20051210 | 20080419 |      2 |      861.00 | Timothy Zhu             |
|  20090531 | 20111008 |      2 |      860.00 | Zing-Han Lei (???)      |
|  20100130 | 20120520 |      2 |      841.00 | Yosef Hendrawan         |
|  20071005 | 20120512 |      3 |      840.50 | Nándor Fekete           |
|  20091114 | 20120303 |      2 |      840.00 | Jacqueline Korpershoek  |
|  20081011 | 20110129 |      2 |      840.00 | Emil Stenderup          |
|  20060923 | 20110426 |      3 |      838.00 | Yoav Zaidenberg         |
|  20100227 | 20120602 |      2 |      826.00 | Ayush Saini             |
|  20100227 | 20120602 |      2 |      826.00 | Vivek Saini             |
|  20090628 | 20111001 |      2 |      825.00 | Xie Xie (??)            |
|  20040124 | 20080719 |      3 |      819.00 | Mark Sullivan           |
|  20040807 | 20061028 |      2 |      812.00 | Jan de Geus             |
|  20100130 | 20120421 |      2 |      812.00 | Tomas Macadam           |
|  20080705 | 20100918 |      2 |      805.00 | Emmanuel Maligalig      |
|  20030823 | 20051105 |      2 |      805.00 | Eric Johanson           |
|  20030823 | 20051105 |      2 |      805.00 | Corey Duford            |
|  20080621 | 20100904 |      2 |      805.00 | Max Anderson            |
|  20030823 | 20051105 |      2 |      805.00 | Jeff Goetz              |
|  20071013 | 20091212 |      2 |      791.00 | Rayner Chotkan          |
|  20091220 | 20120218 |      2 |      790.00 | Mickey Chow (??)        |
|  20091001 | 20111127 |      2 |      787.00 | Nanbin Zhang (???)      |
|  20090809 | 20111003 |      2 |      785.00 | Chenkai Shao (???)      |
|  20100227 | 20120421 |      2 |      784.00 | Richard Lin             |
|  20041016 | 20110319 |      4 |      781.67 | Kyle Allaire            |
|  20070825 | 20111203 |      3 |      780.50 | Matthew Liu             |
|  20030823 | 20071124 |      3 |      777.00 | Paul Attar              |
|  20030823 | 20071124 |      3 |      777.00 | Michal Falmyk           |
|  20030823 | 20120211 |      5 |      773.50 | Justin Eastman          |
|  20070113 | 20110402 |      3 |      770.00 | Mikael Vanhala          |
|  20090118 | 20110227 |      2 |      770.00 | Derek O'Connor          |
+-----------+----------+--------+-------------+-------------------------+

Sebastien · Jul 22, 2012

awesome, thank you

So I actually guessed very well. It is nice that I can always refer to Francois when people claim I go to too many competitions

Stefan · Jul 22, 2012

People who competed once every calendar year (and at least five times):

Code:

+-------+-------+-----------+----------+-------------------------------------------------------------------------------------------------------+
| comps | years | firstYear | lastYear | cuber                                                                                                 |
+-------+-------+-----------+----------+-------------------------------------------------------------------------------------------------------+
|     7 |     7 |      2006 |     2012 | [url="http://www.worldcubeassociation.org/results/p.php?i=2006ZAHR01"]Martin Zahradník[/url]          |
|     7 |     7 |      2005 |     2011 | [url="http://www.worldcubeassociation.org/results/p.php?i=2005MARI01"]Jose Maria Moreno Pueyo[/url]   |
|     6 |     6 |      2006 |     2011 | [url="http://www.worldcubeassociation.org/results/p.php?i=2006MORE01"]Beatriz Moreno Navalpotro[/url] |
|     6 |     6 |      2003 |     2008 | [url="http://www.worldcubeassociation.org/results/p.php?i=2003ZBOR01"]Wiktoria Zborowska[/url]        |
|     5 |     5 |      2008 |     2012 | [url="http://www.worldcubeassociation.org/results/p.php?i=2008BANS01"]Pulkit Bansal[/url]             |
|     5 |     5 |      2008 |     2012 | [url="http://www.worldcubeassociation.org/results/p.php?i=2008LIZH01"]Zhile Li (???)[/url]            |
|     5 |     5 |      2006 |     2010 | [url="http://www.worldcubeassociation.org/results/p.php?i=2006SHII01"]Nobutaka Shiina (????)[/url]    |
|     5 |     5 |      2006 |     2010 | [url="http://www.worldcubeassociation.org/results/p.php?i=2006WATA01"]Eiichi Watanabe (????)[/url]    |
|     5 |     5 |      2006 |     2010 | [url="http://www.worldcubeassociation.org/results/p.php?i=2006JAIW01"]Wen-Jia Jai (???)[/url]         |
|     5 |     5 |      2005 |     2009 | [url="http://www.worldcubeassociation.org/results/p.php?i=2005MILE01"]Tadeás Miler[/url]              |
|     5 |     5 |      2005 |     2009 | [url="http://www.worldcubeassociation.org/results/p.php?i=2005PLOM01"]Duncan Plomp[/url]              |
+-------+-------+-----------+----------+-------------------------------------------------------------------------------------------------------+

[noparse]SELECT * FROM
(SELECT count(distinct competitionId) comps, count(distinct year) years, min(year) firstYear, max(year) lastYear, concat('[url="http://www.worldcubeassociation.org/results/p.php?i=',personId,'"]',personName,'[/url]') cuber
FROM Results, Competitions
WHERE Competitions.id = competitionId
GROUP BY personId) tmp
WHERE comps = years AND lastYear-firstYear=years-1 AND comps>=5
ORDER BY years desc, firstYear desc[/noparse]

hcfong · Jul 22, 2012

Stefan said:

And considering only people with at least 10 competitions:

Code:

+-----------+----------+--------+-------------+----------------------------------------+
| firstDate | lastDate | number | avgDistance | personName                             |
+-----------+----------+--------+-------------+----------------------------------------+
|  20080411 | 20120720 |     95 |       16.61 | François Courtès                       |
|  20080419 | 20120713 |     70 |       22.41 | Sébastien Auroux                       |
|  20060506 | 20120713 |     96 |       23.79 | Arnaud van Galen                       |
|  20071005 | 20120623 |     70 |       24.97 | Takao Hashimoto (????)                 |
|  20100806 | 20120616 |     25 |       28.33 | Phil Yu                                |
|  20090221 | 20120623 |     43 |       29.00 | Fabian Auroux                          |
|  20080502 | 20100724 |     29 |       29.04 | Haiyan Zhuang (???)                    |
|  20051029 | 20120713 |     85 |       29.15 | Erik Akkersdijk                        |
|  20090314 | 20120623 |     41 |       29.93 | Berit Brüster                          |
|  20100227 | 20120713 |     29 |       30.96 | Zoé de Moffarts                        |
|  20100116 | 20120713 |     30 |       31.34 | Jan Bentlage                           |
|  20110305 | 20120519 |     15 |       31.50 | Josh Flagg                             |
|  20070224 | 20120713 |     63 |       31.71 | Maria Oey                              |
|  20040416 | 20120720 |     96 |       31.76 | Clément Gallet                         |
|  20090912 | 20100703 |     10 |       32.67 | Sachi Schuricht                        |
|  20090912 | 20120623 |     32 |       32.74 | Niklas Spies                           |
|  20081220 | 20100529 |     17 |       32.81 | Keanu László Vestil                    |
|  20080823 | 20120331 |     41 |       32.90 | Bence Barát                            |
|  20061118 | 20120616 |     62 |       33.39 | Jaclyn Sawler                          |
|  20100501 | 20120616 |     24 |       33.78 | Mike Kotch                             |
|  20030823 | 20120616 |     95 |       34.26 | Bob Burton                             |
|  20110521 | 20120707 |     13 |       34.42 | Ryohei Yoshioka (????)                 |
|  20081101 | 20120602 |     39 |       34.45 | Justin Jaffray                         |
|  20070422 | 20120526 |     55 |       34.46 | Kian Barry                             |
|  20080719 | 20120721 |     43 |       34.83 | Hanneke Rijks                          |
|  20090425 | 20111022 |     27 |       35.00 | Alexander Springhorn                   |
|  20101218 | 20120526 |     16 |       35.00 | Zach Goldman                           |
|  20070331 | 20120429 |     54 |       35.02 | Rowe Hessler                           |
|  20051210 | 20120721 |     69 |       35.51 | Tim Reynolds                           |
|  20100522 | 20120713 |     23 |       35.59 | Geert Bicler                           |
|  20060415 | 20120616 |     64 |       35.78 | Devin Corr-Robinett                    |
|  20090425 | 20120623 |     33 |       36.09 | Nora Christ                            |
|  20090816 | 20120527 |     29 |       36.25 | Ming Zheng (??)                        |
|  20060415 | 20120526 |     62 |       36.61 | Chris Krueger                          |
|  20080621 | 20120415 |     39 |       36.68 | Filippo Brancaleoni                    |
|  20101031 | 20120609 |     17 |       36.69 | Michael Volpe Mayerle                  |
|  20071124 | 20120519 |     45 |       37.23 | Mats Valk                              |
|  20070616 | 20120616 |     50 |       37.29 | Dan Cohen                              |
|  20070728 | 20120708 |     49 |       37.65 | Nobuaki Suga (???)                     |
|  20030823 | 20120713 |     87 |       37.76 | Ton Dennenbroek                        |
|  20071005 | 20120714 |     47 |       37.91 | Joey Gouly                             |
|  20091121 | 20120414 |     24 |       38.04 | Tobias Droste                          |
|  20090221 | 20120519 |     32 |       38.16 | Donglei Li (???)                       |
|  20071005 | 20120414 |     44 |       38.44 | Olivér Perge                           |
|  20030823 | 20120721 |     85 |       38.75 | Ron van Bruchem                        |
|  20100806 | 20120526 |     18 |       38.76 | Andrew Ricci                           |
|  20100613 | 20111105 |     14 |       39.23 | Ryan Reese                             |
|  20060305 | 20120708 |     60 |       39.27 | Sinpei Araki (????)                    |
|  20071222 | 20120630 |     43 |       39.33 | Gaël Dusser                            |
|  20040403 | 20120506 |     76 |       39.40 | Shelley Chang                          |
|  20110319 | 20120526 |     12 |       39.45 | Daniel Selzer                          |
|  20100206 | 20120623 |     23 |       39.45 | John Brechon                           |
|  20030823 | 20120713 |     83 |       39.60 | Lars Vandenbergh                       |
|  20090919 | 20120609 |     26 |       39.76 | Paolo Moriello                         |
|  20110430 | 20120602 |     11 |       39.90 | Natán Riggenbach                       |
|  20080906 | 20120420 |     34 |       40.06 | Kanneti Sae Han (????????? ???????)    |
|  20100116 | 20120225 |     20 |       40.53 | Daniel Becker                          |
|  20090221 | 20120623 |     31 |       40.60 | Maximilian Neitzel                     |
|  20110212 | 20120506 |     12 |       40.82 | Courtney Louie                         |
|  20090221 | 20120527 |     30 |       41.07 | Fangyuan Chang (???)                   |
|  20081025 | 20120721 |     34 |       41.36 | Brúnó Bereczki                         |
|  20090621 | 20120713 |     28 |       41.41 | Tomoaki Okayama (????)                 |
|  20050416 | 20120519 |     63 |       41.77 | Jeremy Fleischman                      |
|  20080607 | 20120721 |     37 |       41.81 | Dániel Varga                           |
|  20110416 | 20120720 |     12 |       41.91 | Fabien Lebailly                        |
|  20100501 | 20120526 |     19 |       42.00 | Ernie Pulchny                          |
|  20100724 | 20120708 |     18 |       42.06 | Kotaro Terada (?????)                  |
|  20090425 | 20120721 |     29 |       42.25 | Sanio Kasumovic                        |
|  20061014 | 20120303 |     47 |       42.76 | Rama Temmink                           |
|  20070901 | 20120512 |     41 |       42.88 | Laetitia Lemoine                       |
|  20051105 | 20120602 |     57 |       42.88 | Dave Campbell                          |
|  20101222 | 20120114 |     10 |       43.11 | Muhammad Arsyad Maulana                |
|  20110219 | 20120721 |     13 |       43.17 | Corey Sakowski                         |
|  20100130 | 20120616 |     21 |       43.40 | Ethan Crislip                          |
|  20040403 | 20120211 |     67 |       43.48 | Adam Zamora                            |
|  20081025 | 20120526 |     31 |       43.63 | Piotr Micha? Padlewski                 |
|  20100417 | 20110813 |     12 |       43.91 | Shauly Ramin                           |
|  20091219 | 20120519 |     21 |       44.10 | Quentin Lefebvre                       |
|  20090816 | 20120527 |     24 |       44.13 | Weifeng Cheng (???)                    |
|  20101205 | 20120407 |     12 |       44.45 | Huan Yuan (??)                         |
|  20090207 | 20120526 |     28 |       44.59 | Frank Severinsen                       |
|  20090809 | 20111210 |     20 |       44.89 | Yan Xuan (??)                          |
|  20091009 | 20120623 |     23 |       44.91 | Björn Korbanka                         |
|  20051119 | 20120713 |     55 |       44.96 | István Kocza                           |
|  20080712 | 20120506 |     32 |       44.97 | Edward Lin                             |
|  20070422 | 20111203 |     38 |       45.57 | John Tamanas                           |
|  20060114 | 20111203 |     48 |       45.72 | Dan Dzoan                              |
|  20100612 | 20120623 |     17 |       46.38 | Philipp Weyer                          |
|  20090307 | 20100806 |     12 |       47.00 | Greg French                            |
|  20090830 | 20120701 |     23 |       47.09 | Ardianto Satriawan                     |
|  20060429 | 20120526 |     48 |       47.21 | Bruce Norskog                          |
|  20091121 | 20120623 |     21 |       47.25 | Laura Ohrndorf                         |
|  20081102 | 20100102 |     10 |       47.33 | Liping Shang (???)                     |
|  20100911 | 20120707 |     15 |       47.50 | Helmut Heilig                          |
|  20071222 | 20120407 |     34 |       47.52 | Antoine Perdereau                      |
|  20071103 | 20120407 |     35 |       47.56 | Gavin Nelson                           |
|  20071110 | 20120414 |     35 |       47.56 | Breandan Vallance                      |
|  20110108 | 20120428 |     11 |       47.60 | Natthaphat Mahtani (??????? ?? ??????) |
|  20090830 | 20120714 |     23 |       47.68 | Riadi Arsandi                          |
|  20110114 | 20120623 |     12 |       47.82 | Kai Retzmann                           |
+-----------+----------+--------+-------------+----------------------------------------+

[/code]

Oh blast! Just one competition short to be on this list:-( I think I could've ended up quite high

Stefan · Jul 22, 2012

hcfong said:
Oh blast! Just one competition short to be on this list:-( I think I could've ended up quite high

Shortest average break for people with exactly N competitions (from N=9 to N=2):

Code:

+-----------+----------+--------+-------------+--------------------------+
| firstDate | lastDate | number | avgDistance | personName               |
+-----------+----------+--------+-------------+--------------------------+
|  20111029 | 20120714 |      9 |       32.38 | Hwee-Chong Fong          |
|  20110715 | 20120623 |      8 |       49.14 | Giana Guelfi         |
|  20111119 | 20120526 |      7 |       31.50 | Sou Oobatake (???)    |
|  20090307 | 20090530 |      6 |       16.80 | Yaroslav Egorov         |
|  20100206 | 20100424 |      5 |       19.25 | Kristoffer Lauderbaugh          |
|  20111224 | 20120115 |      4 |        7.33 | SeungWook Eun (???) |
|  20111224 | 20120107 |      3 |        7.00 | Sung Hyun Park (???)  |
|  20120602 | 20120616 |      3 |        7.00 | Zainal Abidin         |
|  20120429 | 20120504 |      2 |        5.00 | Junpei Inomata (????)  |
+-----------+----------+--------+-------------+--------------------------+

=> François is only beaten by people with four or fewer comps (and of those, SeungWook Eun stands out, four competitions in four weekends in a row)

hcfong · Jul 22, 2012

Stefan said:

Shortest average break for people with exactly N competitions (from N=9 to N=2):

Code:

+-----------+----------+--------+-------------+--------------------------+
| firstDate | lastDate | number | avgDistance | personName               |
+-----------+----------+--------+-------------+--------------------------+
|  20111029 | 20120714 |      9 |       32.38 | Hwee-Chong Fong          |
|  20110715 | 20120623 |      8 |       49.14 | Giana Guelfi         |
|  20111119 | 20120526 |      7 |       31.50 | Sou Oobatake (???)    |
|  20090307 | 20090530 |      6 |       16.80 | Yaroslav Egorov         |
|  20100206 | 20100424 |      5 |       19.25 | Kristoffer Lauderbaugh          |
|  20111224 | 20120115 |      4 |        7.33 | SeungWook Eun (???) |
|  20111224 | 20120107 |      3 |        7.00 | Sung Hyun Park (???)  |
|  20120602 | 20120616 |      3 |        7.00 | Zainal Abidin         |
|  20120429 | 20120504 |      2 |        5.00 | Junpei Inomata (????)  |
+-----------+----------+--------+-------------+--------------------------+

=> François is only beaten by people with four or fewer comps (and of those, SeungWook Eun stands out, four competitions in four weekends in a row)

Cool!

If it hasn't been done yet, what about a list of longest run of attending competitions in consecutive weekends?

antoineccantin · Jul 22, 2012

The venue with the most competitions?

Bob · Jul 23, 2012

Edit: I can't read.

jonlin · Jul 25, 2012

http://worldcubeassociation.org/res...esults&competitionId=BigCubesSummer2009#444bf
WTF w/ Chris Hardwick's 4BLD times

Cubenovice · Jul 25, 2012

jonlin said:
http://worldcubeassociation.org/res...esults&competitionId=BigCubesSummer2009#444bf
WTF w/ Chris Hardwick's 4BLD times

? What's odd about them?

edit: ah...

Awesome consistency

Evan Liu · Jul 25, 2012

I've successfully calculated the full lists for the sum of single and average ranks (done with Excel).

I omitted the magics since they will be removed starting next year. Also, the rankings do not reflect the changes following the SESC/Santos 2012 results which were posted earlier today. Those should be the only discrepancies you see between my lists and the top 10 available on the WCA site.
If anyone finds others, please do point them out, and I'll try to fix them.

http://dl.dropbox.com/u/16017198/Final_Single.txt
http://dl.dropbox.com/u/16017198/Final_Avg.txt

Edit: Added ranking numbers down the left side for easier viewing (not taking into account ties, though).

Sebastien · Jul 25, 2012

hcfong said:
Cool!

If it hasn't been done yet, what about a list of longest run of attending competitions in consecutive weekends?

I think Tim is just setting this up with 9 in a row.

hcfong · Jul 25, 2012

Sebastien said:
I think Tim is just setting this up with 9 in a row.

as far as I can see on his profile, his current run is only 5, starting with Aachen up to Raleigh.

lachose · Jul 25, 2012

He'll do Jersey Shore, US Nats, Vancouver and St. Joseph's College
So that will make 9 competitions in a row

Stefan · Jul 25, 2012

Evan Liu said:
http://dl.dropbox.com/u/16017198/Final_Avg.txt

Nakaji!!! Actually he's #1 on the WCA list as well (i.e., including magics). A few days ago he was #5, but he eliminated his weaknesses:

Code:

        Sum   333  444  555  222  OH   FT   meg  pyr  sq1  clo  666  777  mag  mma
before  1091   12   7    2    59  144  33   15   37   181  45   4    5    479  68    
after   420    12   7    2    35   69  35   15   15   43   45   4    6    64   68

Odd WCA stats/ Stats request Thread

Veteran

Veteran

Legend

Banned

Premium Member

Legend

Premium Member

Legend

Veteran

Legend

Veteran

Legend

Premium Member

Veteran

Forever Slow

Veteran

Premium Member

Veteran

Regular

Legend

Similar threads