Warning: mysqli::query(): (HY000/3): Error writing file '/tmp/MYfd=4360' (OS errno 28 - No space left on device) in /var/www/patterns/system/class/class.model.php on line 97
MySQL error in linte 172 at /var/www/patterns/catalog/model/product.php Error writing file '/tmp/MYfd=4360' (OS errno 28 - No space left on device)
select *, count(*)as 'count' from ( select distinct i.*, date_format(dob, '%d.%m.%Y') as 'date', f.id as favorite
from `items` i
left join favorites f on (f.item_id=i.id and f.user_id = 0)
where 1=1 and i.invalid=0 and invisible=0 and author =498 order by id desc )t
left join item_to_group ig on ig.item_id=t.id
group by ig.group_id
order by t.dob DESC
limit 0, 400