Can't execute query :

select tt.*, pt.author, pt.id_author, pt.date as lastpostdate from bab_threads tt left join bab_posts pt on tt.lastpost=pt.id where forum='1' and active='Y' order by pt.date desc limit 40,20

Database Error: Disk full (/var/tmp/#sql_552_1); waiting for someone to free some space...

This script cannot continue, terminating.
Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0