Odd WCA stats/ Stats request Thread

[Noahaha]

Indeed. The reason I looked this up btw was that I for some reason checked out Bob and saw a 3x3 best-of-1 round which rather surprised me.

Newark Head to Head does best-of-1 in round 2 of 3x3, since that round is the head to head, and only half of the people move on from the first solve.

 

[cubizh]

What day in the past had the most comps going on that same day?

Spoiler: Dates with most comps

[TABLE="class:grid,align:left"]
[TR][TD] Date [/TD][TD] Comps [/TD][/TR]
[TR][TD] 06-04-2013 [/TD][TD] 11 [/TD][/TR]
[TR][TD] 17-12-2011 [/TD][TD] 10 [/TD][/TR]
[TR][TD] 05-03-2011 [/TD][TD] 9 [/TD][/TR]
[TR][TD] 27-08-2011 [/TD][TD] 9 [/TD][/TR]
[TR][TD] 23-03-2013 [/TD][TD] 9 [/TD][/TR]
[TR][TD] 13-10-2013 [/TD][TD] 9 [/TD][/TR]
[TR][TD] 16-11-2013 [/TD][TD] 9 [/TD][/TR]
[TR][TD] 27-02-2010 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 30-07-2011 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 31-07-2011 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 26-11-2011 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 19-05-2012 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 22-09-2012 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 06-10-2012 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 05-10-2013 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 12-10-2013 [/TD][TD] 8 [/TD][/TR]
[TR][TD] 09-11-2013 [/TD][TD] 8 [/TD][/TR]
[/TABLE]

Spoiler: Evolution of competitions per date

 

[cubernya]

Greatest number of times a certain time has been achieved by one person, as well as any person? I just noticed that Mats Valk has 5 (!) 7.77s

 

[TDM]

He has seven 8.30s.
EDIT: just seen on his profile has a sup-minute 3x3 average.

 

[cubizh]

Spoiler: Who's who? (Number of same name people)

[TABLE="class:grid,align:left"]
[TR][TD] Names [/TD][TD] Number of people [/TD][/TR]
[TR][TD] Chen Chen (陈晨) [/TD][TD] 3 [/TD][/TR]
[TR][TD] Akshay Kumar [/TD][TD] 3 [/TD][/TR]
[TR][TD] Kevin Chen [/TD][TD] 3 [/TD][/TR]
[TR][TD] Bo Li (李博) [/TD][TD] 3 [/TD][/TR]
[TR][TD] Tao Huang (黄涛) [/TD][TD] 3 [/TD][/TR]
[TR][TD] James Lee [/TD][TD] 3 [/TD][/TR]
[TR][TD] Fan Wu (吴凡) [/TD][TD] 3 [/TD][/TR]
[TR][TD] Nikhil Anand [/TD][TD] 2 [/TD][/TR]
[TR][TD] Evan Gates [/TD][TD] 2 [/TD][/TR]
[TR][TD] Jack Lee [/TD][TD] 2 [/TD][/TR]
[TR][TD] Daniel Chung [/TD][TD] 2 [/TD][/TR]
[TR][TD] Kevin Hu [/TD][TD] 2 [/TD][/TR]
[TR][TD] Brian Kim [/TD][TD] 2 [/TD][/TR]
[TR][TD] Daniel Lee [/TD][TD] 2 [/TD][/TR]
[TR][TD] Alan Zhu [/TD][TD] 2 [/TD][/TR]
[TR][TD] Michael Chang [/TD][TD] 2 [/TD][/TR]
[TR][TD] Michael Chen [/TD][TD] 2 [/TD][/TR]
[TR][TD] Hao Wang (王昊) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Steven Kim [/TD][TD] 2 [/TD][/TR]
[TR][TD] Joshua Li [/TD][TD] 2 [/TD][/TR]
[TR][TD] Mark Paolo Belleza [/TD][TD] 2 [/TD][/TR]
[TR][TD] Nathan Feld [/TD][TD] 2 [/TD][/TR]
[TR][TD] Jordan Johnson [/TD][TD] 2 [/TD][/TR]
[TR][TD] Kevin Lau [/TD][TD] 2 [/TD][/TR]
[TR][TD] Felix Lee [/TD][TD] 2 [/TD][/TR]
[TR][TD] Peter Park [/TD][TD] 2 [/TD][/TR]
[TR][TD] Kevin Tam [/TD][TD] 2 [/TD][/TR]
[TR][TD] Sophia Tsai [/TD][TD] 2 [/TD][/TR]
[TR][TD] Chen Zhang [/TD][TD] 2 [/TD][/TR]
[TR][TD] Peng Zhang (张鹏) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Tao Hu (胡涛) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Jason Lee [/TD][TD] 2 [/TD][/TR]
[TR][TD] Timothy Lin [/TD][TD] 2 [/TD][/TR]
[TR][TD] Kevin Liu [/TD][TD] 2 [/TD][/TR]
[TR][TD] Yifan Li (李一凡) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Yunlong Li (李云龙) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Jian Ma (马健) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Ryan Menezes [/TD][TD] 2 [/TD][/TR]
[TR][TD] Neel Shah [/TD][TD] 2 [/TD][/TR]
[TR][TD] Chao Wang (王超) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Meng Wang (王猛) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Bo Wang (王波) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Ke Wang (王珂) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Di Wu (吴迪) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Yang Yang (杨阳) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Fan Yang 2 (杨帆) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Rong Zeng (曾嵘) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Lei Zhao (赵磊) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Linxuan Bi (闭临轩) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Shilong Chen (陈世龙) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Andrew Chen [/TD][TD] 2 [/TD][/TR]
[TR][TD] Bo Gao (高博) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Uswatun Hasanah [/TD][TD] 2 [/TD][/TR]
[TR][TD] Kang Li (李康) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Pengfei Liu (刘鹏飞) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Yuan Liu (刘源) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Zheng Li (李征) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Andrew Sun [/TD][TD] 2 [/TD][/TR]
[TR][TD] Lin Wei (魏琳) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Kevin Xu [/TD][TD] 2 [/TD][/TR]
[TR][TD] Lei Zhang (张磊) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Hao Zhang (张浩) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Zheng Li (李峥) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Fan Bu (卜凡) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Harsh Gupta [/TD][TD] 2 [/TD][/TR]
[TR][TD] Loo Kian KIt [/TD][TD] 2 [/TD][/TR]
[TR][TD] Aakash Kumar [/TD][TD] 2 [/TD][/TR]
[TR][TD] Christopher Lee [/TD][TD] 2 [/TD][/TR]
[TR][TD] Di Li (李迪) [/TD][TD] 2 [/TD][/TR]
[TR][TD] David Lin [/TD][TD] 2 [/TD][/TR]
[TR][TD] Sean Li [/TD][TD] 2 [/TD][/TR]
[TR][TD] Rui Liu (刘睿) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Yuan Li (李渊) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Muhammad Ridwan [/TD][TD] 2 [/TD][/TR]
[TR][TD] Rohan Sharma [/TD][TD] 2 [/TD][/TR]
[TR][TD] Alexander Smith [/TD][TD] 2 [/TD][/TR]
[TR][TD] Hongyuan Tang (唐鸿远) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Haoyu Wang (王浩宇) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Richard Zhang [/TD][TD] 2 [/TD][/TR]
[TR][TD] Wei Zhang (张伟) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Anand Krishnadas [/TD][TD] 2 [/TD][/TR]
[TR][TD] Jeevan Ravi [/TD][TD] 2 [/TD][/TR]
[TR][TD] Parth Shah [/TD][TD] 2 [/TD][/TR]
[TR][TD] Yang Liu (刘洋) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Yang Chen (陈扬) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Xingbo Wang (王星博) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Aaron Cohen [/TD][TD] 2 [/TD][/TR]
[TR][TD] Jie Wang (王杰) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Rishabh Sanghavi [/TD][TD] 2 [/TD][/TR]
[TR][TD] Xingyu Chen (陈星宇) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Bartosz Dąbrowski [/TD][TD] 2 [/TD][/TR]
[TR][TD] Jian Zhang (张健) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Qian Zhao (赵谦) [/TD][TD] 2 [/TD][/TR]
[TR][TD] Marcin Nowak [/TD][TD] 2 [/TD][/TR]
[TR][TD] Danda Sagar [/TD][TD] 2 [/TD][/TR]
[TR][TD] Szymon Jasieńczuk [/TD][TD] 2 [/TD][/TR]
[/TABLE]

