0xtoshi2024-05-29 03:42 AM
    Updated 2024-05-28
    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