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 ') as scnt from prod_cat where pcid =   order by orderid asc' at line 1