saadiqOddities Wallet Contents
    Updated 2022-11-25
    WITH nft AS
    (SELECT DISTINCT project_name,
    nft_address
    FROM ethereum.core.ez_nft_sales)
    SELECT nft.project_name,
    w.symbol,
    w.contract_address,
    concat('https://etherscan.io/address/', w.contract_address) AS etherscan,
    count(1) AS wallets_holding
    FROM ethereum.core.ez_current_balances w,
    nft
    WHERE w.contract_address = nft.nft_address
    AND user_address in
    (SELECT DISTINCT user_address
    FROM ethereum.core.ez_current_balances
    WHERE contract_address = '0x1792a96e5668ad7c167ab804a100ce42395ce54d' -- oddity
    )
    /*
    proof contracts:
    Proof: 0x08d7c0242953446436f34b4c78fe9da38c73668d
    Moonbirds: 0x23581767a106ae21c074b2276d25e5c3e136a68b
    Oddities: 0x1792a96e5668ad7c167ab804a100ce42395ce54d
    */
    GROUP BY nft.project_name,
    w.symbol,
    w.contract_address
    ORDER BY wallets_holding DESC;
    Run a query to Download Data