Originally Posted by Dormilich
at least we know now, what the problem is.
as for the next step, try out the year query in a direct SQL client (mysql client. phpmyadmin, mysql workbench, etc.) to see, what your query returns.
the query works fine.. i have tried it on phpmyadmin..