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