• Welcome to the Speedsolving.com, home of the web's largest puzzle community!
    You are currently viewing our forum as a guest which gives you limited access to join discussions and access our other features.

    Registration is fast, simple and absolutely free so please, join our community of 40,000+ people from around the world today!

    If you are already a member, simply login to hide this message and begin participating in the community!

Ron

Member
Joined
Sep 9, 2006
Messages
337
Location
Amsterdam
WCA
2003BRUC01
2007CHAN03 - WTF is that last 3x3 average? This guy is the only person out there with a CR worse than a WR in an event. I'm almost thinking someone else's results got put on his profile.
2011KOEB01 - a 5:38:00.00 5x5x5 time! Surely that's an error.
2011LIJI04 - a 1:07:51.00 3x3x3 time, same as above.
2012FAZD01 - 36:26.00 3x3x3 time, same as above.
2010DOLP01 - I dunno what it is, but I think this guy's name might be fake
2009BINK01 - three 10.00s in one Pyraminx round :O
I fixed these. I could not find 2010DOLP01 anymore and 2009BINK01 had 3 10.00s, I remember that happening.
 

Ron

Member
Joined
Sep 9, 2006
Messages
337
Location
Amsterdam
WCA
2003BRUC01
Btw, Michael, thanks for notifying us. Please email me your query, then I can add it to my annual check process for the WCA database.
Regarding 2010DOLP01, Baiqiang found out that 3 persons were registered members under a nickname, so he took action.
 

qqwref

Member
Joined
Dec 18, 2007
Messages
7,834
Location
a <script> tag near you
WCA
2006GOTT01
YouTube
Visit Channel
Btw, Michael, thanks for notifying us. Please email me your query, then I can add it to my annual check process for the WCA database.
Regarding 2010DOLP01, Baiqiang found out that 3 persons were registered members under a nickname, so he took action.
I'd be happy to email it to you, but it's in a language called q, not in SQL. So it probably won't be very useful for you.

Would it be possibel to make a list with the people who broke more WRs and CRs (separate lists) in any event?
Like, Feliks has about 40 WRs, counting 3x3, OH, 4x4, etc.
Most historical WRs (all people with 5+):
Code:
personId       x    personName
2009ZEMD01    45    Feliks Zemdegs
2005AKKE01    33    Erik Akkersdijk
2003MAKI01    21    Shotaro Makisumi
2003POCH01    21    Stefan Pochmann
2006HALC01    19    Michał Halczuk
2006KUTI01    17    Mátyás Kuti
2003HARD01    16    Chris Hardwick
2007COHE01    16    Dan Cohen
2003VAND01    13    Lars Vandenbergh
2005VANH01    12    Anssi Vanhala
2009WANG13    11    Yuxuan Wang
2004KRIG01    10    Gunnar Krig
2004PATR01    10    Ryan Patricio
2006OKAY01    9     Yohei Oka
2003SCHE01    8     Jaap Scherphuis
2007NAKA03    8     Yu Nakajima
2008SEPP01    7     Ville Seppänen
2009HAYS01    7     Kevin Hays
2003MORR01    6     Frank Morris
2004CHAM01    6     Edouard Chambon
2006OOKU01    6     Takayuki Ookusa
2006TABU02    6     Yumu Tabuchi
2007ENDR01    6     Marcell Endrey
2008ZHUA01    6     Haiyan Zhuang
2003BURT01    5     Bob Burton
2005LUCZ01    5     Grzegorz Łuczyna
2006PRUS01    5     Grzegorz Prusak
2007HORV01    5     Máté Horváth
2008ANDE02    5     Oscar Roth Andersen
2008BARA01    5     Bence Barát
2008BODO01    5     Bálint Bodor
2008LIBI01    5     Bingliang Li
2010CHEN20    5     Lin Chen

