select
    per.id persona,
    d.id Dolg,
    (select a.full_adr from address a where a.id = c.r_adres_id) adres,
    c.typ,
    cast(c.dt as date)
from person per
    inner join debt d on d.parent_id = per.id
    inner join contact_log c on c.r_debt_id = d.id

where c.typ = 6
    and d.id in (