• Welcome to SpeedSolving.com — the world’s largest puzzle community!

    You’re currently browsing as a guest, which means you have limited access to discussions, resources, member profiles, and community features.

    Join 50,000+ cubers and puzzle enthusiasts from around the world to ask questions, share solves, improve faster, and be part of the community.

    Registration is free, fast, and easy — create your account today.

    Already a member? Log in here to hide this message and start participating.

Odd WCA stats/ Stats request Thread

Damn, my 43rd competition was a smal one only featuring 3x3x3 and OH. ;)

Thanks for this list. I'd still like to see the code though. :D
 
Sebastien said:
wait....WHAT?! I have never searched for such a streak myself but I have always been under the impression that I only set competition PBs quite rarely. If you had asked me about the longest streak for me, I would have estimated something like 5. :D

Could you share the code you used to generate that list? And could you possibly include first and last competition of thoses streaks?
Click to expand...

I confirm Tim's results if "personal best" means "new personal best" (btw, those top 17 places are exactly the same if you allow streaks not starting with the first competition).

Code: 
Mats Valk               47 (ended at AmstelveenOpen2012)
Sébastien Auroux        42 (ended at GHSIngenhovenparkOpen2011)
Tim Reynolds            41 (ended at MITFall2010)
Bence Barát             39 (ended at ZonhovenOpen2012)
Milán Baticz            39 (ended at RomanianOpen2012)
Gaël Dusser             38 (ended at RubikkuChamp2012)
Jan Bentlage            38 (ended at HessenOpen2013)
Mike Hughey             38 (ended at DixonSummer2013)
Wojciech Szatanowski    38 (ended at PoznanOpen2014)
Geert Bicler            37 (ended at HEMMariCubikOpen2013)
Thompson Clarke         37 (ongoing)
Daniel Sheppard         36 (ended at Euro2014)
Evan Liu                36 (ongoing)
Kevin Costello III      36 (ongoing)
Christopher Olson       35 (ongoing)
Kit Clement             34 (ongoing)
Michael Röhrer          34 (ended at MunichOpen2013)
Brúnó Bereczki          33 (ended at GELOpen2012)
Dan Dzoan               33 (ended at BerkeleyFall2009)
Hunor Bózsing           33 (ongoing)
Javier Tirado Ortiz     33 (ended at DualGames2013)
Mike Kotch              33 (ended at WC2013)
Nathan Dwyer            33 (ongoing)
Ryohei Yoshioka         32 (ended at KansaiOpen2014)
Niklas Spies            31 (ended at AachenSummer2012)
Yumu Tabuchi            31 (ended at UTOpen2013)
Corey Sakowski          30 (ended at Newark2013)
Edward Lin              30 (ended at CalDay2012)
Henrik Buus Aagaard     30 (ended at VejstrupOpen2011)
Tomoaki Okayama         30 (ended at JapanOpen2012)
Jakub Cabaj             29 (ended at SilesiaOpen2012)
Kai Jiptner             29 (ended at ErfurtOpen2013)
Krzysztof Kuncki        29 (ended at RadomOpen2013)
Louis Cormier           29 (ongoing)
Marcin Jakubowski       29 (ended at CzechOpen2011)
Michael Gottlieb        29 (ongoing)
Łukasz Cichecki         29 (ongoing)
Bertalan Bodor          28 (ongoing)
Ernie Pulchny           28 (ended at YaleSpring2013)
Przemysław Kaleta       28 (ended at KielceCubeAttack2014)
Robert Yau              28 (ongoing)
Sanio Kasumovic         28 (ended at GELOpen2012)
Simon Westlund          28 (ongoing)
Ting Sheng Bao Yang     28 (ongoing)
Dániel Varga            27 (ended at DutchOpen2011)
Edouard Chambon         27 (ended at SwissOpen2009)
Jean-Louis Mathieu      27 (ended at FrenchOpen2010)
John Brechon            27 (ended at DixonWinter2013)
Maarten Smit            27 (ended at AmstelveenOpen2013)
Mariano D'Imperio       27 (ongoing)
Tobias Droste           27 (ongoing)
Zach Goldman            27 (ended at CCFCFall2013)
Brandon Mikel           26 (ended at IowaCornLovers2014)
Chia-Liang Tai          26 (ended at CrossstraitCubing2014)
Chunyu Zhang 2          26 (ongoing)
Erik Akkersdijk         26 (ended at Netherlands2008)
Julian David            26 (ongoing)
Marco Rota              26 (ongoing)
Sebastian Weyer         26 (ongoing)
Vincent Hartanto Utomo  26 (ongoing)
Yuuki Kobayashi         26 (ongoing)
Artur Kristof           25 (ended at PoznanOpen2014)
Björn Korbanka          25 (ended at Euro2012)
Everett Kelly           25 (ended at NiseiWeek2014)
Fubo Wang               25 (ended at BUAAOpen2013)
Joey Gouly              25 (ended at UKNationals2010)
Kanneti Sae Han         25 (ended at FrenchOpen2011)
Kåre Krig               25 (ended at KarlstadOpen2010)
Michał Pleskowicz       25 (ended at ManufakturaOpen2013)
Olivér Perge            25 (ended at ObeiObeiOpen2009)
Rafael Werneck Cinoto   25 (ended at AmericanaOpen2012)
Tim Habermaas           25 (ended at Euro2012)
Tim Wong                25 (ended at NiseiWeek2014)
Code: 
import mysql.connector
from itertools import groupby
from operator import itemgetter

