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

On query:
SELECT COUNT(id_publication) as counts, title, eng_title, description FROM id_table_category_pub, category WHERE id_table="173" AND id_category in ( SELECT id_category FROM id_table_category WHERE id_table = "173" AND table_name = "serial" ) AND table_name="serial" AND id_category=category.id GROUP BY id_category