Problema encontrado

Erro: 0L65411021: Disk full (/var/lib/mysql/tmp/#sql_7206_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") Linha : 90 Script: /home/tavares/public_html/class.sql.php -> select * from tb_imoveis i inner join tb_bairros b on b.bai_id=i.imo_bai_id inner join tb_tipos t on t.tip_id=i.imo_tip_id inner join tb_cidades c on c.cid_id=i.imo_cid_id where i.imo_id<>'' and i.imo_mostrar='1' and i.imo_finalidade like '%A%' and i.imo_tip_id='' order by rand() limit 20