"Syntax error in SQL expression" SELECT query

Question

I have a MySQL DB connection using OOO Base and trying to create a SQL query

The error is as follows:

SQL Status: S1000
Error code: 1000

SQL syntax error

And here is my query:

SELECT d.month, COUNT(e.key)
FROM event_table e, date_table d
WHERE d.key = e.key
AND d.year = '2013'
GROUP BY d.month;