MYSQL Error: Can't create/write to file '/tmp/#sql_652_0.MYI' (Errcode: 23)

QUERY: SELECT i.id, c.parent, i.text_name, i.check_active, i.select_status_1, i.text_value, i.text_phone, i.num_price, i.pselect_users_1, i.textarea_adress, i.text_coords, i.num_views, i.num_views1, i.num_views2, i.datetime_top as top, i.datetime_select as `select`, i.datetime_add, i.num_type, i.pselect_content_1 as cat_id, (SELECT img FROM don_ru_info_img im WHERE im.parent=i.id ORDER BY im.ord LIMIT 1) as img_img FROM don_ru_info i INNER JOIN don_ru_info_content ic ON ic.parent = i.id INNER JOIN don_ru_content c ON ic.text_name = c.id WHERE c.id=69 AND datetime_top IS NOT NULL AND EXISTS (SELECT id FROM don_F WHERE id_item=i.id AND number="2813" AND id_filter="2812") AND i.check_active=1 AND i.select_status_1=1 GROUP BY i.id ORDER BY rand() LIMIT 5