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_category.*, AS category_id, category.parent_category_id AS category_parent_category_id, AS category_name, category.image AS category_image, category.slug AS category_slug, category.status AS category_status, category.ip AS category_ip, AS category_date, category.sort_order AS category_sort_order, AS product_id, AS product_name, product.price AS product_price, product.availibility AS product_availibility, product.description AS product_description, product.short_description AS product_short_description, product.image AS product_image, product.slug AS product_slug, product.status AS product_status, product.new_product AS product_new_product, product.onsale AS product_onsale, product.featured AS product_featured, product.ip AS product_ip, AS product_date, product.model AS product_model, product.sort_order AS product_sort_order FROM product_category LEFT JOIN category AS category ON( LEFT JOIN product AS product ON( WHERE!=0 AND (product_category.category_id=)