MySQL returned error

Error Description :

Error No : 1064
Description : 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 ')' at line 1

SQL Query
SELECT product_attributes.*, attributes.id AS attributes_id, attributes.attribute_name AS attributes_attribute_name FROM product_attributes LEFT JOIN attributes AS attributes ON(attributes.id=product_attributes.attribute_id) WHERE product_attributes.id!=0 AND (product_id=)