MySQL Error!
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 '%2025%', 8, 0) + IF(LOWER(p.descr) LIKE '%2025%', 4, 0) + IF(LOWER(p.xfields) LIKE '%2025%', 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,35,50,6,494)
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 2376, 24