MySQL error in file: /engine/mods/rank/frontend/rank.php at line 33

Error Number: 1021

The Error returned was:
Disk full (/var/tmp/#sql_22fc_0); waiting for someone to free some space...

SQL query:

SELECT descr, name, id, count as count_now, (SELECT count FROM dle_rank WHERE count > count_now ORDER BY count limit 0,1) as next_rank, (SELECT name FROM dle_rank WHERE count > count_now ORDER BY id limit 0,1) as next_name FROM dle_rank where (count BETWEEN '0' AND '703') or (16154 IN (user_id) AND 16154 NOT IN (banned_id)) ORDER BY count desc