Unable to find .

SELECT e.id, e.person_add, e.on_behalf_of, e.event_type, e.active, e.musician_id, e.entity, e.house_concert, e.ticket_url, e.festival, e.city as ecity, e.state as estate, e.country as ecountry, e.location, e.dt, e.title, e.country_subd, e.state_subd, e.city_subd, e.advertised, e.start, e.price, e.currency, entity.name AS entity_name, entity.city, entity.state, entity.country, entity.country_subd AS entity_country_subd, entity.state_subd AS entity_state_subd, entity.city_subd AS entity_city_subd, country.abbrev AS country_name, currency.name AS currencyname, musician.thumb_img AS thumb_img, entity.maintained_by vmaint, f.maintained_by fmaint, hcp.maintained_by hcpmaint FROM musician_event me LEFT JOIN event e ON e.id = me.event LEFT JOIN musician ON e.musician_id = musician.id LEFT JOIN entity ON entity.id = e.entity LEFT JOIN entity f ON f.id=e.festival LEFT JOIN entity hcp ON hcp.id=e.house_concert LEFT JOIN country ON country.id = entity.country LEFT JOIN currency ON currency.id = e.currency WHERE e.active <> 0 AND e.dt >= CURDATE() AND e.is_planned = 0 AND me.musician='24202' ORDER BY e.dt LIMIT 0,20

Can't create/write to file '/tmp/#sql_2c31_2.MYI' (Errcode: 28 - No space left on device)