query:
processName:{rtrim ((x?"(")-count x)_x:string x}
`x xdesc select sum[regionalSingleRecord=`WR]+sum regionalAverageRecord=`WR, processName last personName by personId from results

Most historical CRs (all people with 15+):
Code:
personId        x    personName
2009ZEMD01    130    Feliks Zemdegs
2007COMP01    126    Emile Compion
2007COHE01     83    Dan Cohen
2007GUIM01     79    Pedro Santos Guimarães
2005AKKE01     54    Erik Akkersdijk
2006HALC01     37    Michał Halczuk
2003MAKI01     36    Shotaro Makisumi
2009BARB01     36    Gabriel Dechichi Barbar
2009BEAR01     34    Dene Beardsley
2003LEEJ01     33    Jasmine Lee
2008NUNE01     33    Gabriel Eduardo Núñez Serna
2003HARD01     30    Chris Hardwick
2007HESS01     30    Rowe Hessler
2007LIJO01     30    Joshua Li
2007NAKA03     27    Yu Nakajima
2003POCH01     24    Stefan Pochmann
2006TABU02     24    Yumu Tabuchi
2003VAND01     23    Lars Vandenbergh
2003MORR01     21    Frank Morris
2004PATR01     20    Ryan Patricio
2007CINO01     20    Rafael Werneck Cinoto
2006KUTI01     19    Mátyás Kuti
2006OOKU01     18    Takayuki Ookusa
2003BURT01     17    Bob Burton
2006OKAY01     17    Yohei Oka
2004KRIG01     16    Gunnar Krig
2005VANH01     16    Anssi Vanhala
2009MACA01     16    Matias Macaya

query:
`x xdesc select sum[not regionalSingleRecord in ``NR]+sum not regionalAverageRecord in ``NR, processName last personName by personId from results

Most historical NRs (all people with 70+):
Code:
personId        x    personName
2006BUUS01    213    Henrik Buus Aagaard
2005AKKE01    179    Erik Akkersdijk
2005BATI01    135    Milán Baticz
2009ZEMD01    135    Feliks Zemdegs
2007COMP01    132    Emile Compion
2010MOND01    124    Pablo Nicolás Oshiro Mondoñedo
2004KRIG01    117    Gunnar Krig
2003VAND01    113    Lars Vandenbergh
2008WEST02    110    Simon Westlund
2009MAGN02    105    Hilmar Magnusson
2007GUIM01    100    Pedro Santos Guimarães
2009BEAR01     95    Dene Beardsley
2008BARA01     93    Bence Barát
2007COHE01     87    Dan Cohen
2003POCH01     84    Stefan Pochmann
2009BALT02     83    Leandro Baltazar
2006ORLA01     81    Bernett Orlando
2008HANK01     78    Kanneti Sae Han
2006GARR01     77    Lucas Garron
2008SEAR01     77    Anthony Brooks
2008NUNE01     76    Gabriel Eduardo Núñez Serna
2009BAUM01     74    Conor Baumann
2005VANH01     73    Anssi Vanhala
2006ZAHR01     73    Martin Zahradník
2003HARR01     72    Dan Harris
2007VALL01     72    Breandan Vallance
2007HUBE01     70    Stefan Huber

query:
`x xdesc select sum[regionalSingleRecord<>`]+sum regionalAverageRecord<>`, procesSName last personName by personId from results
 

qqwref

Member
Joined
Dec 18, 2007
Messages
7,834
Location
a <script> tag near you
WCA
2006GOTT01
YouTube
Visit Channel
I'm not going to try "per day", but here's per competition, just the top 10 or so each this time. Note that CRs/NRs include the higher-up levels too.

Code:
WRs:
personId       x comps    personName        ratio
2009ZEMD01    45    14    Feliks Zemdegs    3.214286
2006KUTI01    17    11    Mátyás Kuti       1.545455
2003WESL01     3     2    David Wesley      1.5
2005FUNG01     4     3    Michael Fung      1.333333
1982THAI01     1     1    Minh Thai         1
2003BELL01     1     1    Andy Bellenir     1
2003BOND01     1     1    Jess Bonde        1
2004GODF01     1     1    Mike Godfrey      1
2005ARNO01     1     1    Will Arnold       1
2005HAYA01     4     4    Yuki Hayashi      1
2009HEDI01     3     3    Claes Hedin       1

CRs:
personId        x comps    personName                    ratio
2007LIJO01     30     2    Joshua Li                     15
2009ZEMD01    130    14    Feliks Zemdegs                 9.285714
2007COMP01    126    25    Emile Compion                  5.04
2008NUNE01     33     7    Gabriel Eduardo Núñez Serna    4.714286
2007GUIM01     79    17    Pedro Santos Guimarães         4.647059
2009BARB01     37    11    Gabriel Dechichi Barbar        3.363636
2003WESL01      6     2    David Wesley                   3
2011HAUP01      7     3    Jacobus Philip Haupt           2.333333
2004NOWI01      4     2    Jarosław Nowicki               2
2007AMAN01      4     2    Etienne Amany                  2
2009KOBA04     10     5    Rodrigo Kenji Asato Kobayashi  2

NRs:
personId        x comps    personName                     ratio
2012DOOF02     16     1    Zeid Doofesh                   16
2007LIJO01     30     2    Joshua Li                      15
2011KUDA01     58     4    Nurym Kudaibergen              14.5
2009KIMA01     64     5    Anatoly Kim                    12.8
2010MOND01    124    10    Pablo Nicolás Oshiro Mondoñedo 12.4
2011VAIT01     35     3    Lukas Vaitkevicius             11.66667
2008NUNE01     76     7    Gabriel Eduardo Núñez Serna    10.85714
2012ZIVK01     21     2    Milutin Živković               10.5
2006ZAHR01     73     7    Martin Zahradník               10.42857
2010VYNN01     72     7    Ivan Vynnyk                    10.28571
2011GUCU01     29     3    Can Gücüyener                   9.666667
2009ZEMD01    135    14    Feliks Zemdegs                  9.642857
2009MAGN02    105    11    Hilmar Magnusson                9.545455
2010BOWE01     19     2    Blake Bowers                    9.5
2010DRVE01     19     2    Alex Drvenkar                   9.5

queries:
processName:{rtrim ((x?"(")-count x)_x:string x}
`ratio xdesc update ratio:x%comps from
 select sumregionalSingleRecord=`WR]+sum regionalAverageRecord=`WR,
 comps:count distinct competitionId, processName last personName by personId from results
