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) + IF(LOWER(p.title) LIKE '%один%', 8, 0) + IF(LOWER(p.descr) LIKE '%один%', 4, 0) + IF(LOWER(p.xfields) LIKE '%один%', 2, 0) + IF(LOWER(p.title) LIKE '%без команды%', 8, 0) + IF(LOWER(p.descr) LIKE '%без команды%', 4, 0) + IF(LOWER(p.xfields) LIKE '%без команды%', 2, 0) + IF(LOWER(p.title) LIKE '%сам%', 8, 0) + IF(LOWER(p.descr) LIKE '%сам%', 4, 0) + IF(LOWER(p.xfields) LIKE '%сам%', 2, 0) + IF(LOWER(p.title) LIKE '%аутсайдер%', 8, 0) + IF(LOWER(p.descr) LIKE '%аутсайдер%', 4, 0) + IF(LOWER(p.xfields) LIKE '%аутсайдер%', 2, 0) + IF(LOWER(p.title) LIKE '%изгой%', 8, 0) + IF(LOWER(p.descr) LIKE '%изгой%', 4, 0) + IF(LOWER(p.xfields) LIKE '%изгой%', 2, 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 INNER JOIN dle_post_extras_cats pec ON p.id = pec.news_id AND pec.cat_id IN (22,50,35) 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 1416, 24