"All WCA Events Completion" Club

okayama said:
I just look at the competitors' profiles in the 5x5 blindfolded ranking, and check whether all records are set or not.
It's a pain, and I hope other SQLers help. ;)
Click to expand...

What do you mean with other SQLers? Doesn't sound like you're using SQL. Please clarify.

Btw, if I'm not mistaken, for example Sebastien only became platinum member so late because he was missing the continental records table. But he did have world records already, and every world record is also a continental record. Are you doing it this way intentionally? I think it might be better to just make world records a criterion. But it's your thing, so up to you.

And lol, while ctrl-f-ing this thread for "platinum", I saw "Platinum Member" under Tim Major's name and for a second I was like "Whoa, this got integrated into forum profiles?!".
 
Last edited:
Stefan said:
What do you mean with other SQLers? Doesn't sound like you're using SQL. Please clarify.

Btw, if I'm not mistaken, for example Sebastien only became platinum member so late because he was missing the continental records table. But he did have world records already, and every world record is also a continental record. Are you doing it this way intentionally? I think it might be better to just make world records a criterion. But it's your thing, so up to you.

And lol, while ctrl-f-ing this thread for "platinum", I saw "Platinum Member" under Tim Major's name and for a second I was like "Whoa, this got integrated into forum profiles?!".
Click to expand...

OK OK I'm foolish and I'm not using SQL, so I hope other person helps me who is familiar with SQL. :)

Yes, intentionally. Simon Westlund is also such a person; not a platinum member because he doesn't have the CR field although has WR.

I hope it (platinum/gold/silver) will be merged in the official WCA profile in some way. :cool:
 
A WR is also a CR in all other "sports", so people like Simon should imo be a "Platinum member", or are you gonna create a "Diamond member" category also (for people that have WR in their profiles).
 
Updated! (investigated on Dec. 1)

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)
  5. Bence Barát (Jul 13, 2014)
  6. Yu Nakajima (Nov 3, 2014)

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)
  10. Ivan Zabrodin (Jun 29, 2014)
  11. Hong Zhang (Jul 6, 2014)
  12. Mike Hughey (Jul 13, 2014)
  13. Corey Sakowski (Jul 13, 2014)
  14. Akash Rupela (Jul 27, 2014)
  15. Timothy Sun (Aug 3, 2014)
  16. Antoine Cantin (Aug 3, 2014)
  17. Riley Woo (Aug 3, 2014)
  18. Walker Welch (Aug 3, 2014)
  19. Jakob Kogler (Aug 10, 2014)
  20. Simon Westlund (Aug 10, 2014)
  21. Chunyu Zhang 2 (Oct 3, 2014)
  22. Jianyu Que (Oct 3, 2014)
  23. Emanuel Rheinert (Oct 5, 2014)
  24. Lucas Wesche (Oct 5, 2014)
  25. Conor Cronin (Oct 12, 2014)
  26. Nick Vu (Oct 26, 2014)
  27. Anthony Hsu (Nov 2, 2014)
  28. Taku Yanai (Nov 3, 2014)
  29. Brandon Mikel (Nov 15, 2014) Upgraded!
  30. Maarten Smit (Nov 23, 2014) Welcome back!

Silver member
(All Single)
  1. François Courtès (Jan 5, 2014)
  2. Maxim Chechnev (Feb 2, 2014)
  3. Yuhei Takagi (Feb 8, 2014)
  4. Cornelius Dieckmann (Feb 23, 2014)
  5. Sanae Omyo (Feb 23, 2014)
  6. Chung Tze Yang (Feb 23, 2014)
  7. Patrick Kern (Apr 6, 2014)
  8. Qirun Zhong (May 2, 2014)
  9. Ainesh Sevellaraja (Jul 20, 2014)
  10. Shivam Bansal (Jul 27, 2014)
  11. Evan Brown (Aug 3, 2014)
  12. Siva Shanmukh Vetcha (Aug 17, 2014)
  13. Billy Jeffs (Aug 25, 2014)
  14. Mimmi Leckius (Sep 21, 2014)
  15. Javier Tirado Ortiz (Sep 28, 2014)

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)

