puriftemporary-emerald
    Updated 2024-08-23
    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