An Error Was Encountered

Error Number: 1064

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 category_right < AND 1' at line 3

SELECT count(*) as num FROM products P, products_categories C WHERE C.active=1 and category_products_id=id and category_left > and category_right < AND 1