MySQL error in linte 215 at /var/www/bot.skincuts.ru/catalog/model/product.php Unknown column 't.dob' in 'order clause' <br>

select *, count(*)as 'count' from ( select distinct i.id, ids.name, ids.description, date_format(dob, '%d.%m.%Y') as 'date', f.id as favorite 
   from  items_description ids,`items` i
   left join favorites f on (f.item_id=i.id and f.user_id = 0)
   where ids.item_id=i.id and ids.item_id = ids.page and i.invalid=0 and invisible=0  and i.id in (SELECT itp_item_id FROM `item_to_property` where itp_prop_id in ('89') 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