a.asset_receiver as buyer,

asset_transferred,asset_amount,

b.amount as payment,

c.receiver as creator,

c.amount as loyalty_payment

from algorand.asset_transfer_transaction a

left join algorand.payment_transaction b

on a.tx_group_id=b.tx_group_id and b.sender=a.asset_receiver and b.receiver=a.sender

left join algorand.payment_transaction c

on a.tx_group_id=c.tx_group_id and c.sender=a.sender

LIMIT 10