PapasotWushu Tiger faction trait latest
    Updated 2023-01-03
    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