MySQL error in linte 178 at /var/www/patterns/catalog/model/product.php Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by <br>

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 i.id in (SELECT itp_item_id FROM `item_to_property` where itp_prop_id in ('47') group by itp_item_id having count(*)>=1 )  order by i.dob 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, 32