Query editor
WITH excluded_addresses AS (SELECT DISTINCTVARBINARY_SUBSTRING(topic2, 13, 20) AS addressFROM base.logsWHEREcontract_address = 0x1111111111166b7fe7bd91427724b487980afc69AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND topic1 = 0x0000000000000000000000000000000002ba96C69b95E32CAAB8fc38bAB8B3F8), source AS (SELECTallocations,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.logsWHEREtopic0 = 0xbd18231792a7535fff80d85564ce7d95dbdff6819b40ad815711b21a75e6bb49AND tx_from = 0xe847eBff4d1B7ae3691f238c5Cd5Cf691Fd1F413)))), arrays AS (SELECTtx_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 arraysWHERENOT VARBINARY_SUBSTRING(allocation, 13, 20) IN (SELECTaddressFROM excluded_addresses)), final_address AS (SELECT DISTINCTtx_hash,block_time,amount,addressFROM address)SELECTGET_HREF(CONCAT(CAST('https://basescan.org/address/' AS VARCHAR),CAST(TRY_CAST(address AS VARCHAR) AS VARCHAR)),TRY_CAST(address AS VARCHAR)