0xtoshiENS
Updated 2024-05-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
ENS as(
SELECT OWNER,ENS_DOMAIN,COUNT(*) as hasEns
FROM ethereum.ens.ez_ens_domains
WHERE OWNER IN (SELECT SENDER_WALLET FROM L0)
WHERE LENGTH(END_DOMAIN) > 2
GROUP BY 1,2
)
SELECT a.*
FROM ENS a
JOIN ENS b ON a.ENS_DOMAIN LIKE '%' || b.ENS_DOMAIN || '%'
WHERE a.row_num <> b.row_num;
QueryRunArchived: QueryRun has been archived