FOO: Query failed: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 'AND artist.id =my_release.id_artist AND label.id = my_release.id_label AND gfx.i' at line 1

SELECT my_release.id AS id, my_release.is_new_release AS is_new_release, my_release.title AS title, my_release.release_date AS release_date, my_release.cat_no AS cat_no, artist.artist_name AS artist_name, artist.id AS artist_id, label.title AS label, gfx.filename AS artwork, my_release.price AS price FROM my_release, artist, label, gfx WHERE my_release.id_label = AND artist.id =my_release.id_artist AND label.id = my_release.id_label AND gfx.id = my_release.id_cover AND my_release.view_state = 1 AND my_release.shop_enabled = 1 ORDER BY my_release.cat_no DESC,my_release.release_date DESC