Recent content by MattP98

You can join to the Competitions table to retrieve the start/end dates of the comp and query using those. The competition year is determined by the end date of the competition I believe. SELECT r.personId, r.personName, MIN(r.average) AS bestAverage, r.CountryId, c.name, c.end_date FROM Results...

Replace f with Fw, l with Lw, etc. Wide moves are allowed but denoting with lower-case letters is not valid WCA notation.

A few cases that come to mind. Singles: Raúl Martínez Redondo 1.00 +2 skewb single at Fuenlabrada Open 2018. WR at the time was 1.10 by Jonatan Kłosko. Rasmus Stub Detlefsen 4.70+2 square 1 single at KMG Spring 2019. WR at the time was 5.00 by Vicenzo Guerino Cecchini - this was beaten by...

Maybe cross-post this on the WCA forum? I think this sort of discussion belongs there. This would be ideal, but I disagree that it should be a main focus of the WCA. We have Red Bull for spectator events, and ultimately most people will only actually be interested in seeing the fastest solvers...

Oops. Real mixed bag this week, happy with almost half the solves being sub 6.5. Round 33 Race to sub-6.5 (0/3) Avg of 12: DNF Time List: 1. 6.23 2. 8.80 3. 6.32 4. (DNF(7.62) [ALL-1]) 5. (5.98) 6. 6.34 7. DNF(7.65) [ALL+1] 8. 7.09 9. 6.21 10. 6.94 11. 6.96 12. 6.75

Whew, nice average this week! Pure sub-7 aside from the DNF, and the two 5s near the end led to a very nice 6.10 Ao5! Round 32 Race to sub-6.5 (0/3) Avg of 12: 6.54 Time List: 1. 6.52 2. 6.91 3. 6.79 4. 6.78 5. 6.79 6. 6.92 7. 6.17 8. (DNF(7.66)[ALL-1]) 9. 5.64 10. 6.49 11. (5.31) 12. 6.35

Glad to see this thread make a comeback, thanks for continuing! If we continue into future weeks though could you possibly use WCA scrambles please? I probably misscrambled several of these just due to the weird move order. anyway. :p Round 31 Race to sub-6.5 (0/3) Avg of 12: 6.82 Time List...

Clock and 3BLD.

Leeds Open today had the easiest clock scramble ever. Sam Spendla got 3.98, James Molloy got 4.38, and several others got low/mid 5s. I was scrambling at the time and didn't get it - 5.32 first try. As a bonus, also had a near FML of an average where the first 4 solves were 6.85, 8.14, DNF(7.00...

Next comp is British Summer Open in a little under 2 weeks, listing goals now as I'll probably forget by then. Originally was down to do all events, but withdrew from almost half as I'm staffing and need the availability. Out of practice for many events, not setting the bar too high. 3x3: PR...

At a comp last year I was competing in SQ-1, the first two solves were normal but then I thought I had a duplicate scramble for solve 3. Turned out it was the correct scramble and just had the same cubeshape and equator position. I was given E1, and lo and behold it had the same cubeshape again...

Had my clock set up as well as it's ever been and finally broke through in comp last weekend with a 7.01 average in round 1 after a couple of weeks averaging the best I ever have at home. Unfortunately, it then fell out of my pocket when I was retrieving my 7x7 from my bag (an event I don't...

MBLD: 14/17 1:36:46 [1:11:13] First attempt at more than 13 cubes, and second attempt at more than 11. Also first multi attempt since Great British Blind Off in January. DNFs were a flipped edge, a twisted corner, and a messed up Y-perm.

(-2,0)/ (3,0)/ (2,-4)/ (-5,-5)/ (0,-3)/ (-3,-3)/ (-1,0)/ (6,-3)/ (-3,0)/ (1,0)/

Looks like a CubeStyle Carbon Fiber 3x3 to me. I don't own one however, so can't tell for sure. =P https://www.thecubicle.com/products/cubestyle-carbon-fiber-3x3