1064: SELECT p.id,p.title,p.alt2,p.cprice,p.thumb,p.short,p.price, pc.category as catetitle FROM products p INNER JOIN brand_country bc ON p.category=bc.brandid INNER JOIN addedfilters ad ON p.id=ad.p_id LEFT JOIN productcategories pc ON p.category=pc.id WHERE (ad.s_id=) AND (ad.pc=1) AND (pc.showbrand=2 || pc.showbrand=3) AND (bc.country_id='5057') AND ( p.price > 0 ) group by p.id order by p.id desc LIMIT 48
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (ad.pc=1) AND (pc.showbrand=2 || pc.showbrand=3) AND (bc.country_id='' at line 7