1064: SELECT count(*) as total_row FROM products p INNER JOIN productcategories pc ON p.category=pc.id
INNER JOIN brand_country bc ON pc.id=bc.brandid
where (pc.showbrand=2 || pc.showbrand=3)
AND (bc.country_id='5097')
AND (p.pc=) AND p.redirect=0
AND (p.price=-1)
order by p.orderby DESC 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 p.redirect=0
AND (p.price=-1)
order by p.orderby DESC' at line 5