Spoiler: Who's who?(extra odd)

The following competitor names have both male and female incarnations

Hao Wang (王昊)
Yifan Li (李一凡)
Fan Yang 2 (杨帆)
Zheng Li (李征)
Hao Zhang (张浩)

The following competitor names has one male and one unknown gender state

Lin Wei (魏琳)
Haoyu Wang (王浩宇)

 

[cubizh]

I have discounted events with DNF wins.
(FIXED)

Spoiler: Most wins in comps (non-DNF)

[TABLE="class:grid,align:left"]
[TR][TD] Number of Events [/TD][TD] CompetitionId [/TD][TD] Wins [/TD][TD] Competitor [/TD][/TR]
[TR][TD] With 19 events [/TD][TD] NorwegianChampionship2012 [/TD][TD] 13 [/TD][TD] Simon Westlund [/TD][/TR]
[TR][TD] With 18 events [/TD][TD] OhioOpen2009 [/TD][TD] 12 [/TD][TD] Dan Cohen [/TD][/TR]
[TR][TD] [/TD][TD] MelbourneSummer2011 [/TD][TD] 12 [/TD][TD] Feliks Zemdegs [/TD][/TR]
[TR][TD] With 17 events [/TD][TD] NorwegianOpen2010 [/TD][TD] 12 [/TD][TD] Erik Akkersdijk [/TD][/TR]
[TR][TD] With 16 events [/TD][TD] NorthernIrishOpen2013 [/TD][TD] 11 [/TD][TD] Daniel Sheppard [/TD][/TR]
[TR][TD] With 15 events [/TD][TD] DanishOpen2008 [/TD][TD] 10 [/TD][TD] Erik Akkersdijk [/TD][/TR]
[TR][TD] [/TD][TD] ABCOpen2010 [/TD][TD] 10 [/TD][TD] Pedro Santos Guimarães [/TD][/TR]
[TR][TD] [/TD][TD] AustralianNationals2010 [/TD][TD] 10 [/TD][TD] Feliks Zemdegs [/TD][/TR]
[TR][TD] With 14 events [/TD][TD] SaoPauloOpen2009 [/TD][TD] 9 [/TD][TD] Pedro Santos Guimarães [/TD][/TR]
[TR][TD] [/TD][TD] LOLSouthItalianOpen2010 [/TD][TD] 9 [/TD][TD] Bence Barát [/TD][/TR]
[TR][TD] [/TD][TD] AustralianNationals2013 [/TD][TD] 9 [/TD][TD] Feliks Zemdegs [/TD][/TR]
[TR][TD] With 13 events [/TD][TD] RomanianOpen2012 [/TD][TD] 9 [/TD][TD] Milán Baticz [/TD][/TR]
[TR][TD] With 12 events [/TD][TD] MinasOpen2008 [/TD][TD] 11 [/TD][TD] Pedro Santos Guimarães [/TD][/TR]
[TR][TD] With 11 events [/TD][TD] BeijingSpringOpen2008 [/TD][TD] 8 [/TD][TD] Timothy Sun [/TD][/TR]
[TR][TD] [/TD][TD] CarnegieMellonSpring2010 [/TD][TD] 8 [/TD][TD] Dan Cohen [/TD][/TR]
[TR][TD] With 10 events [/TD][TD] MelbourneCubeDay2010 [/TD][TD] 10 [/TD][TD] Feliks Zemdegs [/TD][/TR]
[TR][TD] With 9 events [/TD][TD] DrexelWinter2010 [/TD][TD] 9 [/TD][TD] Timothy Sun [/TD][/TR]
[TR][TD] With 8 events [/TD][TD] IndianOpen2010 [/TD][TD] 8 [/TD][TD] Bernett Orlando [/TD][/TR]
[TR][TD] With 7 events [/TD][TD] PragyanOpen2011 [/TD][TD] 7 [/TD][TD] Bernett Orlando [/TD][/TR]
[TR][TD] With 6 events [/TD][TD] WestJapanBigCube2012 [/TD][TD] 6 [/TD][TD] Yu Nakajima (中島悠) [/TD][/TR]
[/TABLE]

Most wins in comps (non-DNF)" (To Be Fixed)

Spoiler: Clean sweeps (wins in every competition event) (non-DNF wins)

[TABLE="class:grid,align:left"]
[TR][TD] Competition [/TD][TD] Number of events/wins [/TD][TD] Competitor [/TD][/TR]
[TR][TD] MelbourneCubeDay2010 [/TD][TD] 10 [/TD][TD] Feliks Zemdegs [/TD][/TR]
[TR][TD] DrexelWinter2010 [/TD][TD] 9 [/TD][TD] Timothy Sun [/TD][/TR]
[TR][TD] IndianOpen2010 [/TD][TD] 8 [/TD][TD] Bernett Orlando [/TD][/TR]
[TR][TD] PragyanOpen2011 [/TD][TD] 7 [/TD][TD] Bernett Orlando [/TD][/TR]
[TR][TD] WestJapanBigCube2012 [/TD][TD] 6 [/TD][TD] Yu Nakajima (中島悠) [/TD][/TR]
[/TABLE]

 

[TMOY]

With 20 events | LyonOpen2011

wtf ? I remember that all 19 official events were held at that comp, but where does the 20th come from ?

 

[cubizh]

wtf ? I remember that all 19 official events were held at that comp, but where does the 20th come from ?

I miscalculated the number of events in comp. Fixing it.

EDIT: Fixed. Thanks for the remark.

 

[cubizh]

Out of all 6 DNFs Feliks Zemdegs had in his Rubik's Cube event career so far, 5 of them were made in his last 4 competitions (Australian Nationals 2013, 2 at World Championship 2013, Shepparton Winter 2013 and Cupcake Cubing 2013).

His only other DNF was in Melbourne Cube Day 2010.

 

[cubizh]

Greatest number of times a certain time has been achieved by one person, as well as any person? I just noticed that Mats Valk has 5 (!) 7.77s

I do not have enough CPU power to process everyone.
I decided to only use the competitors in the top 100 3x3 average.

Spoiler: Most common singles

