Error [ 1064 ] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY YEAR(ALDate),FLOOR(WEEK(ALDate)/2) LIMIT 1' at line 1
# SELECT YEAR(ALDate),FLOOR(WEEK(ALDate)/2) FROM ALoungeResults WHERE ALEventID= ORDER BY YEAR(ALDate),FLOOR(WEEK(ALDate)/2) LIMIT 1
AthletesLounge Results

 

Error [ 1064 ] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&& ALPBest=1 GROUP BY UserID ORDER BY ALTime,ALMsecs LIMIT 0,50' at line 1
# SELECT SQL_CALC_FOUND_ROWS ALoungeResults.*,Lastname,Firstname,WEEK(ALDate) AS ALWeek FROM ALoungeResults JOIN users USING (UserID) WHERE ALEventID= && ALPBest=1 GROUP BY UserID ORDER BY ALTime,ALMsecs LIMIT 0,50

Error [ 1064 ] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY YEAR(ALDate) DESC,FLOOR(WEEK(ALDate)/2) DESC,ALTime,ALMsecs LIMIT 0,50' at line 1
# SELECT SQL_CALC_FOUND_ROWS ALoungeResults.*,Lastname,Firstname,YEAR(ALDate) AS ALYear,FLOOR(WEEK(ALDate)/2) AS ALWeek FROM ALoungeResults JOIN users USING (UserID) WHERE ALEventID= ORDER BY YEAR(ALDate) DESC,FLOOR(WEEK(ALDate)/2) DESC,ALTime,ALMsecs LIMIT 0,50


Dirdy Birdy 5K
Oregon Active presents the 2008 Dirdy Birdy, Portland's muddiest fun run of the year. This 5K mud run on Kruger's farm is not your average race. And the best part? It's all a benefit for Big Brothers Big Sisters Columbia Northwest..
more...