`ratio xdesc update ratio:x%comps from
 select not sumregionalSingleRecord in ``NR]+sum not regionalAverageRecord in ``NR,
 comps:count distinct competitionId, processName last personName by personId from results
`ratio xdesc update ratio:x%comps from
 select sumregionalSingleRecord<>`]+sum regionalAverageRecord<>`,
 comps:count distinct competitionId, processName last personName by personId from results


ben: 1275 of 18820 or 6.77%

[edited for more recent stats!]
 
Last edited:

qqwref

Member
Joined
Dec 18, 2007
Messages
7,834
Location
a <script> tag near you
WCA
2006GOTT01
YouTube
Visit Channel
On today's episode of Stuff You Have (Probably Not) Been Wondering:
- There are 135 people who have completed every non-BLD event. The earliest one to enter the WCA database was 2003LARS01 (Anders Larsson), and the latest was was 2011MOLL01 (James Molloy) who first competed on 7/30/2011.
- Top 3 countries, by most people who ever had a NR in that country: USA (79), China (73), Indonesia (61).
- Top 3 competitions with most DNFs: US Nationals 2012 (657), US Nationals 2010 (594), Euro 2010 (575).
- All 4BLD means-of-3: Marcell Endrey (3:17.56), Gabriel Alejandro Orozco Casillas (6:09.39), Mike Hughey (7:09.23), Mats Bergsten (7:17.03), Julian David (9:56.90).
- Best FMC means of 3: Shuang Chen (30), Kanneti Sae Han/Tomoaki Okayama/Baiqiang Dong (30.7)
- Competition furthest from the equator: Iceland Open 2012 in Reykjavik, Iceland and then 7 in Trondheim, Norway. Competition closest to the equator: East Borneo Open 2011, Borneo 2012, and then Pekanbaru Cube Day 2011.
 

ben1996123

Banned
Joined
May 17, 2009
Messages
4,972
Location
Ponyville
WCA
2009WHIT01
YouTube
Visit Channel
today's episode of Stuff You Have (Probably Not) Been Wondering

please continue this series.

requests: highest/lowest DNF amount:total attempt amount ratio, amount of people who have competed in at least 1 blind event and never had a DNF in blind, amount of people who have never DNFd anything.

also, what program(s) do you use to run these queries?
 
Last edited:

Bob

Premium Member
Joined
Apr 23, 2006
Messages
1,473
Location
Kearny, NJ, USA
WCA
2003BURT01
- Competition furthest from the equator: Iceland Open 2012 in Reykjavik, Iceland and then 7 in Trondheim, Norway. Competition closest to the equator: East Borneo Open 2011, Borneo 2012, and then Pekanbaru Cube Day 2011.

Fun fact: When driving from Nairobi to Koobi Fora in Kenya, there is a small little sign that says "Equator" lol
 

Mollerz

Swag Overlord
Joined
May 17, 2011
Messages
1,204
Location
Surrey, England
WCA
2011MOLL01
YouTube
Visit Channel
On today's episode of Stuff You Have (Probably Not) Been Wondering:
- There are 135 people who have completed every non-BLD event. The earliest one to enter the WCA database was 2003LARS01 (Anders Larsson), and the latest was was 2011MOLL01 (James Molloy) who first competed on 7/30/2011.

