Invalid sql query : 
 select
 tblcommodity.*

 from
 tblfirmcommodity
 left join tblcommodity
 on FirmCommodityCategoryRef = CommodityID
 where FirmCommodityIsVisible_UA = 1
 and CommodityIsVisible_UA = 1
 and (FirmCommodityRef = '1748')
 group by CommodityID
 order by FirmCommodityPrice asc,
 FirmCommodityDLC desc
  === Got error 28 from storage engine