We're pleased to announce that US Nationals 2015 will be held July 31 to August 2, 2015, at the Hilton Head Beach and Tennis Resort in Hilton Head, South Carolina.
Could a moderator please change Tim's post to reflect that the competition starts on 7/31? Tim put in the date the staff competition started accidentally.
Also, could a moderator please change Tim's post to reflect the fact that I'm awesome? Thanks.
[TABLE="class:grid,align:left"]
[TR][TD]Event[/TD][TD]Competitions[/TD][TD][/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD="align:right"]37[/TD][TD]World Championship 2007
US Nationals and Open 2008
Thailand Open 2009
US Nationals 2009
World Championship 2009
Jakarta Open 2010
Indonesian Championship 2010
US Nationals 2010
Aachen Open 2011
SESC/Santos 2011
US Nationals 2011
World Championship 2011
SESC Santos 2012
US Nationals 2012
MNW Open 2012
Asian Championship 2012
Euro 2012
Indian Cube Challenge 2013
Brasileiro 2013
World Championship 2013
Taiwan Summer 2013
Guangdong Open 2013
Munich Open 2013
NULAU Kharkiv Winter 2013
Warsaw Open 2014
Polish Open 2014
SLS Rybnik 2014
Indian Nationals 2014
US Nationals 2014
Euro 2014
Cubing Fest 2014
Indiana 2014
Spanish Championship 2014
Guangdong Open 2014
Santa Claus Cube Race 2014
Kharkiv Winter 2014
Shaastra Cube Open 2015[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD="align:right"]3[/TD][TD]US Nationals 2012
World Championship 2013
US Nationals 2014[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD="align:right"]3[/TD][TD]US Nationals 2012
World Championship 2013
US Nationals 2014[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD="align:right"]3[/TD][TD]US Nationals 2012
World Championship 2013
US Nationals 2014[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD="align:right"]3[/TD][TD]US Nationals 2012
World Championship 2013
US Nationals 2014[/TD][/TR]
[/TABLE]
Code:
[NOPARSE]SELECT eventId Event, count(*) Competitions, group_concat(cellName order by year, month, day separator '\n') ''
FROM (SELECT competitionId, eventId
FROM Results
WHERE roundId <> 'b'
GROUP BY competitionId, eventId
HAVING count(distinct roundId) >= 4) tmp
JOIN Competitions ON id = competitionId
GROUP BY eventId
ORDER BY competitions desc;[/NOPARSE]
That stinks. second year in a row that US Nationals is about the entire US away from me... and my parents had already said yes if it was on Vegas. Too late now, I guess.
