rizkiandrianto

select * from notification
right join
(select distinct on (n.seatrequestid) seatrequestid, n.id from notification as n) as distinctnotification
on notification.id = distinctnotification.id
where notification.seatrequestid is not null
order by update_date;