lagandispenserTotal ARC69 standard NFT
    Updated 2022-06-16
    WITH
    standard69 as (
    SELECT
    count(distinct asset_id) as std69_nfts from algorand.asset where asset_id in (
    select distinct asset_id from algorand.asset_configuration_transaction where try_base64_decode_string(tx_message:txn:note::string) like '%{"standard":"arc69"%') and closed_at is null
    ),
    standard3 as (
    select count(distinct asset_id) as std3_nfts from algorand.asset where asset_url like '%#arc3%' and closed_at is null
    )
    SELECT
    std69_nfts as arc69_nfts,
    std3_nfts as arc3_nfts
    from standard69, standard3
    Run a query to Download Data