MySQL error in file: /engine/engine.php at line 1145

Error Number: 3

The Error returned was:
Error writing file '/tmp/MYfd=1117' (OS errno 28 - No space left on device)

SQL query:

SELECT p.id FROM dle_post p WHERE date >= '2022-09-01'AND date < '2022-09-01' + INTERVAL 1 MONTH AND approve=1 AND date < '2024-10-04 20:14:22' ORDER BY date DESC LIMIT 16140,10