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 (c.categories_status=1 OR c.categories_status' at line 7 in: [select count(distinct p.products_id) as total from products p,
products_to_categories p2c,
categories c
where p.products_status=1
and p.products_id=p2c.products_id
and p2c.categories_id=c.categories_id
and c.categories_id in ()
and (c.categories_status=1 OR c.categories_status=2)]
