1064: SELECT count(*) as total_row FROM productcategories brd INNER JOIN brand_country bc ON brd.id=bc.brandid LEFT JOIN category ON brd.pc=category.id WHERE (brd.showbrand=2 || brd.showbrand=3) AND (brd.pc=) AND (bc.country_id=5023) GROUP BY brd.id order by brd.sorting asc
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 (bc.country_id=5023) GROUP BY brd.id order by brd.sorting asc' at line 4