PapasotWushu Tiger faction trait latest
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
with latest_metadata as (
SELECT
asset_name,
a.asset_id,
max(block_timestamp) as latest
from algorand.asset_configuration_transaction a
inner join algorand.asset b on a.asset_id = b.asset_id
where
a.asset_id in (select
asset_id
from algorand.asset
where ASSET_NAME like '%Wushu Chi #%'
and ASSET_DELETED= false
and total_supply = 1
and creator_address= '4UK5324YGP3UFLUK64E7ZPS6FQYKUC2ESF23TI5DZALTZVYD5PZG3J6BBY'
order by asset_name)
group by asset_name,a.asset_id
order by asset_name
)
select
b.asset_name,
b.asset_id,
latest as latest_date,
TRY_BASE64_DECODE_STRING(tx_message :txn :note :: STRING) as metadata
--parse_JSON(note):properties as traits
from algorand.asset_configuration_transaction a
inner join latest_metadata b on a.asset_id = b.asset_id
WHERE
a.block_timestamp = latest
order by asset_name,block_timestamp desc
Run a query to Download Data