select
        G.ID,
        R.ID,
        R3.FULL_NAME,
        T.DESCRIPTION,
        GT.ACKNOWLEDGEMENT,
        R2.FULL_NAME
from
        GIFT G
join RECORDS R
        on R.ID = G.CONSTIT_ID
join GIFT_TRIBUTE GT
        on GT.GIFT_ID = G.ID
join TRIBUTE T
        on T.ID = GT.TRIBUTE_ID
join RECORDS R3
        on R3.ID = T.RECORDS_ID
left join TRIBUTE_ACKNOWLEDGEE TA
        on TA.TRIBUTE_ID = T.ID
left join CONSTIT_RELATIONSHIPS CR
        on CR.ID = TA.RELATIONSHIPS_ID
left join RECORDS R2
        on R2.ID = CR.CONSTIT_ID