Query editor
withjuplend_instances as (select *from "query_7538195"), juplend_vaults as (select *from "query_6475369"), juplend_vault_nfts as (selectaccount_position_mint as mint, account_position as account_position, account_signer as user, vault_id, next_position_id as nft_idfrom jupiter_solana.vaults_call_init_position), juplend_vault_operate as (selectcall_tx_id as tx_id, call_block_time as block_time, call_block_date as block_date, call_block_slot as block_slot, call_tx_index as tx_index, call_tx_signer as tx_signer, call_outer_instruction_index as outer_instruction_index-- , call_inner_instruction_index as inner_instruction_index, call_instruction_name as instruction, call_executing_account as vault_program_id, liquidity as liquidity_program_id, instance_name, account_vault_config as vault_config, account_position as account_position, account_recipient as recipient, new_col, new_debt, call_log_messages as log_messagesfrom jupiter_solana.vaults_call_operate as opleft join juplend_instances as inston op.call_executing_account = inst.vaults), program_logs as (selectouter_instruction_index, log_index, logs, tx_id, block_slot, block_time, block_date, case when logs like 'Program data:%' then try(from_base64(split(logs, ' ')[3])) else null end as hex_datafrom (selectsum(case when logs like 'Program %% invoke [1]%' then 1 else 0 end) over (partition by tx_id order by log_index asc) as outer_instruction_index