Invalid sql query : 
 select 
 CAST(FirmCommodityPrice AS UNSIGNED) as FirmCommodityPrice, 
 tblfirmcommodity.*, 
 tblcommodity.*, 
 tblfirmreg.* 
 from tblfirmcommodity 
 left join tblcommodity on FirmCommodityCategoryRef = CommodityID 
 left join tblfirmreg on FirmCommodityRef = FirmID 
 where FirmCommodityIsVisible_UA = 1 
 and CommodityIsVisible_UA = 1 
 and ( CommodityID = '142' )
 order by RAND()
 limit 10 
  === Got error 28 from storage engine