SQL-sats fungerar inte i MySQL

Hur ska jag göra om denna SQL-sats så att den fungerar i MySQL:

SQL = "SELECT Max(C) AS f_max FROM (SELECT Count(*) AS C FROM t_diaryworkouts WHERE f_runner = " & Request.QueryString("ID") & " GROUP BY Year(f_date), Month(f_date))"

Felmeddelande:

Microsoft OLE DB Provider for ODBC Drivers fel '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near 'SELECT Count(*) AS C FROM t_diaryworkouts WHERE f_runner = 1 GROUP BY Year(f_dat' at line 1

SQL = "SELECT Count(*) AS C FROM t_diaryworkouts WHERE f_runner = " & Request.QueryString("ID") & " GROUP BY Year(f_date), Month(f_date) order by c desc limit 1"

Tack så mycket för det snabba svaret!