MySQL Error! Name: NoResult [
SELECT goods.*, min(matprice) as good_price
left join mat_price on mat_price.good_id = goods.good_id AND matprice
where goods.good_check AND sc_id = GROUP BY goods.good_id ORDER BY good_adv DESC , good_price].
MySQL answer: 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 'GROUP BY goods.good_id ORDER BY good_adv DESC , good_price' at line 4.