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 stpv.pkproductvariationid != 1751 AND tp.pkproductid = tpc.fkproductid A' at line 5 SELECT
*
FROM
shop_tblproductvariation stpv,shop_tblproduct tp,shop_tblproductcategory tpc
WHERE tp.fkbrandid = AND stpv.pkproductvariationid != 1751 AND tp.pkproductid = tpc.fkproductid AND tp.pkproductid = stpv.fkproductid group by pkproductid order by tpc.fkcategoryid desc