Query editor
WITH source AS (SELECT allocations, tx_hash, block_timeFROM table(decode_evm_event(abi => '{"anonymous":false,"inputs":[{"indexed":false,"internalType":"bytes32[]","name":"allocations","type":"bytes32[]"}],"name":"AllocationsSet","type":"event"}',input => table(SELECT *FROM base.logsWHERE topic0 = 0xbd18231792a7535fff80d85564ce7d95dbdff6819b40ad815711b21a75e6bb49AND tx_from = 0xe847eBff4d1B7ae3691f238c5Cd5Cf691Fd1F413)))),arrays AS (SELECT tx_hash, block_time, allocationFROM source, UNNEST(allocations) AS t(allocation)),address AS (SELECTtx_hash,block_time,varbinary_to_uint256(varbinary_substring(allocation, 1, 12)) / 1e18 AS amount,varbinary_substring(allocation, 13, 20) AS addressFROM arrays),final_address AS (SELECT DISTINCT tx_hash, block_time, amount, addressFROM address),excluded AS (SELECT CAST(recipient AS VARBINARY) AS addressFROM query_5572053),filtered AS (SELECT *FROM final_addressWHERE address NOT IN (SELECT address FROM excluded))SELECTget_href('https://basescan.org/address/' || CAST(address AS VARCHAR),CAST(address AS VARCHAR)) AS address_link,amount,block_time,tx_hashFROM filteredORDER BY amount DESC;