QUERY: SELECT p.name,p.sku,(p.price)  as price ,p.is_guest, p.main_image,p.slug,p.id,pa.group_id,pa.product_id,pa.range_id,pa.category_id,pa.brand_id,p.is_special,p.bestseller  FROM hhb_product p,hhb_product_attributes pa where p.status = '1'   and pa.category_id in (SELECT id FROM `hhb_category` WHERE STATUS = '1') and pa.brand_id in (SELECT id FROM `hhb_brand` WHERE STATUS = '1' )  and (pa.group_id = 2) and p.id=pa.product_id  and pa.category_id = <br>
ERROR: 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 '' at line 1<br>