You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND catalog.status = "1"' at line 3 [ SELECT COUNT(DISTINCT catalog.id) AS count FROM catalog AND catalog.status = "1" ]