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

with minters as (

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'

group by Minter

order by brush_count DESC)

select Minter, ENS_NAME, brush_count

from minters m left join crosschain.ens.ez_ens e

on m.Minter = e.owner

order by brush_count DESC