MySQL error in file: /engine/modules/show.short.php at line 99

Error Number: 3

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

SQL query:

SELECT p.id, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve = 1 and p.id in ( SELECT (dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307') ) ORDER BY id desc LIMIT 17928,24