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_attribute.*, AS attribute_id, attribute.attribute_name AS attribute_attribute_name FROM product_attribute LEFT JOIN attribute AS attribute ON( WHERE!=0 AND (product_id=)