[TABLE="class:grid,align:left"]
[TR][TD] Competitor [/TD][TD] Time [/TD][TD] Number of times [/TD][/TR]
[TR][TD] Rowe Hessler [/TD][TD] 10.02 [/TD][TD] 11 [/TD][/TR]
[TR][TD] Yu Sajima (佐島優) [/TD][TD] 10.44 [/TD][TD] 9 [/TD][/TR]
[TR][TD] Erik Akkersdijk [/TD][TD] 11.30 [/TD][TD] 9 [/TD][/TR]
[TR][TD] Tomasz Żołnowski [/TD][TD] 10.78 [/TD][TD] 9 [/TD][/TR]
[TR][TD] Breandan Vallance [/TD][TD] 9.91 [/TD][TD] 8 [/TD][/TR]
[TR][TD] Yu Nakajima (中島悠) [/TD][TD] 9.90 [/TD][TD] 8 [/TD][/TR]
[TR][TD] Mats Valk [/TD][TD] 8.30 [/TD][TD] 7 [/TD][/TR]
[TR][TD] Yumu Tabuchi (田渕雄夢) [/TD][TD] 10.38 [/TD][TD] 7 [/TD][/TR]
[TR][TD] Dan Cohen [/TD][TD] 11.33 [/TD][TD] 7 [/TD][/TR]
[TR][TD] Syuhei Omura (大村周平) [/TD][TD] 12.33 [/TD][TD] 7 [/TD][/TR]
[TR][TD] Kanneti Sae Han (คันธ์เนตี แซ่ห่าน) [/TD][TD] 10.21 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Paolo Moriello [/TD][TD] 9.72 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Phillip Espinoza [/TD][TD] 12.93 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Milán Baticz [/TD][TD] 12.33 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Michał Halczuk [/TD][TD] 12.96 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Feliks Zemdegs [/TD][TD] 9.25 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Cornelius Dieckmann [/TD][TD] 10.00 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Robert Yau [/TD][TD] 10.50 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Sebastian Weyer [/TD][TD] 11.30 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Vincent Hartanto Utomo [/TD][TD] 9.77 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Anthony Brooks [/TD][TD] 9.52 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Michał Pleskowicz [/TD][TD] 9.27 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Sergey Ryabko [/TD][TD] 9.66 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Andrew Ricci [/TD][TD] 9.56 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Arifumi Fushimi (伏見有史) [/TD][TD] 10.38 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Gabriel Dechichi Barbar [/TD][TD] 11.00 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Stefan Huber [/TD][TD] 10.13 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Harris Chan [/TD][TD] 11.00 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Thompson Clarke [/TD][TD] 11.88 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Kevin Costello III [/TD][TD] 10.15 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Edward Lin [/TD][TD] 11.06 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Andy Tsao [/TD][TD] 10.83 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Christopher Olson [/TD][TD] 11.61 [/TD][TD] 5 [/TD][/TR]
[TR][TD] James Hamory [/TD][TD] 10.40 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Leon Schmidtchen [/TD][TD] 10.52 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Simon Westlund [/TD][TD] 12.34 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Weixing Zhang (张炜星) [/TD][TD] 11.71 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Jan Smarschevski [/TD][TD] 10.06 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Mitsuki Gunji (郡司光貴) [/TD][TD] 11.31 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Nikolay Evdokimov [/TD][TD] 12.77 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์) [/TD][TD] 9.15 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Haowei Fan (樊浩玮) [/TD][TD] 11.77 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Piti Pichedpan (ปิติ พิเชษฐพันธ์) [/TD][TD] 13.65 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Asia Konvittayayotin (เอเชีย กรวิทย์โยธิน) [/TD][TD] 9.63 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Giovanni Contardi [/TD][TD] 9.31 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Carlos Méndez García-Barroso [/TD][TD] 10.36 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Morten Arborg [/TD][TD] 8.69 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Ivan Vynnyk (Іван Винник) [/TD][TD] 10.28 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Philipp Weyer [/TD][TD] 9.38 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Lucas Etter [/TD][TD] 13.50 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Justin Adsuara [/TD][TD] 11.41 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Xiaolin Zeng (曾小林) [/TD][TD] 9.77 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Hendry Cahyadi [/TD][TD] 10.18 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Marcin Zalewski [/TD][TD] 10.02 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Eric Limeback [/TD][TD] 10.27 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Yinghao Wang (王鹰豪) [/TD][TD] 11.02 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Ravi Fernando [/TD][TD] 10.27 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Mulun Yin (阴目仑) [/TD][TD] 11.83 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Howard Wong Jun Yen (黄俊仁) [/TD][TD] 12.06 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Justin Mallari [/TD][TD] 10.27 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Kirt Protacio [/TD][TD] 11.68 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Emily Wang [/TD][TD] 11.55 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Collin Burns [/TD][TD] 9.91 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Moritz Patzelt [/TD][TD] 10.83 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Alexander Lau [/TD][TD] 7.69 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Richard Jay S. Apagar [/TD][TD] 9.03 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Dario Roa Sánchez [/TD][TD] 9.46 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jr-Wei Jang (張智瑋) [/TD][TD] 12.13 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Kevin Hays [/TD][TD] 10.33 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Daniil Lee [/TD][TD] 11.00 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Kailong Li (李开隆) [/TD][TD] 9.59 [/TD][TD] 3 [/TD][/TR]
[TR][TD] I-Fan Wu (吳亦凡) [/TD][TD] 10.72 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Przemysław Kaleta [/TD][TD] 9.91 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Zhouheng Sun (孙舟横) [/TD][TD] 9.63 [/TD][TD] 3 [/TD][/TR]
[TR][TD] SeungBeom Cho [/TD][TD] 10.69 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Austin Moore [/TD][TD] 10.19 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jong-Ho Jeong (정종호) [/TD][TD] 10.36 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jakub Kipa [/TD][TD] 9.25 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Yongting You (尤永庭) [/TD][TD] 10.66 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Andy Smith [/TD][TD] 9.47 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Yi-Heng Lee (李宜衡) [/TD][TD] 9.93 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jonathan Tan Wei Xiat [/TD][TD] 11.88 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Francis Wong Jia Yen [/TD][TD] 11.41 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Leong Wing Sik [/TD][TD] 10.47 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Riley Woo [/TD][TD] 10.61 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Waris Ali [/TD][TD] 11.00 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Joar Mellström [/TD][TD] 10.77 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Teo Kai Xiang [/TD][TD] 10.97 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jure Gregorc [/TD][TD] 10.91 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Durben Joun Virtucio [/TD][TD] 10.68 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Andrew Sopchak [/TD][TD] 10.66 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Thanaporn Sichanugrist (ธนพร สิชฌนุกฤษฎ์) [/TD][TD] 10.08 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Bill Wang [/TD][TD] 8.80 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Drew Brads [/TD][TD] 10.40 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Sei Sugama (洲鎌星) [/TD][TD] 9.28 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Kaijun Lin (林恺俊) [/TD][TD] 11.31 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Harald Stiff [/TD][TD] 9.68 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی) [/TD][TD] 8.28 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Sungho Hong (홍성호) [/TD][TD] 10.58 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Congbiao Jiang (蒋丛骉) [/TD][TD] 11.55 [/TD][TD] 2 [/TD][/TR]
[/TABLE]

 

[Stefan]

I do not have enough CPU power to process everyone.

Took my rather weak notebook about 9 seconds (though maybe it differs from what you had in mind):

Spoiler: Most frequent times

