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 s.*, ib.role_name FROM serials s, id_base ib WHERE ib. id_serials = s.id AND ib.id_actors = 1150 ORDER BY ib.main_role DESC, rating DESC LIMIT 4