Best


1064: SELECT p.id,p.title,p.thumb,p.webp_thumb,p.alt2, p.short,p.price,pc.category as categoryttitle, pc.id as cateid 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='') AND (p.pc=) AND (topten='yes') group by p.id ORDER BY p.toptenno DESC LIMIT 10
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 (topten='yes') group by p.id ORDER BY p.toptenno DESC LIMIT 10' at line 7