[TABLE="class:grid,align:left"]
[TR][TD]time[/TD][TD]number_of_times[/TD][/TR]
[TR][TD="align:right"]5.22[/TD][TD="align:right"]872[/TD][/TR]
[TR][TD="align:right"]5.68[/TD][TD="align:right"]859[/TD][/TR]
[TR][TD="align:right"]5.88[/TD][TD="align:right"]851[/TD][/TR]
[TR][TD="align:right"]5.50[/TD][TD="align:right"]850[/TD][/TR]
[TR][TD="align:right"]4.96[/TD][TD="align:right"]850[/TD][/TR]
[TR][TD="align:right"]5.81[/TD][TD="align:right"]846[/TD][/TR]
[TR][TD="align:right"]6.03[/TD][TD="align:right"]844[/TD][/TR]
[TR][TD="align:right"]14.72[/TD][TD="align:right"]839[/TD][/TR]
[TR][TD="align:right"]5.72[/TD][TD="align:right"]835[/TD][/TR]
[TR][TD="align:right"]5.84[/TD][TD="align:right"]830[/TD][/TR]
[TR][TD="align:right"]4.80[/TD][TD="align:right"]828[/TD][/TR]
[TR][TD="align:right"]5.80[/TD][TD="align:right"]827[/TD][/TR]
[TR][TD="align:right"]5.83[/TD][TD="align:right"]827[/TD][/TR]
[TR][TD="align:right"]4.88[/TD][TD="align:right"]827[/TD][/TR]
[TR][TD="align:right"]5.53[/TD][TD="align:right"]826[/TD][/TR]
[TR][TD="align:right"]14.59[/TD][TD="align:right"]824[/TD][/TR]
[TR][TD="align:right"]5.59[/TD][TD="align:right"]824[/TD][/TR]
[TR][TD="align:right"]4.90[/TD][TD="align:right"]823[/TD][/TR]
[TR][TD="align:right"]15.80[/TD][TD="align:right"]823[/TD][/TR]
[TR][TD="align:right"]6.00[/TD][TD="align:right"]820[/TD][/TR]
[TR][TD="align:right"]6.09[/TD][TD="align:right"]820[/TD][/TR]
[TR][TD="align:right"]5.28[/TD][TD="align:right"]820[/TD][/TR]
[TR][TD="align:right"]6.25[/TD][TD="align:right"]819[/TD][/TR]
[TR][TD="align:right"]5.77[/TD][TD="align:right"]818[/TD][/TR]
[TR][TD="align:right"]5.21[/TD][TD="align:right"]818[/TD][/TR]
[TR][TD="align:right"]5.30[/TD][TD="align:right"]815[/TD][/TR]
[TR][TD="align:right"]5.08[/TD][TD="align:right"]815[/TD][/TR]
[TR][TD="align:right"]4.72[/TD][TD="align:right"]814[/TD][/TR]
[TR][TD="align:right"]5.55[/TD][TD="align:right"]814[/TD][/TR]
[TR][TD="align:right"]4.83[/TD][TD="align:right"]812[/TD][/TR]
[TR][TD="align:right"]4.94[/TD][TD="align:right"]811[/TD][/TR]
[TR][TD="align:right"]5.65[/TD][TD="align:right"]810[/TD][/TR]
[TR][TD="align:right"]5.63[/TD][TD="align:right"]810[/TD][/TR]
[TR][TD="align:right"]13.80[/TD][TD="align:right"]810[/TD][/TR]
[TR][TD="align:right"]5.56[/TD][TD="align:right"]807[/TD][/TR]
[TR][TD="align:right"]5.58[/TD][TD="align:right"]807[/TD][/TR]
[TR][TD="align:right"]6.33[/TD][TD="align:right"]806[/TD][/TR]
[TR][TD="align:right"]6.21[/TD][TD="align:right"]806[/TD][/TR]
[TR][TD="align:right"]5.13[/TD][TD="align:right"]805[/TD][/TR]
[TR][TD="align:right"]13.91[/TD][TD="align:right"]805[/TD][/TR]
[TR][TD="align:right"]5.46[/TD][TD="align:right"]803[/TD][/TR]
[TR][TD="align:right"]4.75[/TD][TD="align:right"]802[/TD][/TR]
[TR][TD="align:right"]5.16[/TD][TD="align:right"]799[/TD][/TR]
[TR][TD="align:right"]13.96[/TD][TD="align:right"]798[/TD][/TR]
[TR][TD="align:right"]5.40[/TD][TD="align:right"]798[/TD][/TR]
[TR][TD="align:right"]5.47[/TD][TD="align:right"]797[/TD][/TR]
[TR][TD="align:right"]5.69[/TD][TD="align:right"]796[/TD][/TR]
[TR][TD="align:right"]5.44[/TD][TD="align:right"]796[/TD][/TR]
[TR][TD="align:right"]5.66[/TD][TD="align:right"]794[/TD][/TR]
[TR][TD="align:right"]5.94[/TD][TD="align:right"]794[/TD][/TR]
[TR][TD="align:right"]14.78[/TD][TD="align:right"]794[/TD][/TR]
[TR][TD="align:right"]6.05[/TD][TD="align:right"]794[/TD][/TR]
[TR][TD="align:right"]16.18[/TD][TD="align:right"]792[/TD][/TR]
[TR][TD="align:right"]15.59[/TD][TD="align:right"]792[/TD][/TR]
[TR][TD="align:right"]14.38[/TD][TD="align:right"]791[/TD][/TR]
[TR][TD="align:right"]13.46[/TD][TD="align:right"]790[/TD][/TR]
[TR][TD="align:right"]5.33[/TD][TD="align:right"]790[/TD][/TR]
[TR][TD="align:right"]5.38[/TD][TD="align:right"]790[/TD][/TR]
[TR][TD="align:right"]5.78[/TD][TD="align:right"]790[/TD][/TR]
[TR][TD="align:right"]14.16[/TD][TD="align:right"]790[/TD][/TR]
[TR][TD="align:right"]6.47[/TD][TD="align:right"]789[/TD][/TR]
[TR][TD="align:right"]5.91[/TD][TD="align:right"]789[/TD][/TR]
[TR][TD="align:right"]4.47[/TD][TD="align:right"]789[/TD][/TR]
[TR][TD="align:right"]4.59[/TD][TD="align:right"]789[/TD][/TR]
[TR][TD="align:right"]13.93[/TD][TD="align:right"]789[/TD][/TR]
[TR][TD="align:right"]5.96[/TD][TD="align:right"]789[/TD][/TR]
[TR][TD="align:right"]15.03[/TD][TD="align:right"]786[/TD][/TR]
[TR][TD="align:right"]6.06[/TD][TD="align:right"]786[/TD][/TR]
[TR][TD="align:right"]4.58[/TD][TD="align:right"]785[/TD][/TR]
[TR][TD="align:right"]5.05[/TD][TD="align:right"]785[/TD][/TR]
[TR][TD="align:right"]13.68[/TD][TD="align:right"]785[/TD][/TR]
[TR][TD="align:right"]15.02[/TD][TD="align:right"]785[/TD][/TR]
[TR][TD="align:right"]15.00[/TD][TD="align:right"]785[/TD][/TR]
[TR][TD="align:right"]5.43[/TD][TD="align:right"]785[/TD][/TR]
[TR][TD="align:right"]4.86[/TD][TD="align:right"]784[/TD][/TR]
[TR][TD="align:right"]6.02[/TD][TD="align:right"]784[/TD][/TR]
[TR][TD="align:right"]6.38[/TD][TD="align:right"]784[/TD][/TR]
[TR][TD="align:right"]5.34[/TD][TD="align:right"]783[/TD][/TR]
[TR][TD="align:right"]5.71[/TD][TD="align:right"]783[/TD][/TR]
[TR][TD="align:right"]5.52[/TD][TD="align:right"]783[/TD][/TR]
[TR][TD="align:right"]5.27[/TD][TD="align:right"]782[/TD][/TR]
[TR][TD="align:right"]14.46[/TD][TD="align:right"]782[/TD][/TR]
[TR][TD="align:right"]6.40[/TD][TD="align:right"]782[/TD][/TR]
[TR][TD="align:right"]15.40[/TD][TD="align:right"]782[/TD][/TR]
[TR][TD="align:right"]14.71[/TD][TD="align:right"]782[/TD][/TR]
[TR][TD="align:right"]4.78[/TD][TD="align:right"]782[/TD][/TR]
[TR][TD="align:right"]13.81[/TD][TD="align:right"]781[/TD][/TR]
[TR][TD="align:right"]6.18[/TD][TD="align:right"]781[/TD][/TR]
[TR][TD="align:right"]5.18[/TD][TD="align:right"]781[/TD][/TR]
[TR][TD="align:right"]5.97[/TD][TD="align:right"]779[/TD][/TR]
[TR][TD="align:right"]4.68[/TD][TD="align:right"]779[/TD][/TR]
[TR][TD="align:right"]5.90[/TD][TD="align:right"]778[/TD][/TR]
[TR][TD="align:right"]6.28[/TD][TD="align:right"]778[/TD][/TR]
[TR][TD="align:right"]5.19[/TD][TD="align:right"]778[/TD][/TR]
[TR][TD="align:right"]6.08[/TD][TD="align:right"]778[/TD][/TR]
[TR][TD="align:right"]6.53[/TD][TD="align:right"]777[/TD][/TR]
[TR][TD="align:right"]14.97[/TD][TD="align:right"]777[/TD][/TR]
[TR][TD="align:right"]6.43[/TD][TD="align:right"]777[/TD][/TR]
[TR][TD="align:right"]5.93[/TD][TD="align:right"]777[/TD][/TR]
[TR][TD="align:right"]14.18[/TD][TD="align:right"]776[/TD][/TR]
[/TABLE]

Spoiler: SQL code

