m.tx_id

from terra.msg_events m

where m.event_attributes:redeem_amount is not null

and m.event_attributes:burn_amount is not null

and m.event_attributes:"1_contract_address"::string = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

and m.tx_status = 'SUCCEEDED'

and m.block_id < 3000000

)

m.tx_id,

m.event_attributes:"0_amount"[0]:amount as uust_paid_in_fees,

m.event_attributes:"0_amount"[0]:amount / pow(10, 6) as ust_paid_in_fees

from terra.msg_events m

where m.tx_id in (select tx_id from redemption_txn_ids)

and m.event_attributes:"0_recipient"::string = 'terra17xpfvakm2amg962yls6f84z3kell8c5lkaeqfa'

and m.event_attributes:"0_sender"::string = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'