Query editor
-- Latest favourite registration per walletWITH favourites_raw AS (SELECTblock_time,element_at(account_arguments, 1) AS name_account,element_at(account_arguments, 3) AS owner_walletFROM solana.instruction_callsWHERE executing_account = '85iDfUvr3HJyLM2zcq5BXSiDvUWfw6cSE1FfNBo8Ap29'AND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 6),current_fav AS (SELECT owner_wallet, MAX_BY(name_account, block_time) AS name_accountFROM favourites_rawGROUP BY owner_wallet),-- Ownership records from Name Serviceown_create AS (SELECTelement_at(account_arguments, 3) AS name_account,element_at(account_arguments, 4) AS owner_wallet,element_at(account_arguments, 6) AS parent_account,block_timeFROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX'AND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 0),own_transfer AS (SELECTelement_at(account_arguments, 1) AS name_account,element_at(account_arguments, 2) AS owner_wallet,block_timeFROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX'AND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 2),current_owner AS (SELECT name_account, MAX_BY(owner_wallet, block_time) AS current_ownerFROM (SELECT name_account, owner_wallet, block_time FROM own_createUNION ALLSELECT name_account, owner_wallet, block_time FROM own_transfer)GROUP BY name_account),parent_per_name AS (SELECT name_account, MAX_BY(parent_account, block_time) AS parent_accountFROM own_createGROUP BY name_account),-- Only keep favourites that the wallet still ownsvalid AS (SELECTf.owner_wallet,f.name_account,p.parent_account