Maybe because your "AS genres" conflicts with the table name "genres"??
You could try putting back ticks around the AS name:
I actually tried that query in my copy of MySQL 5.5 and it worked fine.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.