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

Error Number: 3

The Error returned was:
Error writing file '/tmp/MYfd=66' (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) + 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 1584, 24