Top100 3x3 avg. is now sub10!

The craziest thing for me is the "unbeatable" 7.08, is soon to drop out of the top 100 single results. Another Mats or Feliks competition would likely get it out.

Let's see...

It's currently at place 86.
At WC2013, Feliks had four sub-7.08 solves (Mats had one).
Similar at other competitons (he seems to get about one sub-7.08 per round).
Most competitions have 2-3 rounds, none have more than four.

=> No.
 
Last edited:
More about 7.08 dropping out of the top 100:

[TABLE="class:grid,align:left"]
[TR][TD]year[/TD][TD]month[/TD][TD]sub708s[/TD][TD]noFazOrMats[/TD][TD]who[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]11[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD]Feliks Zemdegs, Rowe Hessler[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD]Feliks Zemdegs[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]5[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Feliks Zemdegs[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]6[/TD][TD="align:right"]4[/TD][TD="align:right"]0[/TD][TD]Feliks Zemdegs[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]8[/TD][TD="align:right"]3[/TD][TD="align:right"]2[/TD][TD]Feliks Zemdegs, Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์), Che-Ting Chu (朱哲廷)[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]10[/TD][TD="align:right"]3[/TD][TD="align:right"]1[/TD][TD]Mats Valk, Anthony Brooks[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]11[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD]Feliks Zemdegs, Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]1[/TD][TD="align:right"]4[/TD][TD="align:right"]4[/TD][TD]Asia Konvittayayotin (เอเชีย กรวิทย์โยธิน), Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์), Stephen Adhisaputra, Rowe Hessler[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]2[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD]Mats Valk, Feliks Zemdegs, Mitsuki Gunji (郡司光貴), Cornelius Dieckmann[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD]Michał Pleskowicz, Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]5[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD]Cornelius Dieckmann, Michał Pleskowicz[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]6[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD]Arifumi Fushimi (伏見有史)[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]7[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD]Milán Baticz[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]8[/TD][TD="align:right"]3[/TD][TD="align:right"]2[/TD][TD]Yumu Tabuchi (田渕雄夢), Andrew Ricci, Mats Valk[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]9[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Feliks Zemdegs, Mats Valk[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]10[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD]Mats Valk[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]11[/TD][TD="align:right"]7[/TD][TD="align:right"]1[/TD][TD]Feliks Zemdegs, Mats Valk, Sebastian Weyer[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]12[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD]Giovanni Contardi, Cornelius Dieckmann[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD]Alexander Lau[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]3[/TD][TD="align:right"]3[/TD][TD="align:right"]2[/TD][TD]Mats Valk, Sergey Ryabko, Vincent Hartanto Utomo[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD]Yu Nakajima (中島悠), Mulun Yin (阴目仑)[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]5[/TD][TD="align:right"]4[/TD][TD="align:right"]0[/TD][TD]Feliks Zemdegs[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]6[/TD][TD="align:right"]6[/TD][TD="align:right"]3[/TD][TD]Feliks Zemdegs, Alexander Lau, Mats Valk[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]7[/TD][TD="align:right"]10[/TD][TD="align:right"]5[/TD][TD]Feliks Zemdegs, Wataru Hashimura (端村航), Richard Jay S. Apagar, Mats Valk, Cornelius Dieckmann, Yinqin Li (李尹钦), Kevin Hays[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]8[/TD][TD="align:right"]6[/TD][TD="align:right"]6[/TD][TD]Mitchell Lane, Alexander Lau, Yi-Heng Lee (李宜衡), Sergey Ryabko, Robert Yau, Kevin Costello III[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]9[/TD][TD="align:right"]4[/TD][TD="align:right"]1[/TD][TD]Feliks Zemdegs, Kirt Protacio[/TD][/TR]
[/TABLE]
SELECT year, month, sum((value1 between 1 and 707)+(value2 between 1 and 707)+(value3 between 1 and 707)+(value4 between 1 and 707)+(value5 between 1 and 707)) sub708s,
sum(((value1 between 1 and 707)+(value2 between 1 and 707)+(value3 between 1 and 707)+(value4 between 1 and 707)+(value5 between 1 and 707))*(personId not in ('2009ZEMD01', '2007VALK01'))) noFazOrMats,
group_concat(distinct personName separator ', ') who
FROM Results, Competitions
WHERE Competitions.id = competitionId
AND eventId = '333' AND best between 1 and 707
GROUP BY year, month
 
Last edited:
Back
Top