• 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 35,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!

"All WCA Events Completion" Club

Joined
May 7, 2006
Messages
7,287
Likes
40
WCA
2003POCH01
YouTube
StefanPochmann
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. ;)
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:
Joined
May 9, 2010
Messages
544
Likes
12
Location
Hiroshima, Japan
WCA
2009OKAY01
YouTube
okayamat
Thread starter #184
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?!".
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:
 

Lid

Member
Joined
Jul 8, 2008
Messages
898
Likes
400
Location
Sweden
WCA
2008LIDS01
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).
 
Joined
May 9, 2010
Messages
544
Likes
12
Location
Hiroshima, Japan
WCA
2009OKAY01
YouTube
okayamat
Thread starter #192
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:
Joined
Nov 19, 2014
Messages
13
Likes
4
WCA
2009ISHI01
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:
Joined
May 9, 2010
Messages
544
Likes
12
Location
Hiroshima, Japan
WCA
2009OKAY01
YouTube
okayamat
Thread starter #199
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:
Top