select t.tx_hash,

t.block_timestamp,

t.tx_signer,

try_parse_json (t.tx) as p_tx,

t.transaction_fee / pow(10,24) as fee,

e.action_name, --if function_call table, all are FunctionCall

e.method_name,

e.deposit / pow(10,24) as e_deposit,

p_tx:actions[0]:FunctionCall:args as args,

p_tx:actions[0]:FunctionCall:deposit as deposit,

p_tx:actions[0]:FunctionCall:method_name as p_method_name,

--base64_decode_string (r.receipt_object_id) as d_1,

--base64_decode_string (r.receipt_outcome_id[0]) as d_2,

r.receipt_object_id as d_1,

r.receipt_outcome_id as d_3,

r.status_value,

r.logs

from near.core.fact_transactions t

left join near.core.fact_actions_events_function_call e

on t.tx_hash = e.tx_hash

left join near.core.fact_receipts r

on t.tx_hash = r.tx_hash

where t.tx_receiver = 'contract.main.burrow.near'

),

deposits as (

select tx_hash,

block_timestamp,

tx_signer,

fee,

method_name,

p_method_name,

case

when method_name = p_method_name then 'check'

else 'boo'