# Connect to the database
cnx = mysql.connector.connect(host='localhost', database='wca_export', user='wca_export', password='XXX')
cursor = cnx.cursor()

# Get the raw data
cursor.execute('''
SELECT personId, competitionId, eventId, best, average, personName
FROM Results join Competitions on Competitions.id=competitionId
ORDER BY personId, year, month, day, endMonth, endDay, competitionId, eventId, roundId''')

# Determine the streaks
streaks = []
for personId, results in groupby(cursor, itemgetter(0)):
    length = 0
    PB = {}
    for competitionId, results in groupby(results, itemgetter(1)):
        newPB = False
        for personId, competitionId, eventId, best, average, personName in results:
            for what, value in ((eventId + '_s', best), (eventId + '_a', average)):
                if value > 0 and (what not in PB or value < PB[what]):
                    newPB = True
                    PB[what] = value
        if not newPB:
            break
        length += 1
    if length >= 25:
        streaks.append((-length, personName, 'ongoing' if newPB else 'ended at ' + competitionId))

# Show the results
for length, personName, ending in sorted(streaks):
    print('{:23} {} ({})'.format(personName.split(' (')[0], -length, ending))

# Close
cursor.close()
cnx.close()
 
Last edited:
TheNextFeliks said:
How many people have been to multiple competitions but only competed in one event? Let's say min of 4 comps.
Click to expand...

257

