Query editor
-- Agent 地址三条路径重叠分析-- 数据源:-- ERC-8004: base.logs (Registered 事件 owner 地址)-- x402: x402x_base.settlementrouter_evt_settled (payer 地址)-- DX Terminal: dx_terminal_pro_base.Authority_evt_UserToVaultSet (vault 地址)WITH-- ── ERC-8004 owner 地址 ──────────────────────────────────────────erc8004 AS (SELECT DISTINCTbytearray_substring(topic2, 13, 20) AS addressFROM base.logsWHERE contract_address = 0x8004A169FB4a3325136EB29fA0ceB6D2e539a432AND topic0 = 0xca52e62c367d81bb2e328eb795f7c7ba24afb478408a26c0e201d155c449bc4a),-- ── x402 payer 地址 ───────────────────────────────────────────────x402 AS (SELECT DISTINCT payer AS addressFROM x402x_base.settlementrouter_evt_settledWHERE evt_block_time >= TIMESTAMP '2025-11-01'),-- ── DX Terminal vault 地址 ────────────────────────────────────────dxterminal AS (SELECT DISTINCT vault AS addressFROM dx_terminal_pro_base.Authority_evt_UserToVaultSet),-- ── 合并三条路径,标记每条路径 ────────────────────────────────────all_addresses AS (SELECT address,MAX(CASE WHEN source = 'erc8004' THEN 1 ELSE 0 END) AS in_erc8004,MAX(CASE WHEN source = 'x402' THEN 1 ELSE 0 END) AS in_x402,MAX(CASE WHEN source = 'dxterminal' THEN 1 ELSE 0 END) AS in_dxterminalFROM (SELECT address, 'erc8004' AS source FROM erc8004UNION ALLSELECT address, 'x402' AS source FROM x402UNION ALLSELECT address, 'dxterminal' AS source FROM dxterminal)GROUP BY address),-- ── 各路径地址数 + 重叠统计 ───────────────────────────────────────summary AS (SELECTCOUNT(*) AS total_unique_addresses,SUM(in_erc8004) AS erc8004_count,SUM(in_x402) AS x402_count,SUM(in_dxterminal) AS dxterminal_count,SUM(CASE WHEN in_erc8004 + in_x402 + in_dxterminal = 1 THEN 1 ELSE 0 END)AS only_one_path,SUM(CASE WHEN in_erc8004 + in_x402 + in_dxterminal = 2 THEN 1 ELSE 0 END)AS two_paths,SUM(CASE WHEN in_erc8004 + in_x402 + in_dxterminal = 3 THEN 1 ELSE 0 END)AS all_three_paths,-- 两两重叠明细