"All WCA Events Completion" Club

Hi,

First, huge congrats and GJ for newcomers! well done!
And thanks to Corey for your (temporary) updates.
I'm considering the update of the lists next week or so.

On the date of the completion: As Evan mentioned, I wrote not the exact date of
the round, but the last date of the competition. This is because I don't know how
to investigate the dates in a pratical way. If you let me know the exact completion
date for all members (not only you), I'll surely correct the lists.
 
Lists updated! (investigated on Aug. 10) Nice to see many new members!

Platinum member
(all possible fields above "History (Map)": All Single+Average, World Championship Podiums, History of World Records, History of Continental Records)
  1. Henrik Buus Aagaard (Apr 6, 2014)
  2. Sébastien Auroux (Apr 20, 2014)
  3. Daniel Sheppard (May 18, 2014)
  4. Evan Liu (Jun 15, 2014) Upgraded!
  5. Bence Barát (Jul 13, 2014) Upgraded!

Gold member
(All Single+Average)
  1. Jan Bentlage (Jan 5, 2014)
  2. Andreas Pohl (Jan 5, 2014)
  3. Nikhil Mande (Jan 12, 2014)
  4. Tomoaki Okayama (Feb 8, 2014)
  5. Yunqi Ouyang (Mar 2, 2014)
  6. Jiawen Wu (Apr 26, 2014)
  7. John Brechon (May 10, 2014)
  8. Callum Hales-Jepp (May 18, 2014)
  9. Ben Whitmore (Jun 15, 2014) Upgraded!
  10. Ivan Zabrodin (Jun 29, 2014) New!
  11. Hong Zhang (Jul 6, 2014) Welcome back!
  12. Mike Hughey (Jul 13, 2014) Welcome back!
  13. Corey Sakowski (Jul 13, 2014) Upgraded!
  14. Akash Rupela (Jul 27, 2014) New!
  15. Timothy Sun (Aug 3, 2014) Upgraded!
  16. Antoine Cantin (Aug 3, 2014) New!
  17. Riley Woo (Aug 3, 2014) New!
  18. Walker Welch (Aug 3, 2014) New!
  19. Jakob Kogler (Aug 10, 2014) Upgraded!
  20. Simon Westlund (Aug 10, 2014) Upgraded!

Silver member
(All Single)
  1. Brandon Mikel (Jan 4, 2014)
  2. François Courtès (Jan 5, 2014)
  3. Maxim Chechnev (Feb 2, 2014)
  4. Yuhei Takagi (Feb 8, 2014)
  5. Cornelius Dieckmann (Feb 23, 2014)
  6. Sanae Koseki (Feb 23, 2014)
  7. Chung Tze Yang (Feb 23, 2014)
  8. Taku Yanai (Feb 23, 2014)
  9. Nick Vu (Mar 1, 2014)
  10. Chunyu Zhang 2 (Mar 2, 2014)
  11. Emanuel Rheinert (Mar 16, 2014)
  12. Patrick Kern (Apr 6, 2014)
  13. Jianyu Que (Apr 26, 2014)
  14. Qirun Zhong (May 2, 2014)
  15. Lucas Wesche (Jun 8, 2014) New!
  16. Anthony Hsu (Jun 14, 2014) Welcome back!
  17. Ainesh Sevellaraja (Jul 20, 2014) New!
  18. Shivam Bansal (Jul 27, 2014) New!
  19. Evan Brown (Aug 3, 2014) New!
  20. Yu Nakajima (Aug 10, 2014) New!

Alumni Gold Member (member until the end of 2013)
  1. Yan Xuan (May 15, 2011)
  2. Péter Trombitás (Sep 4, 2011)
  3. Jibo Zhao (Dec 25, 2011)
  4. Maarten Smit (Mar 4, 2012)

Alumni Silver Member (member until the end of 2013)
  1. Kai Jiptner (Jul 17, 2011)
 
Last edited:
Ha, I managed to misread the thread title. Here's what I thought it said:

