Sanjar Umarov

select 
  n.id,
  n.text,
  case when nr.notification_id is null then 'no' else 'yes' end as 'read'
from notification as n 
left outer join notification_read as nr 
  on n.id = nr.notification_id AND nr.user_id = 78;