select round(v/100,2) time, count(*) number_of_times from(
select value1 v from Results join Events on Events.id=eventId where Events.format='time' and value1>0 union all
select value2 v from Results join Events on Events.id=eventId where Events.format='time' and value2>0 union all
select value3 v from Results join Events on Events.id=eventId where Events.format='time' and value3>0 union all
select value4 v from Results join Events on Events.id=eventId where Events.format='time' and value4>0 union all
select value5 v from Results join Events on Events.id=eventId where Events.format='time' and value5>0) tmp
group by v
order by 2 desc
limit 100;

 

[cubizh]

Took my rather weak notebook about 9 seconds (though maybe it differs from what you had in mind):

Yes, it differs.
The idea was to do that per person, in order to create a list of people that repeated the same time the most. On the list I posted, Rowe Hessler repeated 11 times 10.02, which is his most common result. Yu Sajima repeated 9 times 10.44, etc.
For each person you have to find out what's his/her most common time.
Doing that for 20k+ people is rather complicated to do, with my basic knowledge, in a way Excel does not crash on me.

 

[Stefan]

Ok that took about 41 seconds and I'm not exactly proud of my ugly solution.

Erik got his 3.43 in four different events. Too busy to look for that in general now...

(my database is from last week, so might not be entirely correct now)

Spoiler: Most frequent times by competitor