[TABLE="class:grid,align:left"]
[TR][TD]Competitor[/TD][TD]DNFed in everything except...[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Nothing![/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD]Skewb[/TD][/TR]
[TR][TD]James Molloy[/TD][TD]5x5 Cube[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD]5x5 blindfolded[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD]3x3 with feet[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD]3x3 with feet,6x6 Cube[/TD][/TR]
[TR][TD]Dennis Rosero[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]3x3 with feet,Megaminx[/TD][/TR]
[TR][TD]Gilberto Caracciolo Morelli[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Hippolyte Moreau[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Ihor Bilchenko (Ігор Більченко)[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Jonathan Midjord Shapira[/TD][TD]7x7 Cube,Skewb[/TD][/TR]
[TR][TD]Marcin Zalewski[/TD][TD]Rubik's Clock,Square-1[/TD][/TR]
[TR][TD]Marek Wójtowicz[/TD][TD]5x5 blindfolded,Megaminx[/TD][/TR]
[TR][TD]Mariano D'Imperio[/TD][TD]3x3 with feet,Square-1[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Noah Arthurs[/TD][TD]3x3 multi blind,7x7 Cube[/TD][/TR]
[TR][TD]Péter Trombitás[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Riadi Arsandi[/TD][TD]Skewb,Square-1[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD]Rubik's Clock,Skewb[/TD][/TR]
[TR][TD]Shubhayan Kabir[/TD][TD]5x5 Cube,Square-1[/TD][/TR]
[/TABLE]
Just showing everybody missing DNFs in at most two of the 18 events. Database from five days ago cause I'm lazy. Congrats to Sébastien for being the sole complete failer :p. Please nobody take this as an incentive to DNF on purpose, though (this is just a one-time for-fun thing anyway, I don't intend to update it).

And we have platinum status now? Guess I'll have to do FMC mean (cool), 6x6 mean (ugh) and feet (UGH) now, I think that's all I'm missing.
 
Ha, I managed to misread the thread title. Here's what I thought it said:

[TABLE="class:grid,align:left"]
[TR][TD]Competitor[/TD][TD]DNFed in everything except...[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Nothing![/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD]Skewb[/TD][/TR]
[TR][TD]James Molloy[/TD][TD]5x5 Cube[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD]5x5 blindfolded[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD]3x3 with feet[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD]3x3 with feet,6x6 Cube[/TD][/TR]
[TR][TD]Dennis Rosero[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]3x3 with feet,Megaminx[/TD][/TR]
[TR][TD]Gilberto Caracciolo Morelli[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Hippolyte Moreau[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Ihor Bilchenko (Ігор Більченко)[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Jonathan Midjord Shapira[/TD][TD]7x7 Cube,Skewb[/TD][/TR]
[TR][TD]Marcin Zalewski[/TD][TD]Rubik's Clock,Square-1[/TD][/TR]
[TR][TD]Marek Wójtowicz[/TD][TD]5x5 blindfolded,Megaminx[/TD][/TR]
[TR][TD]Mariano D'Imperio[/TD][TD]3x3 with feet,Square-1[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Noah Arthurs[/TD][TD]3x3 multi blind,7x7 Cube[/TD][/TR]
[TR][TD]Péter Trombitás[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Riadi Arsandi[/TD][TD]Skewb,Square-1[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD]Rubik's Clock,Skewb[/TD][/TR]
[TR][TD]Shubhayan Kabir[/TD][TD]5x5 Cube,Square-1[/TD][/TR]
[/TABLE]

Ha ha. :cool:

I've also noticed that the thread title is misleading as Emanuel said, i.e., "Lists of those who have already done an attempt in all the WCA events", which is not my intention. Of cource I mean competitiors who have already set a valid record, not including DNF.

My original thread title was "Who have already completed all records of the official WCA events?" or like that. The current thread title maybe originate from the title of Noah's post. I think someone (moderator of this site?) changed the thread title from mine to Noah's.

Does anyone have a good idea for the thread title? I want to change the title to a better one.
- Lists of those who have already set records of all the WCA events
or like that?
 
Last edited:
Does anyone have a good idea for the thread title? I want to change the title to a better one.
- Lists of those who have already set records of all the WCA events
or like that?
Some people might misinterpret that as setting a WR or something.
Maybe "List of those who have an official success* in every WCA event"

*result?
I think result sounds better, but success removes any implication that a DNF might count.

Edit: "Ranking" perhaps?
 
Ha, I managed to misread the thread title. Here's what I thought it said:

[TABLE="class:grid,align:left"]
[TR][TD]Competitor[/TD][TD]DNFed in everything except...[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Nothing![/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD]Skewb[/TD][/TR]
[TR][TD]James Molloy[/TD][TD]5x5 Cube[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD]5x5 blindfolded[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD]3x3 with feet[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD]3x3 with feet,6x6 Cube[/TD][/TR]
[TR][TD]Dennis Rosero[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]3x3 with feet,Megaminx[/TD][/TR]
[TR][TD]Gilberto Caracciolo Morelli[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Hippolyte Moreau[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Ihor Bilchenko (Ігор Більченко)[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Jonathan Midjord Shapira[/TD][TD]7x7 Cube,Skewb[/TD][/TR]
[TR][TD]Marcin Zalewski[/TD][TD]Rubik's Clock,Square-1[/TD][/TR]
[TR][TD]Marek Wójtowicz[/TD][TD]5x5 blindfolded,Megaminx[/TD][/TR]
[TR][TD]Mariano D'Imperio[/TD][TD]3x3 with feet,Square-1[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Noah Arthurs[/TD][TD]3x3 multi blind,7x7 Cube[/TD][/TR]
[TR][TD]Péter Trombitás[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Riadi Arsandi[/TD][TD]Skewb,Square-1[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD]Rubik's Clock,Skewb[/TD][/TR]
[TR][TD]Shubhayan Kabir[/TD][TD]5x5 Cube,Square-1[/TD][/TR]
[/TABLE]
Just showing everybody missing DNFs in at most two of the 18 events. Database from five days ago cause I'm lazy. Congrats to Sébastien for being the sole complete failer :p. Please nobody take this as an incentive to DNF on purpose, though (this is just a one-time for-fun thing anyway, I don't intend to update it).

Haha, thanks for this, that made me actually lol. :)

Without wanting to be mean, I have the feeling that Laura is going to jong me on that throne as soon as she starts trying 5x5x5 BLD. ;)
 
Lists of those who have already competed in all the WCA events

Ha, I managed to misread the thread title. Here's what I thought it said:

[TABLE="class:grid,align:left"]
[TR][TD]Competitor[/TD][TD]DNFed in everything except...[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Nothing![/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD]Skewb[/TD][/TR]
[TR][TD]James Molloy[/TD][TD]5x5 Cube[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD]5x5 blindfolded[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD]3x3 with feet[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD]3x3 with feet,6x6 Cube[/TD][/TR]
[TR][TD]Dennis Rosero[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]3x3 with feet,Megaminx[/TD][/TR]
[TR][TD]Gilberto Caracciolo Morelli[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Hippolyte Moreau[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Ihor Bilchenko (Ігор Більченко)[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Jonathan Midjord Shapira[/TD][TD]7x7 Cube,Skewb[/TD][/TR]
[TR][TD]Marcin Zalewski[/TD][TD]Rubik's Clock,Square-1[/TD][/TR]
[TR][TD]Marek Wójtowicz[/TD][TD]5x5 blindfolded,Megaminx[/TD][/TR]
[TR][TD]Mariano D'Imperio[/TD][TD]3x3 with feet,Square-1[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Noah Arthurs[/TD][TD]3x3 multi blind,7x7 Cube[/TD][/TR]
[TR][TD]Péter Trombitás[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Riadi Arsandi[/TD][TD]Skewb,Square-1[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD]Rubik's Clock,Skewb[/TD][/TR]
[TR][TD]Shubhayan Kabir[/TD][TD]5x5 Cube,Square-1[/TD][/TR]
[/TABLE]
Just showing everybody missing DNFs in at most two of the 18 events. Database from five days ago cause I'm lazy. Congrats to Sébastien for being the sole complete failer :p. Please nobody take this as an incentive to DNF on purpose, though (this is just a one-time for-fun thing anyway, I don't intend to update it).

And we have platinum status now? Guess I'll have to do FMC mean (cool), 6x6 mean (ugh) and feet (UGH) now, I think that's all I'm missing.

Please just update it once!

I DNFed 7x7 at Nats because I was too slow, and I DNFed MBLD at Euros because I almost passed out due to dehydration.

Sorry Sebastien, but there are two DNF lords now :P
 
Please just update it once!

Ok, but only because I liked you in Californication.

Sorry Sebastien, but there are two DNF lords now :P

Three, actually.

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]FailedToFailAt[/TD][/TR]
[TR][TD]James Molloy[/TD][TD="align:right"]None[/TD][/TR]
[TR][TD]Noah Arthurs[/TD][TD="align:right"]None[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD="align:right"]None[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD]Skewb[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]Megaminx[/TD][/TR]
[TR][TD]Hippolyte Moreau[/TD][TD]5x5 blindfolded[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD]5x5 blindfolded[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD]5x5 blindfolded[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD]3x3 with feet[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD]3x3 with feet,6x6 Cube[/TD][/TR]
[TR][TD]Dennis Rosero[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]Gilberto Caracciolo Morelli[/TD][TD]5x5 blindfolded,Skewb[/TD][/TR]
[TR][TD]Ihor Bilchenko (Ігор Більченко)[/TD][TD]4x4 blindfolded,5x5 blindfolded[/TD][/TR]
[TR][TD]Jonathan Midjord Shapira[/TD][TD]7x7 Cube,Skewb[/TD][/TR]
[TR][TD]Marcin Zalewski[/TD][TD]Rubik's Clock,Square-1[/TD][/TR]
[TR][TD]Marek Wójtowicz[/TD][TD]5x5 blindfolded,Megaminx[/TD][/TR]
[TR][TD]Mariano D'Imperio[/TD][TD]3x3 with feet,Square-1[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Péter Trombitás[/TD][TD]3x3 with feet,Skewb[/TD][/TR]
[TR][TD]Riadi Arsandi[/TD][TD]Skewb,Square-1[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD]Rubik's Clock,Skewb[/TD][/TR]
[TR][TD]Shubhayan Kabir[/TD][TD]5x5 Cube,Square-1[/TD][/TR]
[/TABLE]
SELECT Persons.name Cuber, group_concat(if(personId is null,Events.cellName, null) order by Events.id) FailedToFailAt
FROM
(Persons JOIN Events)
LEFT JOIN
(SELECT distinct personId, eventId FROM Results WHERE -1 in (value1, value2, value3, value4, value5)) tmp
ON personId = Persons.id AND eventId = Events.id
WHERE Events.rank < 990
GROUP BY Persons.id
HAVING sum(personId is null) <= 2
ORDER BY sum(personId is null), Persons.name;
 
Back
Top