Query editor
WITH pool_entities AS (SELECT * FROM query_6726649),-- 1️⃣ Берём уникальные funding транзакцииunique_funding_txs AS (SELECT DISTINCT wallet_funding_txFROM pool_entitiesWHERE wallet_funding_tx IS NOT NULL),-- 2️⃣ Из transfers берём ТОЛЬКО эти транзакцииtx_lookup AS (SELECTtx_id,from_owner AS funding_rootFROM tokens_solana.transfersWHERE tx_id IN (SELECT wallet_funding_tx FROM unique_funding_txs)AND token_version = 'native'AND token_mint_address = 'So11111111111111111111111111111111111111111'),-- 3️⃣ Маппинг depth-2depth2 AS (SELECTpe.pool_address,pe.creator_signer,pe.wallet_funder AS intermediate_funder,COALESCE(tl.funding_root, pe.wallet_funder) AS root_funderFROM pool_entities peLEFT JOIN tx_lookup tlON pe.wallet_funding_tx = tl.tx_id)SELECTroot_funder,COUNT(DISTINCT intermediate_funder) AS intermediate_wallets,COUNT(DISTINCT creator_signer) AS creators,COUNT(DISTINCT pool_address) AS poolsFROM depth2GROUP BY root_funderORDER BY pools DESC;