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 = '99' )
 order by RAND()
 limit 10 
  === Incorrect key file for table '/tmp/#sql_7954_0.MYI'; try to repair it