A Database Error Occurred

Error Number: 1064

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 'group by prd.fld_product_sku ORDER BY fld_product_price ASC' at line 1

SELECT prd.*,min(prd.fld_product_price) as fld_min_price,brd.fld_brand_name FROM tbl_product prd inner join tbl_brand brd on brd.fld_brand_id=prd.fld_brand_id where prd.fld_product_status=1 and prd.fld_product_id= group by prd.fld_product_sku ORDER BY fld_product_price ASC

Filename: /home/kumargeneratorho/public_html/models/mproduct.php

Line Number: 9317