Error 1021:
Disk full (/tmp/#sql_2de_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

On query:
SELECT DISTINCT c.id, c.title, c.eng_title FROM publication t1, id_table_category_pub itcp, category c WHERE t1.id = itcp.id_publication AND itcp.id_table = 173 AND itcp.table_name = "serial" AND itcp.id_category = c.id