Unable to run pageCountYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ) as t' at line 5SELECT COUNT(*) AS recCount FROM (SELECT DISTINCT p.*,c.CatName FROM products p LEFT JOIN categories c ON (p.CategoryID1=c.id) LEFT JOIN products_categories pc ON (p.id=pc.ProductID) LEFT JOIN subproducts sp ON (p.id=sp.ProductID AND sp.Visible=1 AND sp.Deleted=0) WHERE 1 AND p.`Deleted`=0 AND CategoryID1 IN () ) as t