O look det er me!

I should have had 4BLD and 5BLD successes, I've been so close a lot of times.
 

kinch2002

Premium Member
Joined
Dec 22, 2008
Messages
2,504
Location
Guildford! UK!
WCA
2009SHEP01
YouTube
Visit Channel
Linked to recent posts, my request:

1. List of all people who have a result in every event for single solve, sorted in 2 ways: a) The date this was achieved b) The number of days between first comp and the comp it was achieved
2. Same thing but for results in single and average for every event available

Yes I realise I will be top of both b) lists. I just want to see an automated list of everyone :p
 

Evan Liu

Member
Joined
Jul 15, 2009
Messages
922
WCA
2009LIUE01
YouTube
Visit Channel
Updated the sum of single and average ranks documents. The database export currently available is that of August 6th, so it doesn't contain results from Guiyang, Hefei, or Ha Noi (and as with before, does not include the magics). It does contain US Nationals results, of course.
I'm now 32nd for single and 34th for average. :D
 

qqwref

Member
Joined
Dec 18, 2007
Messages
7,834
Location
a <script> tag near you
WCA
2006GOTT01
YouTube
Visit Channel
Sub-10s (5+ in a row)
Code:
personId      personName           streak
2009ZEMD01    Feliks Zemdegs           21
2009CONT01    Giovanni Contardi        11
2007VALL01    Breandan Vallance        10
2009DIEC01    Cornelius Dieckmann      10
2009PLES01    Michał Pleskowicz        10
2007VALK01    Mats Valk                 9
2008HANK01    Kanneti Sae Han           9
2007NAKA03    Yu Nakajima               8
2009PICH01    Piti Pichedpan            8
2010RICC02    Andrew Ricci              8
2006TABU02    Yumu Tabuchi              7
2007HESS01    Rowe Hessler              6
2008SAJI01    Yu Sajima                 6
2009CHAR03    Nipat Charoenpholphant    6
2009FANH01    Haowei Fan                6
2009MORI05    Paolo Moriello            6
2010WEYE02    Sebastian Weyer           6
2007CHAN07    Harris Chan               5
2009SMAR01    Jan Smarschevski          5
2009YAUR01    Robert Yau                5

Sub-9s (3+ in a row, there are 19 people with 2):
Code:
personId      personName           streak
2009ZEMD01    Feliks Zemdegs            8
2009PLES01    Michał Pleskowicz         7
2006TABU02    Yumu Tabuchi              6
2007VALK01    Mats Valk                 4
2007VALL01    Breandan Vallance         4
2008HANK01    Kanneti Sae Han           4
2009CHAR03    Nipat Charoenpholphant    4
2009DIEC01    Cornelius Dieckmann       4
2005AKKE01    Erik Akkersdijk           3
2007HESS01    Rowe Hessler              3
2007NAKA03    Yu Nakajima               3
2009PICH01    Piti Pichedpan            3

Sub-8s (2+ in a row, there are >50 people with 1):
Code:
personId      personName           streak
2009ZEMD01    Feliks Zemdegs            3
2006TABU02    Yumu Tabuchi              2
2007VALK01    Mats Valk                 2
2009CHAR03    Nipat Charoenpholphant    2
2009DIEC01    Cornelius Dieckmann       2


And a little bonus, top ten sub15 and sub20 streaks:
Code:
sub15:
personId      personName             streak
2009KONV01    Asia Konvittayayotin      155
2005FERN01    Ravi Fernando             151
2006GUNJ01    Mitsuki Gunji             147
2006TABU02    Yumu Tabuchi              144
2008SAJI01    Yu Sajima                 132
2009CHAR03    Nipat Charoenpholphant    132
2009DIEC01    Cornelius Dieckmann       115
2008BARA01    Bence Barát               102
2007NAKA03    Yu Nakajima               101
2007VALK01    Mats Valk                  98
2009ZEMD01    Feliks Zemdegs             98

sub20:
personId      personName             streak
2008BARA01    Bence Barát               279
2005REYN01    Tim Reynolds              259
2007NAKA03    Yu Nakajima               228
2009DIEC01    Cornelius Dieckmann       226
2007POLK01    Adam Polkowski            224
2009SPRI01    Alexander Springhorn      223
2006OKAY01    Yohei Oka                 218
2009MORI05    Paolo Moriello            213
2007TAMA02    John Tamanas              193
2010UTOM01    Vincent Hartanto Utomo    192
 
Top