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=5040)
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=5040)
GROUP BY brd.id order by brd.sorting asc' at line 4