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 ( enabled=1) AND `ordering_available`=1' at line 1
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE AND ( enabled=1) AND `ordering_available`=1