[TABLE="class:grid,align:left"]
[TR][TD]name[/TD][TD]time[/TD][TD]number_of_times[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD="align:right"]1.31[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Takao Hashimoto (橋本貴夫)[/TD][TD="align:right"]1.21[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD="align:right"]3.43[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Yohei Oka (岡要平)[/TD][TD="align:right"]1.22[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Marcin Jakubowski[/TD][TD="align:right"]0.94[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD="align:right"]1.59[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Henrik Buus Aagaard[/TD][TD="align:right"]1.03[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD="align:right"]5.96[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Gaël Dusser[/TD][TD="align:right"]1.47[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Bence Barát[/TD][TD="align:right"]1.19[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Piotr Michał Padlewski[/TD][TD="align:right"]1.19[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Quentin Lefebvre[/TD][TD="align:right"]1.18[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]10.02[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD="align:right"]1.59[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD="align:right"]15.72[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Kian Barry[/TD][TD="align:right"]5.72[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]François Courtès[/TD][TD="align:right"]5.43[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Timothy Sun[/TD][TD="align:right"]3.86[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Dániel Varga[/TD][TD="align:right"]3.63[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Justin Jaffray[/TD][TD="align:right"]3.38[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD="align:right"]1.88[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Javier Tirado Ortiz[/TD][TD="align:right"]1.25[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Filippo Brancaleoni[/TD][TD="align:right"]1.02[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Yuxuan Wang (王宇轩)[/TD][TD="align:right"]0.86[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Gunnar Krig[/TD][TD="align:right"]13.50[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD="align:right"]13.16[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD="align:right"]10.81[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Yu Sajima (佐島優)[/TD][TD="align:right"]10.44[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]8.30[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Brúnó Bereczki[/TD][TD="align:right"]5.28[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Pau Vela García[/TD][TD="align:right"]4.34[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Jan Bentlage[/TD][TD="align:right"]4.08[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD="align:right"]3.94[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Anthony Searle[/TD][TD="align:right"]3.05[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Anthony Brooks[/TD][TD="align:right"]3.05[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Sanio Kasumovic[/TD][TD="align:right"]2.44[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Jaclyn Sawler[/TD][TD="align:right"]1.71[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD="align:right"]1.27[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Takuya Furukawa (古河拓也)[/TD][TD="align:right"]1.25[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Marek Padlewski[/TD][TD="align:right"]1.22[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Ting Sheng Bao Yang[/TD][TD="align:right"]1.02[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]15.09[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Michael Röhrer[/TD][TD="align:right"]14.13[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Dan Dzoan[/TD][TD="align:right"]14.06[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD="align:right"]10.43[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Yu Nakajima (中島悠)[/TD][TD="align:right"]9.90[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Zoé de Moffarts[/TD][TD="align:right"]7.96[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Dmitry Kryuzban[/TD][TD="align:right"]4.30[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD="align:right"]4.05[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Oscar Roth Andersen[/TD][TD="align:right"]3.84[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Olivier Polspoel[/TD][TD="align:right"]1.63[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Gilles van den Peereboom[/TD][TD="align:right"]1.33[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Ryan Jew[/TD][TD="align:right"]1.16[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Samuel Chiu[/TD][TD="align:right"]1.06[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Korneliusz Tombarkiewicz[/TD][TD="align:right"]1.05[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD="align:right"]1.02[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Chau Ka Wai (周嘉偉)[/TD][TD="align:right"]1.00[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]David Calvo Vivas[/TD][TD="align:right"]16.28[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Leyan Lo[/TD][TD="align:right"]15.50[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Robin Blöhm[/TD][TD="align:right"]15.30[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Lorenzo Vigani Poli[/TD][TD="align:right"]14.58[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]14.43[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD="align:right"]14.13[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD="align:right"]13.71[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Fabian Auroux[/TD][TD="align:right"]13.63[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Lucas Garron[/TD][TD="align:right"]13.36[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Edouard Chambon[/TD][TD="align:right"]13.03[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Michał Halczuk[/TD][TD="align:right"]12.96[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Rama Temmink[/TD][TD="align:right"]12.86[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Adam Polkowski[/TD][TD="align:right"]12.66[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Syuhei Omura (大村周平)[/TD][TD="align:right"]12.33[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Pedro Santos Guimarães[/TD][TD="align:right"]11.41[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Björn Korbanka[/TD][TD="align:right"]10.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Yumu Tabuchi (田渕雄夢)[/TD][TD="align:right"]10.38[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Louis Cormier[/TD][TD="align:right"]10.21[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Paolo Moriello[/TD][TD="align:right"]9.97[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Robert Yau[/TD][TD="align:right"]9.28[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Michał Pleskowicz[/TD][TD="align:right"]9.27[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD="align:right"]8.33[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]7.13[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Owidiusz Pryk[/TD][TD="align:right"]5.71[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Riadi Arsandi[/TD][TD="align:right"]4.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Thom Barlow[/TD][TD="align:right"]4.03[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Thompson Clarke[/TD][TD="align:right"]3.96[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Antoine Cantin[/TD][TD="align:right"]3.84[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Philippe Virouleau[/TD][TD="align:right"]3.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Piotr Kózka[/TD][TD="align:right"]3.63[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kirk Nicklaus Manibuy[/TD][TD="align:right"]3.41[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Maarten Smit[/TD][TD="align:right"]3.27[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Steven Turner[/TD][TD="align:right"]2.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Máté Horváth[/TD][TD="align:right"]2.18[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Ernie Pulchny[/TD][TD="align:right"]1.81[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Rafał Studnicki[/TD][TD="align:right"]1.68[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Markus Pirzer[/TD][TD="align:right"]1.58[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kirstine Buus Aagaard[/TD][TD="align:right"]1.38[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Takuma Shirahase (白波瀬拓磨)[/TD][TD="align:right"]1.36[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kalina Brzezińska[/TD][TD="align:right"]1.27[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Fubo Wang (王富博)[/TD][TD="align:right"]1.09[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Ge Song (宋鸽)[/TD][TD="align:right"]1.02[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Chan Tak Chuen (陳德泉)[/TD][TD="align:right"]1.02[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD="align:right"]19.71[/TD][TD="align:right"]6[/TD][/TR]
[/TABLE]

Spoiler: SQL code

select Persons.name, round(foo%(100*60*60*10)/100,2) time, floor(foo/(100*60*60*10)) number_of_times from (
select personId, max(number_of_times*100*60*60*10+v) foo from(
select personId, v, count(*) number_of_times from(
select personId, value1 v from Results join Events on Events.id=eventId where Events.format='time' and value1>0 union all
select personId, value2 v from Results join Events on Events.id=eventId where Events.format='time' and value2>0 union all
select personId, value3 v from Results join Events on Events.id=eventId where Events.format='time' and value3>0 union all
select personId, value4 v from Results join Events on Events.id=eventId where Events.format='time' and value4>0 union all
select personId, value5 v from Results join Events on Events.id=eventId where Events.format='time' and value5>0) tmp
group by personId, v) tmp2
group by personId
order by foo desc
limit 100) tmp3 join Persons on Persons.id=personId;

 

[cubizh]

Yeah it's not perfect, because it doesn't show which event(s), mixing times through events, which didn't occur to me do, but it's nice and you should still be proud. Thanks.

 

[rowehessler]

I do not have enough CPU power to process everyone.
I decided to only use the competitors in the top 100 3x3 average.

Spoiler: Most common singles

[TABLE="class:grid,align:left"]
[TR][TD] Competitor [/TD][TD] Time [/TD][TD] Number of times [/TD][/TR]
[TR][TD] Rowe Hessler [/TD][TD] 10.02 [/TD][TD] 11 [/TD][/TR]
[TR][TD] Yu Sajima (佐島優) [/TD][TD] 10.44 [/TD][TD] 9 [/TD][/TR]
[TR][TD] Erik Akkersdijk [/TD][TD] 11.30 [/TD][TD] 9 [/TD][/TR]
[TR][TD] Tomasz Żołnowski [/TD][TD] 10.78 [/TD][TD] 9 [/TD][/TR]
[TR][TD] Breandan Vallance [/TD][TD] 9.91 [/TD][TD] 8 [/TD][/TR]
[TR][TD] Yu Nakajima (中島悠) [/TD][TD] 9.90 [/TD][TD] 8 [/TD][/TR]
[TR][TD] Mats Valk [/TD][TD] 8.30 [/TD][TD] 7 [/TD][/TR]
[TR][TD] Yumu Tabuchi (田渕雄夢) [/TD][TD] 10.38 [/TD][TD] 7 [/TD][/TR]
[TR][TD] Dan Cohen [/TD][TD] 11.33 [/TD][TD] 7 [/TD][/TR]
[TR][TD] Syuhei Omura (大村周平) [/TD][TD] 12.33 [/TD][TD] 7 [/TD][/TR]
[TR][TD] Kanneti Sae Han (คันธ์เนตี แซ่ห่าน) [/TD][TD] 10.21 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Paolo Moriello [/TD][TD] 9.72 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Phillip Espinoza [/TD][TD] 12.93 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Milán Baticz [/TD][TD] 12.33 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Michał Halczuk [/TD][TD] 12.96 [/TD][TD] 6 [/TD][/TR]
[TR][TD] Feliks Zemdegs [/TD][TD] 9.25 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Cornelius Dieckmann [/TD][TD] 10.00 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Robert Yau [/TD][TD] 10.50 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Sebastian Weyer [/TD][TD] 11.30 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Vincent Hartanto Utomo [/TD][TD] 9.77 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Anthony Brooks [/TD][TD] 9.52 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Michał Pleskowicz [/TD][TD] 9.27 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Sergey Ryabko [/TD][TD] 9.66 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Andrew Ricci [/TD][TD] 9.56 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Arifumi Fushimi (伏見有史) [/TD][TD] 10.38 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Gabriel Dechichi Barbar [/TD][TD] 11.00 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Stefan Huber [/TD][TD] 10.13 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Harris Chan [/TD][TD] 11.00 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Thompson Clarke [/TD][TD] 11.88 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Kevin Costello III [/TD][TD] 10.15 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Edward Lin [/TD][TD] 11.06 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Andy Tsao [/TD][TD] 10.83 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Christopher Olson [/TD][TD] 11.61 [/TD][TD] 5 [/TD][/TR]
[TR][TD] James Hamory [/TD][TD] 10.40 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Leon Schmidtchen [/TD][TD] 10.52 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Simon Westlund [/TD][TD] 12.34 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Weixing Zhang (张炜星) [/TD][TD] 11.71 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Jan Smarschevski [/TD][TD] 10.06 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Mitsuki Gunji (郡司光貴) [/TD][TD] 11.31 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Nikolay Evdokimov [/TD][TD] 12.77 [/TD][TD] 5 [/TD][/TR]
[TR][TD] Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์) [/TD][TD] 9.15 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Haowei Fan (樊浩玮) [/TD][TD] 11.77 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Piti Pichedpan (ปิติ พิเชษฐพันธ์) [/TD][TD] 13.65 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Asia Konvittayayotin (เอเชีย กรวิทย์โยธิน) [/TD][TD] 9.63 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Giovanni Contardi [/TD][TD] 9.31 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Carlos Méndez García-Barroso [/TD][TD] 10.36 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Morten Arborg [/TD][TD] 8.69 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Ivan Vynnyk (Іван Винник) [/TD][TD] 10.28 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Philipp Weyer [/TD][TD] 9.38 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Lucas Etter [/TD][TD] 13.50 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Justin Adsuara [/TD][TD] 11.41 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Xiaolin Zeng (曾小林) [/TD][TD] 9.77 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Hendry Cahyadi [/TD][TD] 10.18 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Marcin Zalewski [/TD][TD] 10.02 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Eric Limeback [/TD][TD] 10.27 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Yinghao Wang (王鹰豪) [/TD][TD] 11.02 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Ravi Fernando [/TD][TD] 10.27 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Mulun Yin (阴目仑) [/TD][TD] 11.83 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Howard Wong Jun Yen (黄俊仁) [/TD][TD] 12.06 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Justin Mallari [/TD][TD] 10.27 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Kirt Protacio [/TD][TD] 11.68 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Emily Wang [/TD][TD] 11.55 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Collin Burns [/TD][TD] 9.91 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Moritz Patzelt [/TD][TD] 10.83 [/TD][TD] 4 [/TD][/TR]
[TR][TD] Alexander Lau [/TD][TD] 7.69 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Richard Jay S. Apagar [/TD][TD] 9.03 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Dario Roa Sánchez [/TD][TD] 9.46 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jr-Wei Jang (張智瑋) [/TD][TD] 12.13 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Kevin Hays [/TD][TD] 10.33 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Daniil Lee [/TD][TD] 11.00 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Kailong Li (李开隆) [/TD][TD] 9.59 [/TD][TD] 3 [/TD][/TR]
[TR][TD] I-Fan Wu (吳亦凡) [/TD][TD] 10.72 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Przemysław Kaleta [/TD][TD] 9.91 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Zhouheng Sun (孙舟横) [/TD][TD] 9.63 [/TD][TD] 3 [/TD][/TR]
[TR][TD] SeungBeom Cho [/TD][TD] 10.69 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Austin Moore [/TD][TD] 10.19 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jong-Ho Jeong (정종호) [/TD][TD] 10.36 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jakub Kipa [/TD][TD] 9.25 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Yongting You (尤永庭) [/TD][TD] 10.66 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Andy Smith [/TD][TD] 9.47 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Yi-Heng Lee (李宜衡) [/TD][TD] 9.93 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jonathan Tan Wei Xiat [/TD][TD] 11.88 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Francis Wong Jia Yen [/TD][TD] 11.41 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Leong Wing Sik [/TD][TD] 10.47 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Riley Woo [/TD][TD] 10.61 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Waris Ali [/TD][TD] 11.00 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Joar Mellström [/TD][TD] 10.77 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Teo Kai Xiang [/TD][TD] 10.97 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Jure Gregorc [/TD][TD] 10.91 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Durben Joun Virtucio [/TD][TD] 10.68 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Andrew Sopchak [/TD][TD] 10.66 [/TD][TD] 3 [/TD][/TR]
[TR][TD] Thanaporn Sichanugrist (ธนพร สิชฌนุกฤษฎ์) [/TD][TD] 10.08 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Bill Wang [/TD][TD] 8.80 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Drew Brads [/TD][TD] 10.40 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Sei Sugama (洲鎌星) [/TD][TD] 9.28 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Kaijun Lin (林恺俊) [/TD][TD] 11.31 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Harald Stiff [/TD][TD] 9.68 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی) [/TD][TD] 8.28 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Sungho Hong (홍성호) [/TD][TD] 10.58 [/TD][TD] 2 [/TD][/TR]
[TR][TD] Congbiao Jiang (蒋丛骉) [/TD][TD] 11.55 [/TD][TD] 2 [/TD][/TR]
[/TABLE]

i hated the 10.02 curse. I got them so often in the past, but not lately

also just noticed, i have 9.38 9 times

 

[Stefan]

i hated the 10.02 curse

Ha, yeah, I had noticed that, but also that the first time you got 10.02, you also got 8.72 NAR in the next round in the same competition. So it's not like you were sooo close to sub10 for a long time. Just a few hours. And by the time you got 10.02 again, your best-of-round was regularly sub10 already.

 

[ThomasJE]

Could I please have the highest and lowest ratios for the following:

3x3 OH : 3x3
3x3 BLD : 3x3
3x3 Feet : 3x3
4x4 BLD : 4x4
5x5 BLD : 5x5

All averages (except BLD of course)

 

[Robert-Y]

Who's who

I think some of them might be the same person.
For example:
Compare https://www.worldcubeassociation.org/results/p.php?i=2013JASI03, with https://www.worldcubeassociation.org/results/p.php?i=2013JASI04
It seems that he has improved in all the events that he took part in, at SLS Jastrzebie 2013. (Except for 3x3x3)

But anyway, cool statistic

 

[Kian]

Ok that took about 41 seconds and I'm not exactly proud of my ugly solution.

Erik got his 3.43 in four different events. Too busy to look for that in general now...

(my database is from last week, so might not be entirely correct now)

Spoiler: Most frequent times by competitor

[TABLE="class:grid,align:left"]
[TR][TD]name[/TD][TD]time[/TD][TD]number_of_times[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD="align:right"]1.31[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Takao Hashimoto (橋本貴夫)[/TD][TD="align:right"]1.21[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD="align:right"]3.43[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Yohei Oka (岡要平)[/TD][TD="align:right"]1.22[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Marcin Jakubowski[/TD][TD="align:right"]0.94[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD="align:right"]1.59[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Henrik Buus Aagaard[/TD][TD="align:right"]1.03[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD="align:right"]5.96[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Gaël Dusser[/TD][TD="align:right"]1.47[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Bence Barát[/TD][TD="align:right"]1.19[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Piotr Michał Padlewski[/TD][TD="align:right"]1.19[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Quentin Lefebvre[/TD][TD="align:right"]1.18[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]10.02[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD="align:right"]1.59[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD="align:right"]15.72[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Kian Barry[/TD][TD="align:right"]5.72[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]François Courtès[/TD][TD="align:right"]5.43[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Timothy Sun[/TD][TD="align:right"]3.86[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Dániel Varga[/TD][TD="align:right"]3.63[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Justin Jaffray[/TD][TD="align:right"]3.38[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD="align:right"]1.88[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Javier Tirado Ortiz[/TD][TD="align:right"]1.25[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Filippo Brancaleoni[/TD][TD="align:right"]1.02[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Yuxuan Wang (王宇轩)[/TD][TD="align:right"]0.86[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Gunnar Krig[/TD][TD="align:right"]13.50[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD="align:right"]13.16[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD="align:right"]10.81[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Yu Sajima (佐島優)[/TD][TD="align:right"]10.44[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]8.30[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Brúnó Bereczki[/TD][TD="align:right"]5.28[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Pau Vela García[/TD][TD="align:right"]4.34[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Jan Bentlage[/TD][TD="align:right"]4.08[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD="align:right"]3.94[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Anthony Searle[/TD][TD="align:right"]3.05[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Anthony Brooks[/TD][TD="align:right"]3.05[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Sanio Kasumovic[/TD][TD="align:right"]2.44[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Jaclyn Sawler[/TD][TD="align:right"]1.71[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD="align:right"]1.27[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Takuya Furukawa (古河拓也)[/TD][TD="align:right"]1.25[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Marek Padlewski[/TD][TD="align:right"]1.22[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Ting Sheng Bao Yang[/TD][TD="align:right"]1.02[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]15.09[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Michael Röhrer[/TD][TD="align:right"]14.13[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Dan Dzoan[/TD][TD="align:right"]14.06[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD="align:right"]10.43[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Yu Nakajima (中島悠)[/TD][TD="align:right"]9.90[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Zoé de Moffarts[/TD][TD="align:right"]7.96[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Dmitry Kryuzban[/TD][TD="align:right"]4.30[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD="align:right"]4.05[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Oscar Roth Andersen[/TD][TD="align:right"]3.84[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Olivier Polspoel[/TD][TD="align:right"]1.63[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Gilles van den Peereboom[/TD][TD="align:right"]1.33[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Ryan Jew[/TD][TD="align:right"]1.16[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Samuel Chiu[/TD][TD="align:right"]1.06[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Korneliusz Tombarkiewicz[/TD][TD="align:right"]1.05[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD="align:right"]1.02[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Chau Ka Wai (周嘉偉)[/TD][TD="align:right"]1.00[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]David Calvo Vivas[/TD][TD="align:right"]16.28[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Leyan Lo[/TD][TD="align:right"]15.50[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Robin Blöhm[/TD][TD="align:right"]15.30[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Lorenzo Vigani Poli[/TD][TD="align:right"]14.58[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]14.43[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD="align:right"]14.13[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD="align:right"]13.71[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Fabian Auroux[/TD][TD="align:right"]13.63[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Lucas Garron[/TD][TD="align:right"]13.36[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Edouard Chambon[/TD][TD="align:right"]13.03[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Michał Halczuk[/TD][TD="align:right"]12.96[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Rama Temmink[/TD][TD="align:right"]12.86[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Adam Polkowski[/TD][TD="align:right"]12.66[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Syuhei Omura (大村周平)[/TD][TD="align:right"]12.33[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Pedro Santos Guimarães[/TD][TD="align:right"]11.41[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Björn Korbanka[/TD][TD="align:right"]10.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Yumu Tabuchi (田渕雄夢)[/TD][TD="align:right"]10.38[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Louis Cormier[/TD][TD="align:right"]10.21[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Paolo Moriello[/TD][TD="align:right"]9.97[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Robert Yau[/TD][TD="align:right"]9.28[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Michał Pleskowicz[/TD][TD="align:right"]9.27[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD="align:right"]8.33[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]7.13[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Owidiusz Pryk[/TD][TD="align:right"]5.71[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Riadi Arsandi[/TD][TD="align:right"]4.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Thom Barlow[/TD][TD="align:right"]4.03[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Thompson Clarke[/TD][TD="align:right"]3.96[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Antoine Cantin[/TD][TD="align:right"]3.84[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Philippe Virouleau[/TD][TD="align:right"]3.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Piotr Kózka[/TD][TD="align:right"]3.63[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kirk Nicklaus Manibuy[/TD][TD="align:right"]3.41[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Maarten Smit[/TD][TD="align:right"]3.27[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Steven Turner[/TD][TD="align:right"]2.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Máté Horváth[/TD][TD="align:right"]2.18[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Ernie Pulchny[/TD][TD="align:right"]1.81[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Rafał Studnicki[/TD][TD="align:right"]1.68[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Markus Pirzer[/TD][TD="align:right"]1.58[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kirstine Buus Aagaard[/TD][TD="align:right"]1.38[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Takuma Shirahase (白波瀬拓磨)[/TD][TD="align:right"]1.36[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kalina Brzezińska[/TD][TD="align:right"]1.27[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Fubo Wang (王富博)[/TD][TD="align:right"]1.09[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Ge Song (宋鸽)[/TD][TD="align:right"]1.02[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Chan Tak Chuen (陳德泉)[/TD][TD="align:right"]1.02[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD="align:right"]19.71[/TD][TD="align:right"]6[/TD][/TR]
[/TABLE]

Spoiler: SQL code

select Persons.name, round(foo%(100*60*60*10)/100,2) time, floor(foo/(100*60*60*10)) number_of_times from (
select personId, max(number_of_times*100*60*60*10+v) foo from(
select personId, v, count(*) number_of_times from(
select personId, value1 v from Results join Events on Events.id=eventId where Events.format='time' and value1>0 union all
select personId, value2 v from Results join Events on Events.id=eventId where Events.format='time' and value2>0 union all
select personId, value3 v from Results join Events on Events.id=eventId where Events.format='time' and value3>0 union all
select personId, value4 v from Results join Events on Events.id=eventId where Events.format='time' and value4>0 union all
select personId, value5 v from Results join Events on Events.id=eventId where Events.format='time' and value5>0) tmp
group by personId, v) tmp2
group by personId
order by foo desc
limit 100) tmp3 join Persons on Persons.id=personId;

I think magic results are dominating this table (for obvious reasons). Could you produce a table with only current events?

 

[Stefan]

I think magic results are dominating this table (for obvious reasons). Could you produce a table with only current events?

Spoiler: Most frequent times by competitor (only current events)

[TABLE="class:grid,align:left"]
[TR][TD]name[/TD][TD]time[/TD][TD]number_of_times[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD="align:right"]11.30[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]10.02[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD="align:right"]16.18[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD="align:right"]15.72[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD="align:right"]12.66[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD="align:right"]6.40[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Kian Barry[/TD][TD="align:right"]5.72[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]François Courtès[/TD][TD="align:right"]5.43[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Timothy Sun[/TD][TD="align:right"]3.86[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Justin Jaffray[/TD][TD="align:right"]3.38[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD="align:right"]18.94[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Gunnar Krig[/TD][TD="align:right"]13.50[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD="align:right"]13.16[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD="align:right"]10.81[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Yu Sajima (佐島優)[/TD][TD="align:right"]10.44[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Brúnó Bereczki[/TD][TD="align:right"]5.28[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Anthony Brooks[/TD][TD="align:right"]3.05[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]15.09[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Piotr Michał Padlewski[/TD][TD="align:right"]14.61[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Michael Röhrer[/TD][TD="align:right"]14.13[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Dan Dzoan[/TD][TD="align:right"]14.06[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Yohei Oka (岡要平)[/TD][TD="align:right"]11.80[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD="align:right"]10.43[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Yu Nakajima (中島悠)[/TD][TD="align:right"]9.90[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]8.30[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Zoé de Moffarts[/TD][TD="align:right"]7.96[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Oscar Roth Andersen[/TD][TD="align:right"]3.84[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Marcin Jakubowski[/TD][TD="align:right"]3.61[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]David Calvo Vivas[/TD][TD="align:right"]16.28[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Filippo Brancaleoni[/TD][TD="align:right"]15.55[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Leyan Lo[/TD][TD="align:right"]15.50[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Robin Blöhm[/TD][TD="align:right"]15.30[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Lorenzo Vigani Poli[/TD][TD="align:right"]14.58[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Nobuaki Suga (菅信昭)[/TD][TD="align:right"]14.43[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD="align:right"]14.13[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Bence Barát[/TD][TD="align:right"]13.71[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD="align:right"]13.71[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Fabian Auroux[/TD][TD="align:right"]13.63[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Lucas Garron[/TD][TD="align:right"]13.36[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Edouard Chambon[/TD][TD="align:right"]13.03[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Michał Halczuk[/TD][TD="align:right"]12.96[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Rama Temmink[/TD][TD="align:right"]12.86[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Adam Polkowski[/TD][TD="align:right"]12.66[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD="align:right"]12.55[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Syuhei Omura (大村周平)[/TD][TD="align:right"]12.33[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Pedro Santos Guimarães[/TD][TD="align:right"]11.41[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD="align:right"]11.33[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Björn Korbanka[/TD][TD="align:right"]10.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Yumu Tabuchi (田渕雄夢)[/TD][TD="align:right"]10.38[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Louis Cormier[/TD][TD="align:right"]10.21[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Robert Yau[/TD][TD="align:right"]9.28[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Michał Pleskowicz[/TD][TD="align:right"]9.27[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Laura Ohrndorf[/TD][TD="align:right"]8.33[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Jan Bentlage[/TD][TD="align:right"]7.34[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Javier Tirado Ortiz[/TD][TD="align:right"]6.93[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Paolo Moriello[/TD][TD="align:right"]5.13[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Riadi Arsandi[/TD][TD="align:right"]4.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Henrik Buus Aagaard[/TD][TD="align:right"]4.21[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Thompson Clarke[/TD][TD="align:right"]3.96[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Philippe Virouleau[/TD][TD="align:right"]3.80[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Piotr Kózka[/TD][TD="align:right"]3.63[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Ting Sheng Bao Yang[/TD][TD="align:right"]3.58[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD="align:right"]20.72[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]20.53[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD="align:right"]19.71[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Dave Campbell[/TD][TD="align:right"]17.69[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Jakub Cabaj[/TD][TD="align:right"]17.09[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Devin Corr-Robinett[/TD][TD="align:right"]16.71[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Gilles Roux[/TD][TD="align:right"]15.22[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Dániel Varga[/TD][TD="align:right"]14.94[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Chester Lian[/TD][TD="align:right"]14.53[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]John Tamanas[/TD][TD="align:right"]13.91[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Kalina Brzezińska[/TD][TD="align:right"]13.36[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Piotr Frankowski[/TD][TD="align:right"]13.30[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Lasse Korbanka[/TD][TD="align:right"]13.21[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Simon Lim[/TD][TD="align:right"]13.15[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]James Donahue[/TD][TD="align:right"]13.15[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Joël van Noort[/TD][TD="align:right"]12.96[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Phillip Espinoza[/TD][TD="align:right"]12.93[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD="align:right"]12.78[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Simon Westlund[/TD][TD="align:right"]12.34[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Hippolyte Moreau[/TD][TD="align:right"]12.18[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)[/TD][TD="align:right"]12.18[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Moritz Karl[/TD][TD="align:right"]12.09[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Maximilian Neitzel[/TD][TD="align:right"]12.05[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Cameron Brown[/TD][TD="align:right"]12.03[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]John Brechon[/TD][TD="align:right"]11.46[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Antoine Piau[/TD][TD="align:right"]11.41[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Riccardo Simone[/TD][TD="align:right"]11.40[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Sebastian Weyer[/TD][TD="align:right"]11.30[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Daniel Gloppestad Bajer[/TD][TD="align:right"]11.30[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Andrew Ricci[/TD][TD="align:right"]10.96[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Leon Schmidtchen[/TD][TD="align:right"]10.52[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]James Hamory[/TD][TD="align:right"]10.40[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Arifumi Fushimi (伏見有史)[/TD][TD="align:right"]10.38[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Jesús Masanet García[/TD][TD="align:right"]10.03[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Philipp Weyer[/TD][TD="align:right"]10.00[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Laetitia Lemoine[/TD][TD="align:right"]9.40[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Krzysztof Kuncki[/TD][TD="align:right"]7.69[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Pierre Bouvier[/TD][TD="align:right"]7.46[/TD][TD="align:right"]6[/TD][/TR]
[/TABLE]

Spoiler: SQL code

select Persons.name, round(foo%(100*60*60*10)/100,2) time, floor(foo/(100*60*60*10)) number_of_times from (
select personId, max(number_of_times*100*60*60*10+v) foo from(
select personId, v, count(*) number_of_times from(
select personId, value1 v from Results join Events on Events.id=eventId where Events.format='time' and Events.rank<990 and value1>0 union all
select personId, value2 v from Results join Events on Events.id=eventId where Events.format='time' and Events.rank<990 and value2>0 union all
select personId, value3 v from Results join Events on Events.id=eventId where Events.format='time' and Events.rank<990 and value3>0 union all
select personId, value4 v from Results join Events on Events.id=eventId where Events.format='time' and Events.rank<990 and value4>0 union all
select personId, value5 v from Results join Events on Events.id=eventId where Events.format='time' and Events.rank<990 and value5>0) tmp
group by personId, v) tmp2
group by personId
order by foo desc
limit 100) tmp3 join Persons on Persons.id=personId
where subId=1;