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 catalog.status = "1"' at line 1 [ SELECT COUNT(DISTINCT catalog.id) AS count FROM catalog WHERE catalog.parent_id= and catalog.status = "1" ]