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.*, category.id AS category_id, category.parent_category_id AS category_parent_category_id, category.name AS category_name, category.image AS category_image, category.slug AS category_slug, category.status AS category_status, category.ip AS category_ip, category.date AS category_date, category.sort_order AS category_sort_order, product.id AS product_id, product.name 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, product.date AS product_date, product.model AS product_model, product.sort_order AS product_sort_order, product.filter_title AS product_filter_title FROM product_category LEFT JOIN category AS category ON(category.id=product_category.category_id) LEFT JOIN product AS product ON(product.id=product_category.product_id) WHERE product_category.id!=0 AND (product.status='Active' AND product_category.category_id=)