Bob
Premium Member
Last export was today I think.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Since it seems as though magic and master magic will be removed, I would like to request a table of the top 100 for sum of single ranks and average ranks, excluding magic and master magic of course. Also would it be possible to list each individual rank as well? Thanks
I bet more people worldwide enjoy magic over pyraminx!
4561 Rubik's Cube
2899 2x2 Cube
2158 4x4 Cube
2051 Rubik's Cube: One-handed
[COLOR="#FF0000"]1440 Pyraminx
1373 Rubik's Magic[/COLOR]
1363 5x5 Cube
845 Rubik's Cube: Blindfolded
731 Master Magic
636 Megaminx
534 Rubik's Cube: Fewest moves
498 6x6 Cube
434 Square-1
425 Rubik's Clock
400 7x7 Cube
279 Rubik's Cube: Multiple Blindfolded
196 Rubik's Cube: With feet
109 4x4 Cube: Blindfolded
50 5x5 Cube: Blindfolded
SELECT count(distinct personId) participants, Events.name
FROM Results, Competitions, Events
WHERE Competitions.id=competitionId AND year=2012 AND Events.id=eventId
GROUP BY eventId
ORDER BY participants desc
154 Rubik's Cube
145 2x2 Cube
142 4x4 Cube
139 Rubik's Cube: One-handed
126 Rubik's Cube: Blindfolded
122 5x5 Cube
[COLOR="#FF0000"]116 Rubik's Magic
115 Pyraminx[/COLOR]
96 Master Magic
72 Square-1
70 Megaminx
60 6x6 Cube
59 Rubik's Clock
54 Rubik's Cube: Multiple Blindfolded
53 Rubik's Cube: Fewest moves
49 7x7 Cube
40 Rubik's Cube: With feet
34 4x4 Cube: Blindfolded
22 5x5 Cube: Blindfolded
SELECT count(distinct competitionId) competitions, Events.name
FROM Results, Competitions, Events
WHERE Competitions.id=competitionId AND year=2012 AND Events.id=eventId
GROUP BY eventId
ORDER BY competitions desc
I cant argue with stats, but I wasn't only talking about in Competition. For example, because magic is easy to learn, i sold the majority of my magic stock to people at school, who can't be bothered cubing, and didn't even know about competitions. My point is that in general, an average person would rather play with a magic, than a pyraminx. Magic allows people that can't solve Rubik's cubes to enjoy being fast at an event, without having to learn algorithms. This is what makes magic so great.
If it wasn't for magic, neither me, or my cuber friends would not have entered their first competition.
Magic allows people that can't solve Rubik's cubes to enjoy being fast at an event, without having to learn algorithms.
If it wasn't for magic, neither me, or my cuber friends would not have entered their first competition.
I highlighted the meaningful part. The rest is speculation, opinion, wishful thinking, overgeneralization.
Magic allows people that can't solve Rubik's cubes to enjoy being fast at an event, without having to learn algorithms.
I really don't understand why you are proposing your points... How is selling 15 magics to people at school opinion or wishful thinking?! It is solid proof that magic can introduce an average person into the speedcubing world, without them needing to get serious. I don't understand why something as small as magic can create arguments. If you don't like it, don't compete in it... I just don't think it should be ruined for everyone else.
And also, I entered my first competition to see Feliks... I wasn't a speedcuber back then. I was only interested in seeing a master at work. Magic is what convinced me to learn Fridrich, and fly to Sydney to compete again.
@Stefan: I would highly appreciate if you could post your statistics from the maildiscussion here as well.
magic: 178
mmagic: 5
magic,mmagic: 30
SELECT eventIds, count(*) FROM
(SELECT personId, group_concat(distinct eventId ORDER BY eventId) eventIds
FROM Results
GROUP BY personId) tmp
WHERE eventIds in ('magic', 'mmagic', 'magic,mmagic')
GROUP BY eventIds
who firstComp allComps
----------------------------------
2005BURT01 magic 333,magic,mmagic
2005BURT02 magic,mmagic 222,333,magic,mmagic
2005LICC01 magic 333,magic
2005STIL01 magic clock,magic
2005WIZN01 magic 333,444,555,magic,pyram
2006OOMS01 magic 333,magic
2007GRAU01 magic 333,magic
2007NALA01 magic 222,333,444,magic,mmagic,pyram
2007NELS03 magic 333,magic,mmagic
2008GREW01 magic magic,mmagic,pyram
2008LIJI03 magic,mmagic 222,333,magic,mmagic,sq1
2008VIGA01 magic 222,333,magic
2008WEIR01 magic 333,magic
2008WISN01 magic 222,333,clock,magic,mmagic,pyram
2009ARPO01 magic 222,333,333oh,magic,mmagic
2009CHAN04 magic 222,333bf,333fm,333oh,444,555,magic,mmagic,pyram,s...
2009CHEN48 magic 333,magic
2009CHRI01 magic 333,magic
2009FREN03 magic magic,pyram
2009HARR01 magic 222,333,magic,mmagic
2009IOOS01 magic 333oh,clock,magic,mmagic
2009LIUY06 mmagic 222,333,333bf,333oh,444,555,magic,mmagic,pyram
2009LOGA01 magic 333,magic
2009MANZ02 magic magic,pyram
2009MARI01 magic 222,333,clock,magic,mmagic,pyram
2009MENG02 magic 222,333,magic,mmagic
2009PADL01 magic,mmagic 222,333,333oh,444,555,clock,magic,mmagic,pyram,sq1
2009PERE02 magic 222,333,333oh,444,555,magic,pyram
2009PROF01 magic 333,magic
2009STAN01 magic 222,333,magic
2009SUNM02 magic,mmagic 333,magic,mmagic
2009THIE04 magic 444,magic
2009TING02 magic 222,333,magic
2009TOPK01 magic 333,magic
2009WANG04 magic 333,magic
2009WANG13 magic 222,333,333bf,333fm,333oh,444,555,666,777,clock,ma...
2009WOLF01 magic 222,333,magic,pyram
2009ZHAN48 magic,mmagic 333,magic,mmagic
2009ZHAO08 magic 333,magic
2010CHAN04 magic 222,333,333oh,magic
2010DAOH01 magic 222,333,333fm,333ft,333oh,444,555,666,clock,magic,...
2010FAIR01 magic 222,333,magic,mmagic,pyram
2010GARC05 magic,mmagic 333,clock,magic,mmagic
2010GUOA01 magic 222,333,magic,mmagic,pyram
2010LIZH02 magic,mmagic 222,333,333bf,333oh,444,555,magic,minx,mmagic,pyra...
2010MILB02 magic,mmagic 222,333,magic,mmagic
2010NGER01 magic 222,magic,mmagic
2010QUAT01 magic 222,333,magic,pyram,sq1
2010UGLO01 magic 222,333,magic,mmagic,pyram
2010URRE02 magic 333,magic
2010WENB01 magic clock,magic,mmagic
2010ZHAN51 magic 333,magic
2011ARRO02 magic 222,333,333oh,magic,mmagic,pyram
2011BUTO01 magic 333,magic
2011CAIQ01 magic,mmagic 222,333,333oh,444,magic,mmagic
2011DONA03 magic 222,magic,pyram
2011DWYE01 magic 222,333,magic,mmagic
2011HANW01 magic 222,333,magic,mmagic
2011MOLI02 magic 222,333,clock,magic,mmagic,pyram
2011NAVE02 magic 333,magic,pyram
2011NURS02 magic,mmagic 222,333,clock,magic,mmagic
2011PRAM01 magic 222,magic
2011WOOW01 magic,mmagic 222,333,333fm,333ft,333oh,clock,magic,mmagic,pyram
2011YATS01 magic 222,333,333oh,444,555,666,magic,mmagic,pyram
2011ZAMZ02 magic 333,magic
2011ZHEN12 magic 222,333,333bf,333oh,444,555,777,magic,mmagic,pyram
2012HEMI01 mmagic mmagic,pyram
2012ZHAN05 magic,mmagic magic,mmagic,pyram
SELECT firstComp.personId, firstComp.eventIds, allComps.eventIds FROM
(SELECT * FROM
(SELECT Results.personId, group_concat(distinct eventId ORDER BY eventId) eventIds
FROM Results, Competitions, (SELECT personId, min(year*10000+month*100+day) firstDate FROM Results, Competitions WHERE Competitions.id=competitionId GROUP BY personId) tmp
WHERE Competitions.id=competitionId AND Results.personId=tmp.personId AND year*10000+month*100+day=firstDate
GROUP BY Results.personId) tmp2
WHERE eventIds in ('magic', 'mmagic', 'magic,mmagic')) firstComp,
(SELECT personId, group_concat(distinct eventId ORDER BY eventId) eventIds FROM Results GROUP BY personId) allComps
WHERE firstComp.personId = allComps.personId
AND firstComp.eventIds in ('magic', 'mmagic', 'magic,mmagic')
AND allComps.eventIds not in ('magic', 'mmagic', 'magic,mmagic')
LIMIT 999
It is solid proof that magic can introduce an average person into the speedcubing world
Why is Pyraminx the low-water mark? Is Magic better than Clock? Is it better than 5BLD?
Number of possible states of the scrambled puzzles, maybe? Or are there fewer on Clock?
Actually I've often found that people do know what a Rubik's clock is. Well, they don't know it by name, but then when they see it they remember the puzzle from the 80s. I'd say it's better know than a megaminx and a sq-1 by some distance.I'm not actually sure why he mentioned Pyraminx (maybe how easy it is to learn a basic method?). It's a pretty deep puzzle and IMO pretty fun. I mentioned Clock because it's very simple (pretty much only one method, move order doesn't matter, no algs) and not at all well-known outside of cubing. In fact, I'm pretty sure it was only ever an event because it had the Rubik's name (much like Magic).
Actually I've often found that people do know what a Rubik's clock is. Well, they don't know it by name, but then when they see it they remember the puzzle from the 80s. I'd say it's better know than a megaminx and a sq-1 by some distance.