0xtoshi2024-05-29 03:42 AM
Updated 2024-05-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH ENS AS (
SELECT ROW_NUMBER() OVER (ORDER BY ens.OWNER ASC) AS row_num,
ens.OWNER,
ens.ENS_DOMAIN
FROM ethereum.ens.ez_ens_domains ens
LEFT JOIN external.layerzero.fact_transactions_snapshot lz ON ens.OWNER = lz.SENDER_WALLET
WHERE LENGTH(ENS_DOMAIN) > 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