Query editor
WITH cutoff AS (SELECT LEAST((SELECT MAX(block_slot)FROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX'),(SELECT MAX(block_slot)FROM solana_utils.latest_balances)) AS block_slot),ns_create AS (SELECTblock_slot,ELEMENT_AT(account_arguments, 3) AS name_account,ELEMENT_AT(account_arguments, 4) AS owner_accountFROM solana.instruction_callsWHEREexecuting_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- SPL name serviceAND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 0 -- createAND ELEMENT_AT(account_arguments, 6) = '58PwtjSDuFHuUkYjH9BYnnQKHfwo9reZhC2zMJv9JPkx' -- SOL root domain accountAND block_slot <= (SELECT block_slot FROM cutoff)),ns_delete AS (SELECTblock_slot,ELEMENT_AT(account_arguments, 1) AS name_account,TRY_CAST(NULL AS VARCHAR) AS owner_accountFROM solana.instruction_callsWHEREexecuting_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- SPL name serviceAND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 3AND ELEMENT_AT(account_arguments, 1) IN (SELECT name_account FROM ns_create)AND block_slot <= (SELECT block_slot FROM cutoff)),ns_transfer AS (SELECTblock_slot,ELEMENT_AT(account_arguments, 1) AS name_account,TO_BASE58(BYTEARRAY_SUBSTRING(data, 2, 32)) AS owner_accountFROM solana.instruction_callsWHEREexecuting_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- SPL name serviceAND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 2AND ELEMENT_AT(account_arguments, 1) IN (SELECT name_account FROM ns_create)AND block_slot <= (SELECT block_slot FROM cutoff)),untokenized_domains AS (SELECTMAX(block_slot) AS block_slot,name_account,MAX_BY(owner_account, block_slot) AS owner_accountFROM (SELECTblock_slot,