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

Error Number: 3

The Error returned was:
Error writing file '/tmp/MYfd=3560' (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 ('17','18','19','20','21','22','23','24','27')) c ON (p.id=c.news_id) WHERE approve=1 ORDER BY date DESC LIMIT 10700,10