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 'or p.parent_id=)' at line 1

select count(distinct p.products_id) as total from products_details as p where p.products_status=1 and p.product_halt=0 and (p.categories_id= or p.parent_id=)

[TEP STOP]