: mysqli_query(): (HY000/3): Error writing file '/tmp/MYgkKF0Q' (Errcode: 28 "No space left on device") in
Ошибка DB:
"Error writing file '/tmp/MYgkKF0Q' (Errcode: 28 "No space left on device")"
SELECT
(
if (i.present>0 AND i.price_old>0, 5, (
if (i.present>0 AND (i.datetime_create > (NOW() - INTERVAL 30 DAY)), 4, (
if (i.present>0 AND i.`is_hit`=1, 3, (
if(i.present>0 AND i.`status`=0, 2, (
if (i.present=0, 1, 0)
))
))
))
))
) as sort,
i.id as item_id, IF(i.present>0,1,0) as pr, i.sysname
FROM mp_catalog i
WHERE i.active=1
GROUP BY i.id
ORDER BY pr DESC, sort DESC , i.code asc
/home/arabeska96/www/CORE/classes/db.php