Query editor
withnft_mint_hashlist as (SELECTaccount_arguments[6] as mint_idFROMsolana.instruction_callswhereblock_slot > 236407863and is_inner = FALSEand executing_account = 'CndyV3LdqHUfDLmE5naZjVN8rBZz4tqhdefbAnjHG3JR'AND CARDINALITY(account_arguments) > 22and account_arguments[1] = 'HdxygDi1RRQb3VW6vHDG6psSBwaeU7hgJYFEinM544TC'and account_arguments[13] = 'ATA4Ee7bbS4kNzS5T8JshatF7XWmeaQ2R458hvym2CbB'and tx_success),lock_banx as (SELECTaccount_mint as mint,call_block_time as tx_ts,call_tx_id as txid,'lock' as actionfrommpl_token_metadata_solana.mpl_token_metadata_call_Lockwherecall_block_slot > 236407863AND call_block_slot <= 256672969AND account_authority = 'FoNprxYzYmwnYzhM964CxEHchhj17YREieJtSAXg9FMU'AND call_outer_executing_account = '4tdmkuY6EStxbS6Y8s5ueznL3VPMSugrvQuDeAHGZhSt'AND call_instruction_name = 'Lock'AND account_mint in (SELECTmint_idfromnft_mint_hashlist)ORDER BYcall_block_time DESC),unlock_banx as (SELECTaccount_mint as mint,call_block_time as tx_ts,call_tx_id as txid,'unlock' as actionfrommpl_token_metadata_solana.mpl_token_metadata_call_Unlockwherecall_block_slot > 236407863AND call_block_slot <= 256672969AND account_authority = 'FoNprxYzYmwnYzhM964CxEHchhj17YREieJtSAXg9FMU'AND call_outer_executing_account = '4tdmkuY6EStxbS6Y8s5ueznL3VPMSugrvQuDeAHGZhSt'AND call_instruction_name = 'Unlock'AND account_mint in (SELECTmint_idfromnft_mint_hashlist)ORDER BYcall_block_time DESC