Error #1021 - Disk full (/tmp/#sql_4481_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Query Executed : select TRA_COMPANY.COMID,COMINDEX,COMNAME,COMPIN,COMADDRESS,COMONUMBER,COMMNUMBER,COMURL,COMPERSON,COMLOGO,COMDESCRIPTION,CHKONO,CHKMNO,CHKURL,REGSTATUS from TRA_ALLOCATION,TRA_COMPANY left join TRA_COMPANYDETAILS on TRA_COMPANY.COMID=TRA_COMPANYDETAILS.COMID where ALLCMID=TRA_COMPANY.COMID and ALLPLID="1" and ALLCTID="30491" and TRA_COMPANY.RECYCLED="N" and TRA_ALLOCATION.RECYCLED="N" and (REGSTATUS="P" || REGSTATUS="C") and COMSTATUS="Y" and ALLSTATUS="A" order by RAND() limit 0,999
