Untitled

mail@pastecode.io avatar
unknown
pgsql
2 years ago
317 B
1
Indexable
Never
select t.contract_call_function_name, split_part(split_part(asset_identifier,'.',2),'::',1) as nft,
count(n.value) as minted,
count(distinct n.value) as unique_mints 
from nft_events n  
join transactions t using (tx_id)
where asset_identifier like '%megapont%'  
and status=1
and asset_event_type='mint'
group by 1,2