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 SQL_CALC_FOUND_ROWS t1.*, t1.date as date, t2.eng_title as cat_eng_title, t2.title as cat_title, u.login, itcp.table_name, IF(itcp.table_name ="actor", a.eng_title, s.eng_title) as res_eng_title FROM publication as t1 LEFT JOIN users u ON u.id=t1.id_user LEFT JOIN id_table_category_pub itcp ON t1.id = itcp.id_publication LEFT JOIN category as t2 ON t2.id = itcp.id_category LEFT JOIN actors a ON a.id = itcp.id_table LEFT JOIN serials s ON s.id = itcp.id_table WHERE t1.id IN (891,3070) AND second = 0 ORDER by t1.id DESC LIMIT 0, 10