MySQL error in file: /engine/modules/podborki.php at line 93

Error Number: 3

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

SQL query:

SELECT DISTINCT p.id, p.title, p.alt_name, p.xfields, p.descr, p.category, c.alt_name as cat_alt, COALESCE(pe.news_read,0) as views, COALESCE(pe.rating,0) as rating, (0 + IF(LOWER(p.title) LIKE '%лучшее%', 8, 0) + IF(LOWER(p.descr) LIKE '%лучшее%', 4, 0) + IF(LOWER(p.xfields) LIKE '%лучшее%', 2, 0) + LEAST(FLOOR(COALESCE(pe.news_read,0)/50),5) + LEAST(FLOOR(COALESCE(pe.rating,0)/5),4)) as score FROM dle_post p LEFT JOIN dle_post_extras pe ON p.id = pe.news_id LEFT JOIN dle_category c ON c.id = CAST(SUBSTRING_INDEX(p.category,',',1) AS UNSIGNED) WHERE p.approve = 1 GROUP BY p.id ORDER BY score DESC, views DESC LIMIT 3000, 24