MySQL error in file: /engine/modules/block.pro5.5/block.pro.3.php at line 784

Error Number: 1021

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

SQL query:

SELECT p.*, e.*, u.news_num, u.comm_num as autor_comm_num, u.user_group, u.lastdate, u.foto, u.fullname, u.land, u.icq, u.email, u.user_id, u.info, u.signature FROM dle_post p LEFT JOIN dle_users u ON (p.autor=u.name) LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve AND date >= "2024-07-06 23:53:00" - INTERVAL 665 DAY AND date < "2024-07-06 23:53:00" ORDER BY (rating*100+p.comm_num*10+news_read) DESC LIMIT 0, 10