1064: SELECT count(*) as total_row FROM products INNER JOIN added_sub_brand adsb ON products.id=adsb.product_id LEFT JOIN productcategories pc ON products.category=pc.id WHERE products.category= AND adsb.sub_brand_id=3008 AND price > 0
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 adsb.sub_brand_id=3008 AND price > 0' at line 3