lagandispenserTotal ARC69 standard NFT
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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