freemartianTop 10 Brush Minters
    Updated 2024-10-05
    -- forked from BP Brush Mint & Distinct Minters @ https://flipsidecrypto.xyz/edit/queries/a27f37cb-aeec-47c8-848a-aa1e68ef54f7

    SELECT
    nft_to_address as Minter,
    count(tx_hash) as brush_count
    from base.nft.ez_nft_transfers
    where event_type = 'mint'
    and nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'
    -- and ens.ens_set = 'Y'
    group by Minter
    order by brush_count DESC
    limit 10

    -- select distinct ens_set from crosschain.ens.ez_ens
    -- limit 10


    Auto-refreshes every 1 hour
    QueryRunArchived: QueryRun has been archived