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

Error Number: 3

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

SQL query:

SELECT p.id FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('9')) c ON (p.id=c.news_id) WHERE approve=1 AND date < '2025-05-07 09:23:32' ORDER BY fixed desc, date DESC LIMIT 9372,12