Using data from WCA_export451_20140827 and Stefan's WCA forum statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]Pony[/TD][TD]Trick[/TD][TD]Performances[/TD][/TR]
[TR][TD]Rune Wesström[/TD][TD]Rubik's Cube[/TD][TD="align:right"]18[/TD][/TR]
[TR][TD]Michael Layher[/TD][TD]Rubik's Cube[/TD][TD="align:right"]17[/TD][/TR]
[TR][TD]Tabitha King[/TD][TD]Rubik's Cube[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Claude Cantin[/TD][TD]Rubik's Cube[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Satoshi Idekawa (出川智士)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Lauren Hanrahan[/TD][TD]Rubik's Cube[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Louise Cormier[/TD][TD]Rubik's Cube[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Filippo Bertolotti[/TD][TD]Rubik's Cube[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Pedro Miguel Pastor Gonzalvo[/TD][TD]Rubik's Cube[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Tapio Niiranen[/TD][TD]Rubik's Cube[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Chaoxu Zhang (张朝旭)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Rei Idekawa (出川怜)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Adelina Estevao[/TD][TD]Rubik's Cube[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Reese Iyer[/TD][TD]Rubik's Cube[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Douglas Muhlestein[/TD][TD]Rubik's Cube[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Julia Żygowska[/TD][TD]Rubik's Cube[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Rebecca Ladds[/TD][TD]Rubik's Cube[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Yoshio Matsumoto (松本嘉夫)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Sachi Schuricht[/TD][TD]Rubik's Cube[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Camila Rodrigues de Oliveira[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Sylviane Mathieu[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Akiko Tabuchi (田渕明子)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Wim Berkelmans[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Cary Johnson[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Kouichi Tabuchi (田渕幸一)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Márcio Luiz da Costa Freitas[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Gursharan Singh[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Leandro Fulukawa[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Gloria Hughey[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Amie Logan[/TD][TD]Rubik's Cube[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Mark White[/TD][TD]Rubik's Cube[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Eun Hee Kim[/TD][TD]Rubik's Cube[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Wenda Chen (陈闻达)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Denise Le[/TD][TD]Rubik's Cube[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Camila Lisboa de Azevedo[/TD][TD]Rubik's Cube[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Denis Goepfert[/TD][TD]Rubik's Cube[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Miles Koehler[/TD][TD]Rubik's Cube[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Yuki Nakashima (中島佑樹)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Tomoya Ide[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Eric King[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Hannah Logan[/TD][TD]Rubik's Magic[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]José Ángel Acosta[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Daiki Hashimoto (橋本大輝)[/TD][TD]Rubik's Magic[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Maria de Fatima Rebelo Correia[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Petra Uhlírová[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Emily Mertens[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Romeo Mendoza[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Mitsuko Tomoyori (友寄光子)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Junhui Chen (陈俊辉)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Widrian Budiman[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Moacir Mansano de Aguiar[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Tamie Robinett[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Yanwei Dong (董衍伟)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kazuhito Okamoto (岡本一人)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Yoshimi Tsuji[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Leithian Riggenbach[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Curt Higgins[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Tianshu Wang (王天舒)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Joe DeRubertis[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Hirokazu Hiroyama (廣山弘和)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Tysun Arsenault[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Nick Lu[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Qixuan Lin (林齐萱)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Sebastian Chen[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Alessandra Puspita Setiyanto[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Andy Camann[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Albert Muñoz Martin[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Dave Haviland[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Fabio Seiji Massui[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]María Orosia Pérez Campo[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Paul Hays[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Tomer Ovadia[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Masanori Suzuki (鈴木政範)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Yuuya Hekata (邊方裕也)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Tina Tu[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Anthony Turner[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Anaïs Bolsée[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Wilfried König[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Kaustubh Nihul[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Donna Hays[/TD][TD]Rubik's Cube[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Jason So[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Sam Ettinger[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Travis Kruse[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Dan Posey[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Eiichi Watanabe (渡辺英一)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]David Harris[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Lauren Langdon[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Sumit Sanmuganathan[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Tomomi Wati (和知友美)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Valerie Elson[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Nikita Krasnogorov[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Carlos de Souza Ribeiro[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Paisan Jaikwang (ไพศาล ใจกว้าง)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Claudio Alejandro Andrade Martinez[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Igor Massanobu Hashimoto Araujo[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Guillaume Duquenne[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Xingyue Cao (曹星悦)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Rohan Mahesh[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Maru Riggenbach[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Nobutaka Shiina (椎名信孝)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Milo Byrt[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Luana Mendieta[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Kyle Roberts[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Itsaya Jaruwattanakun (อิษยา จารุวัฒนกุล)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Xicheng Cui (崔锡诚)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Yexi Hong (洪业熙)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Monicka Manni[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Selami Çarpaner[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Anita Varga[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Yon Soo Park[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Zoltán Kada[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Yury Timoshchenko[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Stuart Lerner[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Susan Gabris[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Niko Kauffman[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Joseph Malunay[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Cory Hayashi[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Go Nishida (西田豪)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Federico Sannicolò[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Ivan Kogtikov[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Hong Liu (刘红)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Arturo Casas Arenas[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Niranjan Ramanand[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Erica Singh[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Maria Belyaeva[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Duncan Plomp[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Kirk Walton[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Carolina Oliveira da Silva[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Eric Fabre[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Kanako Ohta (太田佳那子)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Jonathan Raskind[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Jill Hubbard[/TD][TD]Pyraminx[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Nick Zamora[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Connor Berry[/TD][TD]Rubik's Magic[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Sahil Laud[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Iván Marchante Flores[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Jeremy Chong[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Paul Hendrickson[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Jason Chern[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Scott Trueblood[/TD][TD]Rubik's Cube[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Jonatas da Silva Araujo[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Sergio García[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yuexiao Li (李玥霄)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Marcos Ortiz[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Sahil Srivastava[/TD][TD]2x2 Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Selçuk Soner Akgül[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Justin Choi[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Felipe Thurler Corrêa[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yasuo Suzuki (鈴木靖夫)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]David Ezequiel Fernández[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Moez Bhatti[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Enoc Baez Molina[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Marcus Jackson[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yanira Ines Taco Valer[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Cristian Gálvez Martínez[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yingxin Zhao (赵应炘)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Shameel Abdullah[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Gary Chang[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Gang Liu (刘刚)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Delia Chou[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Jill Hiraizumi[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Abat Manguy[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Stefan Pabst[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Tao Zhang (张涛)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Tony Brock-Fisher[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Farina Götte[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Takenori Kataoka (片岡武典)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Qiao Ming Yue (乔 明月)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yash Shinde[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yuuki Tanaka (田中佑樹)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Darius Vossoughi[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Gustavo Hideki Yamada[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Jessica Fridrich[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Akihiro Kawauchi (河内章浩)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Geir Ugelstad[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Tomotsugu Yamamoto (山本智嗣)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Dmytro Volotkovskyi (Дмитро Волотковський)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Kuba Bindernagel[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Ankit Dinesh Choudhari[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Sakae Tokuda (徳田栄)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Valeriya Gaidarly[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yoav Zaidenberg[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Wenjun Liang (梁文骏)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Mayara Rodrigues Monteiro[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Hugo Hinojos-Kabata[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Victor Emanuel Oliveira Pinto[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Rafael Katsuyoshi da Costa Tateyama[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Matthew Velasquez[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Constante Marte[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yanfeng Zhu (朱艳枫)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Danny Parks[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Natalia Sanz Serrano[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Zach Dodge[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Gai Higuchi (肥口凱)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Ji-Lang Jang (張記郎)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Matthew McPherson[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Fatima Haesemeyer[/TD][TD]Rubik's Magic[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Rafid Hoda[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Beate Niediek[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Chuanxiang Sun (孙传翔)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Michael Hettenbach[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Joe Kim[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Christina Kumala[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Christa Markey[/TD][TD]Rubik's Magic[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Federico Abad[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Victor Calme[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Vanessa Espino[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Lakshmi Narasimhan[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Ying Shi (石瑛)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Victor Teves[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Carson Armstrong[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Daniel Niemann[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Brandon Blankenship[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Tejas Ranjit Shah[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Martin Berger[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Rahanik Vora[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Pavel Novák[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Andrea Johanna Ceballos Contreras[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Sara Stapelbroek[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Mohammed Eliyaz[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Art Adams Sr[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Peter Conway[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Junior Narro[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Alton Hitchcock Jr.[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yuetao Zhang (张玥涛)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yuhao Deng (邓宇豪)[/TD][TD]3x3 one-handed[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Santeri Vanhala[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Brandon Baker[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Jan Hop[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Xu-Lun Chi (池旭倫)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Nianming Hou (侯念明)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Mayu Suzuki (鈴木真由)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Yunlong Xu (许雲龙)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]George Agatep[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Jirutkom Marovya (จิรัฐคม มารวย)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Hazuki Torii (鳥居葉月)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Thomas Templier[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Jake Kirchner[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Beatriz França Castillo[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Isaac Oderberg[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Joy Wang[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Thiago de Carvalho Migliano[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Kathy Zhang[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Rubén Martín Milán[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Qijue Huang (黄启觉)[/TD][TD]Rubik's Magic[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Xiaowen Liao (廖晓文)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Tim Schumacher[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Elena Villar Venini[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Qiaochu Yuan[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Patricio Rubén Alfaro Farfán[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Lauren Janas[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Barbara Lócsi[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Jeffrey Wang[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Salvatore Bembo[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Josh Maldonado[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Kiran Shankar[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Saran Srisathon (ศรัณย์ ศรีสาธร)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]4[/TD][/TR]
[/TABLE]

SELECT personName Pony, cellName Trick, count(distinct competitionId) Performances
FROM Results join Events on Events.id=eventId
GROUP BY personId
HAVING Performances>=4 and count(distinct eventId)=1
ORDER BY Performances desc;
 
Stefan said:
I confirm Tim's results
Click to expand...

Actually I now believe he's slightly wrong, and I was as well. I edited my previous post to say that I checked for new personal bests, and here's what I think is correct.

In my list, Jakub Cabaj changes from 29 to 34 because at SilesiaOpen2012 he did match a previous personal best, and Chester Lian enters the list with 25.

Code: 
Mats Valk               47 (ended at AmstelveenOpen2012)
Sébastien Auroux        42 (ended at GHSIngenhovenparkOpen2011)
Tim Reynolds            41 (ended at MITFall2010)
Bence Barát             39 (ended at ZonhovenOpen2012)
Milán Baticz            39 (ended at RomanianOpen2012)
Gaël Dusser             38 (ended at RubikkuChamp2012)
Jan Bentlage            38 (ended at HessenOpen2013)
Mike Hughey             38 (ended at DixonSummer2013)
Wojciech Szatanowski    38 (ended at PoznanOpen2014)
Geert Bicler            37 (ended at HEMMariCubikOpen2013)
Thompson Clarke         37 (ongoing)
Daniel Sheppard         36 (ended at Euro2014)
Evan Liu                36 (ongoing)
Kevin Costello III      36 (ongoing)
Christopher Olson       35 (ongoing)
Jakub Cabaj             34 (ended at PolishOpen2013)
Kit Clement             34 (ongoing)
Michael Röhrer          34 (ended at MunichOpen2013)
Brúnó Bereczki          33 (ended at GELOpen2012)
Dan Dzoan               33 (ended at BerkeleyFall2009)
Hunor Bózsing           33 (ongoing)
Javier Tirado Ortiz     33 (ended at DualGames2013)
Mike Kotch              33 (ended at WC2013)
Nathan Dwyer            33 (ongoing)
Ryohei Yoshioka         32 (ended at KansaiOpen2014)
Niklas Spies            31 (ended at AachenSummer2012)
Yumu Tabuchi            31 (ended at UTOpen2013)
Corey Sakowski          30 (ended at Newark2013)
Edward Lin              30 (ended at CalDay2012)
Henrik Buus Aagaard     30 (ended at VejstrupOpen2011)
Tomoaki Okayama         30 (ended at JapanOpen2012)
Kai Jiptner             29 (ended at ErfurtOpen2013)
Krzysztof Kuncki        29 (ended at RadomOpen2013)
Louis Cormier           29 (ongoing)
Marcin Jakubowski       29 (ended at CzechOpen2011)
Michael Gottlieb        29 (ongoing)
Łukasz Cichecki         29 (ongoing)
Bertalan Bodor          28 (ongoing)
Ernie Pulchny           28 (ended at YaleSpring2013)
Przemysław Kaleta       28 (ended at KielceCubeAttack2014)
Robert Yau              28 (ongoing)
Sanio Kasumovic         28 (ended at GELOpen2012)
Simon Westlund          28 (ongoing)
Ting Sheng Bao Yang     28 (ongoing)
Dániel Varga            27 (ended at DutchOpen2011)
Edouard Chambon         27 (ended at SwissOpen2009)
Jean-Louis Mathieu      27 (ended at FrenchOpen2010)
John Brechon            27 (ended at DixonWinter2013)
Maarten Smit            27 (ended at AmstelveenOpen2013)
Mariano D'Imperio       27 (ongoing)
Tobias Droste           27 (ongoing)
Zach Goldman            27 (ended at CCFCFall2013)
Brandon Mikel           26 (ended at IowaCornLovers2014)
Chia-Liang Tai          26 (ended at CrossstraitCubing2014)
Chunyu Zhang 2          26 (ongoing)
Erik Akkersdijk         26 (ended at Netherlands2008)
Julian David            26 (ongoing)
Marco Rota              26 (ongoing)
Sebastian Weyer         26 (ongoing)
Vincent Hartanto Utomo  26 (ongoing)
Yuuki Kobayashi         26 (ongoing)
Artur Kristof           25 (ended at PoznanOpen2014)
Björn Korbanka          25 (ended at Euro2012)
Chester Lian            25 (ended at NewAlbany2013)
Everett Kelly           25 (ended at NiseiWeek2014)
Fubo Wang               25 (ended at BUAAOpen2013)
Joey Gouly              25 (ended at UKNationals2010)
Kanneti Sae Han         25 (ended at FrenchOpen2011)
Kåre Krig               25 (ended at KarlstadOpen2010)
Michał Pleskowicz       25 (ended at ManufakturaOpen2013)
Olivér Perge            25 (ended at ObeiObeiOpen2009)
Rafael Werneck Cinoto   25 (ended at AmericanaOpen2012)
Tim Habermaas           25 (ended at Euro2012)
Tim Wong                25 (ended at NiseiWeek2014)
Code: 
import mysql.connector
from itertools import groupby
from operator import itemgetter

# Connect to the database
cnx = mysql.connector.connect(host='localhost', database='wca_export', user='wca_export', password='XXX')
cursor = cnx.cursor()

# Get the raw data
cursor.execute('''
SELECT personId, competitionId, eventId, best, average, personName
FROM Results join Competitions on Competitions.id=competitionId
ORDER BY personId, year, month, day, endMonth, endDay, competitionId, eventId, roundId''')

# Determine the streaks
streaks = []
for personId, results in groupby(cursor, itemgetter(0)):
    length = 0
    PB = {}
    for competitionId, results in groupby(results, itemgetter(1)):
        withPB = False
        for personId, competitionId, eventId, best, average, personName in results:
            for what, value in ((eventId + '_s', best), (eventId + '_a', average)):
                if value > 0 and (what not in PB or value <= PB[what]):
                    withPB = True
                    PB[what] = value
        if not withPB:
            break
        length += 1
    if length >= 25:
        streaks.append((-length, personName, 'ongoing' if withPB else 'ended at ' + competitionId))

# Show the results
for length, personName, ending in sorted(streaks):
    print('{:23} {} ({})'.format(personName.split(' (')[0], -length, ending))

# Close
cursor.close()
cnx.close()
 
I'm surprised. It's already quite rare to succeed in just 3BLD, 4BLD and 5BLD at first try. Only four people have done so:

2007-07-14 István Kocza
2011-08-12 Stefan Pochmann
2011-10-22 Habibi
2012-11-03 Nevins Chan Pak Hoong (陈百鸿)

All of us also succeeded at our first multiblind, and István and me also at our first old style multiblind (didn't exist anymore for the others).

However, I realized I didn't succeed at my first (and only) possibly somewhat official speedblind attempt. It was at Euro 2006 and I don't remember how official it was.

Code: 
[noparse]import mysql.connector
from collections import defaultdict

# Connect to the database
cnx = mysql.connector.connect(host='localhost', database='wca_export', user='wca_export', password='XXX')
cursor = cnx.cursor()

# Get the raw data
cursor.execute('''
SELECT personId, personName, eventId, date(year*10000+month*100+day), value1, value2, value3, value4, value5
FROM Results join Competitions on Competitions.id=competitionId join Rounds on Rounds.id=roundId
WHERE eventId in ('333bf', '444bf', '555bf')
ORDER BY year, month, day, endMonth, endDay, Rounds.rank''')

# Dance
successes = defaultdict(set)
fails = defaultdict(set)
for personId, personName, eventId, date, *values in cursor:
    for v in values:
        if (v > 0 or v == -1) and eventId not in successes[personId] | fails[personId]:
            (successes[personId] if v > 0 else fails[personId]).add(eventId)
            if len(successes[personId]) == 3:
                link = '[url=https://www.worldcubeassociation.org/results/p.php?i={}]{}[/url]'.format(personId, personName)
                print(date, link)

# Close
cursor.close()
cnx.close()
[/noparse]
 
Last edited:
CyanSandwich said:
Curious, why did you not try 4BLD until 2011?
Click to expand...

I'm slow and thus almost never did big cube BLD. At Euro 2004 I basically had the choice between 4BLD and 5BLD and chose the latter because Dror and Richard were way faster than me and had two chances at 4BLD and so I thought my only chance to win something and set a world record was to go for 5BLD. At Worlds 2005 I might have had the same strategy, don't remember. And the next time I did any big cube BLD, I did them both.
 
Stefan said:
I'm slow and thus almost never did big cube BLD. At Euro 2004 I basically had the choice between 4BLD and 5BLD and chose the latter because Dror and Richard were way faster than me and had two chances at 4BLD and so I thought my only chance to win something and set a world record was to go for 5BLD. At Worlds 2005 I might have had the same strategy, don't remember. And the next time I did any big cube BLD, I did them both.
Click to expand...
Oh that makes sense. Thanks!
 
I wonder how many had succesful multi blind before they got a single 3BLD? I know I did by the old style multi, but I'm guessing its rare.

EDIT: I just thought that it might not be that rare, that someone got 1/2, but maybe that could be excluded?
 
Last edited:
LarsN said:
I wonder how many had succesful multi blind before they got a single 3BLD? I know I did by the old style multi, but I'm guessing its rare.

EDIT: I just thought that it might not be that rare, that someone got 1/2, but maybe that could be excluded?
Click to expand...

At my first comp I got 5/7 multi but DNFed my 3BLD attempts. Don't know whether I should put a ":)" or a ":(" here.
 
You must log in or register to reply here.

Similar threads

Minetoucubing
Odd or fake QJ megaminx?
Replies
0
Views
186
Minetoucubing
Minetoucubing
MrCubert
SS Oddballs Redemption 2026
Replies
2
Views
431
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
483
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,039
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,500
Discomantis
Discomantis
Back
Top