select cari.id,cari.unvan, max(carihareket.tarih) son_islem_tarihi from cari
left join carihareket on cari.id = carihareket.cariid
group by cari.id, cari.unvan
having  max(carihareket.tarih) < NOW() - INTERVAL 3 month