Stefan
Legend
Ooh... this was a bad year for Chris Hardwick. His first world championship where he didn't podium. Check the new "World Championship Podiums" section:
https://worldcubeassociation.org/results/p.php?i=2003HARD01
On the other hand, he's been much more successful in this regard than anyone else:
https://worldcubeassociation.org/results/p.php?i=2003HARD01
On the other hand, he's been much more successful in this regard than anyone else:
Code:
Who WCs Podiums
-------------------------------------------------
[url=https://worldcubeassociation.org/results/p.php?i=2003HARD01]Chris Hardwick[/url] 5 8
[url=https://worldcubeassociation.org/results/p.php?i=2006TABU02]Yumu Tabuchi[/url] 3 7
[url=https://worldcubeassociation.org/results/p.php?i=2003VAND01]Lars Vandenbergh[/url] 3 6
[url=https://worldcubeassociation.org/results/p.php?i=2005BATI01]Milán Baticz[/url] 3 6
[url=https://worldcubeassociation.org/results/p.php?i=2008BARA01]Bence Barát[/url] 3 5
[url=https://worldcubeassociation.org/results/p.php?i=2007HORV01]Máté Horváth[/url] 3 5
[url=https://worldcubeassociation.org/results/p.php?i=2008ANDE02]Oscar Roth Andersen[/url] 3 4
[url=https://worldcubeassociation.org/results/p.php?i=2003MAKI01]Shotaro Makisumi[/url] 3 4
[url=https://worldcubeassociation.org/results/p.php?i=2008WEST02]Simon Westlund[/url] 3 4
[url=https://worldcubeassociation.org/results/p.php?i=2004FERN01]Ernesto Fernández Regueira[/url] 3 3
[url=https://worldcubeassociation.org/results/p.php?i=2009ZEMD01]Feliks Zemdegs[/url] 2 11
[url=https://worldcubeassociation.org/results/p.php?i=2005AKKE01]Erik Akkersdijk[/url] 2 8
[url=https://worldcubeassociation.org/results/p.php?i=2007COHE01]Dan Cohen[/url] 2 7
[url=https://worldcubeassociation.org/results/p.php?i=2009SHEP01]Daniel Sheppard[/url] 2 5
[url=https://worldcubeassociation.org/results/p.php?i=2007ENDR01]Marcell Endrey[/url] 2 5
[url=https://worldcubeassociation.org/results/p.php?i=2007VALK01]Mats Valk[/url] 2 5
[url=https://worldcubeassociation.org/results/p.php?i=2006HALC01]Michał Halczuk[/url] 2 5
[url=https://worldcubeassociation.org/results/p.php?i=2006GUZE01]Rafał Guzewicz[/url] 2 5
[url=https://worldcubeassociation.org/results/p.php?i=2003POCH01]Stefan Pochmann[/url] 2 5
[url=https://worldcubeassociation.org/results/p.php?i=2008BODO01]Bálint Bodor[/url] 2 4
[url=https://worldcubeassociation.org/results/p.php?i=2003TREG02]Grant Tregay[/url] 2 4
[url=https://worldcubeassociation.org/results/p.php?i=2009HAYS01]Kevin Hays[/url] 2 4
[url=https://worldcubeassociation.org/results/p.php?i=2009PLES01]Michał Pleskowicz[/url] 2 4
[url=https://worldcubeassociation.org/results/p.php?i=2003BRUC01]Ron van Bruchem[/url] 2 4
[url=https://worldcubeassociation.org/results/p.php?i=2003VOMB01]Dror Vomberg[/url] 2 3
[url=https://worldcubeassociation.org/results/p.php?i=2003AKIM01]Masayuki Akimoto[/url] 2 3
[url=https://worldcubeassociation.org/results/p.php?i=2007HESS01]Rowe Hessler[/url] 2 3
[url=https://worldcubeassociation.org/results/p.php?i=2010CARN01]Zane Carney[/url] 2 3
[url=https://worldcubeassociation.org/results/p.php?i=2003BARR01]David Barr[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2004CHAM01]Edouard Chambon[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2006PRUS01]Grzegorz Prusak[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2006BUUS01]Henrik Buus Aagaard[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2004WOLF01]Oliver Wolff[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2003PATT01]Richard Patterson[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2004PATR01]Ryan Patricio[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2008AURO01]Sébastien Auroux[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2004MAOT02]Tyson Mao[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2006OKAY01]Yohei Oka[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2007NAKA03]Yu Nakajima[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2005CIAL02]Łukasz Ciałoń[/url] 2 2
[url=https://worldcubeassociation.org/results/p.php?i=2006KUTI01]Mátyás Kuti[/url] 1 7
[url=https://worldcubeassociation.org/results/p.php?i=2005OOMS01]Alexander Ooms[/url] 1 4
[url=https://worldcubeassociation.org/results/p.php?i=2006ORLA01]Bernett Orlando[/url] 1 3
[url=https://worldcubeassociation.org/results/p.php?i=2003WESL01]David Wesley[/url] 1 3
[url=https://worldcubeassociation.org/results/p.php?i=2003SCHE01]Jaap Scherphuis[/url] 1 3
[url=https://worldcubeassociation.org/results/p.php?i=2007SUNT01]Timothy Sun[/url] 1 3
[url=https://worldcubeassociation.org/results/p.php?i=2003BURT01]Bob Burton[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2007STRE01]Dennis Strehlau[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2003RUET01]Jake Rueth[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2004PONS01]Jean Pons[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2003GOET01]Jeff Goetz[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2004NOOR01]Joël van Noort[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2004LOLE01]Leyan Lo[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2010CORM02]Louis Cormier[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2011ZALE02]Marcin Zalewski[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2006GUNJ01]Mitsuki Gunji[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2009ANAM01]Muhammad Iril Khairul Anam[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2009CHAR03]Nipat Charoenpholphant[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2012ARTH01]Noah Arthurs[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2007PERG01]Olivér Perge[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2005KOZK01]Piotr Kózka[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2008PADL01]Piotr Michał Padlewski[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2010WEYE02]Sebastian Weyer[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2006ARAK01]Sinpei Araki[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2007OMUR01]Syuhei Omura[/url] 1 2
[url=https://worldcubeassociation.org/results/p.php?i=2009FEAN01]Aldo Feandri[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006KANG01]Andrew Kang[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003BELL01]Andy Bellenir[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2005VANH01]Anssi Vanhala[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2009FUSH01]Arifumi Fushimi[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007HORV02]Bálint Horváth[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007VALL01]Breandan Vallance[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2010STOL01]Cameron Stollery[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2005SZLA01]Chris Szlatenyi[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2011WALL02]Chris Wall[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2009DIEC01]Cornelius Dieckmann[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006DZOA03]Dan Dzoan[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003KNIG01]Dan Knights[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2010WUDA01]Daniel Wu[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008NADU01]Deven Nadudvari[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006CORR01]Devin Corr-Robinett[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2010BRAD01]Drew Brads[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008VIRT01]Durben Joun Virtucio[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2009LIUE01]Evan Liu[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003MORR01]Frank Morris[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003BADI01]Frédérick Badie[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008CASI01]Gabriel Alejandro Orozco Casillas[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2009CONT01]Giovanni Contardi[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2005LUCZ01]Grzegorz Łuczyna[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008POTR01]Guillain Potron[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=1982RAZO01]Guus Razoux Schultz[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2010KIPA01]Jakub Kipa[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003LEEJ01]Jasmine Lee[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2009TIRA01]Javier Tirado Ortiz[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=1982FRID01]Jessica Fridrich[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003MORR02]Jon Morris[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008JONG03]Jong-Ho Jeong[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2010DESJ01]Jules Desjardin[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2010DAVI06]Julian David[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007JIPT01]Kai Jiptner[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003BRAN01]Kenneth Brandon[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003BRAN02]Kevin Brandon[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008WERM02]Koen Wermer[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=1982PETR01]Lars Petrus[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2005JUNK01]Lee Jun-Kyo[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008SMIT04]Maarten Smit[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003ATKI01]Michael Atkinson[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006ROBA01]Michał Robaczyk[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=1982THAI01]Minh Thai[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003GOLJ01]Mirek Goljan[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2011DWYE02]Nathan Dwyer[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2004FRED02]Per Kristen Fredlund[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2010JULI01]Renhard Julindra[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006ORKE01]Róbert Örkényi[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2009YERU01]Ruzhen Ye[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006MOND01]Ryosuke Mondo[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006LAPI01]Stefan Łapicki[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007XUST01]Steven Xu[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007HASH01]Takao Hashimoto[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006OOKU01]Takayuki Ookusa[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007YOSH01]Takumi Yoshida[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007HABE01]Tim Habermaas[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2005REYN01]Tim Reynolds[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007WONG02]Tim Wong[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2006KIED01]Tomasz Kiedrowicz[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2005ZOLN01]Tomasz Żołnowski[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2009BOON04]Tong Boonrod[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008MIZU01]Weston Mizumoto[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007SEUN04]Yi Seung-Woo[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007HIRA03]Yoshiaki Hirayama[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2008SAJI01]Yu Sajima[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2007XUYU01]Yuhui Xu[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2005HAYA01]Yuki Hayashi[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=2003ZBOR02]Zbigniew Zborowski[/url] 1 1
[url=https://worldcubeassociation.org/results/p.php?i=1982LABA01]Zoltán Lábas[/url] 1 1
SELECT personId, personName, count(distinct year) years, count(distinct year, eventId) podiums
FROM Results, Competitions c
WHERE c.id=competitionId and c.cellName like 'World %'
AND best>0
AND roundId in ('c','f')
AND pos<=3
GROUP BY personId
ORDER BY years desc, podiums desc, personName
Last edited:
