with tabloa as(
select yazar_id
from yazilar
group by yazar_id
)
with tablob as(
select yazar_id
from tabloa, yazilar
where tabloa.yazar_id = yazilar.yazar_id
Order By yazilar.id DESC limit 1
)
select name, title, tarih
from tablob, yazar
where tablob.yazar_id = yazar.id
Order By yazar.id ASC;