Fatal error: Incorrect key file for table '/tmp/#sql_116b_18.MYI'; try to repair it

Query:
SELECT album.cat, members.msgStatus, members.id, members.username, files.bigimage, files.type, files.approved, files.aid, files.adult_content, members_data.gender, members_data.age, members_data.country, members_data.headline, members_data.location FROM members INNER JOIN members_data ON ( members.id = members_data.uid ) LEFT JOIN files ON ( files.uid = members_data.uid AND files.default=1) LEFT JOIN album ON ( album.aid = files.aid ) WHERE members.id = files.uid AND files.type='photo' AND files.featured='yes' AND members.id !=0 AND members.visible = 'yes' AND members.active ='active' GROUP BY members.id ORDER BY files.featured,RAND() LIMIT 15 in /home/artelid/public_html/inc/classes/class_mysql.php on line 185