Escritura - Conjuntos de escritura

Disk full (/tmp/#sql_58ba_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT ap.* , ap_lang.titulo, ap_lang.descripcion, ap_lang.descripcion_larga, ap_lang.keywords, ap_lang.url_externa FROM categorias AS ap LEFT JOIN categorias_idiomas AS ap_lang ON ap.id = ap_lang.id WHERE ap_lang.idioma= "es" AND ap.id_padre = 0 and ap.visible=1 and ap.ocultar_catalogo = 0 ORDER by orden asc