puriftemporary-emerald
Updated 2024-08-23
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with badge_minters as (
select decoded_log['id'] as badge_id, decoded_log['to'] as minter from berachain.testnet.fact_decoded_event_logs
where CONTRACT_ADDRESS=lower('0x886D2176D899796cD1AfFA07Eff07B9b2B80f1be')
and decoded_log['from']=lower('0x0000000000000000000000000000000000000000')
and decoded_log['id']=98
)
select minter, max(nonce) as tx_amount from berachain.testnet.fact_transactions t
join badge_minters bm on bm.minter=t.FROM_ADDRESS
group by 1 having max(nonce)=0
QueryRunArchived: QueryRun has been archived