Alumni Silver Member (member until the end of 2013)
  1. Kai Jiptner (Jul 17, 2011)
 
Last edited:
Hello, I'm Akihiro Ishida in Japan.

I've created a "All WCA Events Completion" Club Web page,
that automatically gets and updates all results of competitions.
You can see Platinum member, Gold member, Silver member and People of One event missing.

http://roudai.net/database/all-wca-events-completion-club/

People of One event missing who achieved the records of 17 events (and the lacking event)

Enjoy it!
 
Last edited:
Thanks roudai! I edited the first post to write your site's url. ;)

I still write the updated lists here. Welcome Anton!

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)
  5. Bence Barát (Jul 13, 2014)
  6. Yu Nakajima (Nov 3, 2014)

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)
  10. Ivan Zabrodin (Jun 29, 2014)
  11. Hong Zhang (Jul 6, 2014)
  12. Mike Hughey (Jul 13, 2014)
  13. Corey Sakowski (Jul 13, 2014)
  14. Akash Rupela (Jul 27, 2014)
  15. Timothy Sun (Aug 3, 2014)
  16. Antoine Cantin (Aug 3, 2014)
  17. Riley Woo (Aug 3, 2014)
  18. Walker Welch (Aug 3, 2014)
  19. Jakob Kogler (Aug 10, 2014)
  20. Simon Westlund (Aug 10, 2014)
  21. Chunyu Zhang 2 (Oct 3, 2014)
  22. Jianyu Que (Oct 3, 2014)
  23. Emanuel Rheinert (Oct 5, 2014)
  24. Lucas Wesche (Oct 5, 2014)
  25. Conor Cronin (Oct 12, 2014)
  26. Nick Vu (Oct 26, 2014)
  27. Anthony Hsu (Nov 2, 2014)
  28. Taku Yanai (Nov 3, 2014)
  29. Brandon Mikel (Nov 15, 2014)
  30. Maarten Smit (Nov 23, 2014)

Silver member
(All Single)
  1. François Courtès (Jan 5, 2014)
  2. Maxim Chechnev (Feb 2, 2014)
  3. Yuhei Takagi (Feb 8, 2014)
  4. Cornelius Dieckmann (Feb 23, 2014)
  5. Sanae Omyo (Feb 23, 2014)
  6. Chung Tze Yang (Feb 23, 2014)
  7. Patrick Kern (Apr 6, 2014)
  8. Qirun Zhong (May 2, 2014)
  9. Ainesh Sevellaraja (Jul 20, 2014)
  10. Shivam Bansal (Jul 27, 2014)
  11. Evan Brown (Aug 3, 2014)
  12. Siva Shanmukh Vetcha (Aug 17, 2014)
  13. Billy Jeffs (Aug 25, 2014)
  14. Mimmi Leckius (Sep 21, 2014)
  15. Javier Tirado Ortiz (Sep 28, 2014)
  16. Anton Krokhmal (Feb 1, 2015) 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)

Alumni Silver Member (member until the end of 2013)
  1. Kai Jiptner (Jul 17, 2011)
 
Last edited:
With a lot of practice, and with much effort, i finally completed a 7x7 mean , and with it all wca events.
call guinness. :o :o:o:o
 
You must log in or register to reply here.

Similar threads

Michael Wimberly
  • Poll Poll
What Is Your Main Event?
2
Replies
20
Views
608
mdcuber9
mdcuber9
Kami
WCA Competition Boycott for "Problematic Events"
Replies
18
Views
1,868
Kami
Kami
abunickabhi
What event will WCA remove next?
2 3 4
Replies
68
Views
3,466
icedcool55
I
Davian
Changes to the WCA event list.
11 12 13
Replies
254
Views
16,469
MrCubert
MrCubert
Martyt7777
WCA Community Events Survey
2 3
Replies
41
Views
3,188
-Cube Kid-
-Cube Kid-
Back
Top