PapasotWushu Tiger holders & metadata (Polynize Game event filter)
    Updated 2023-01-03
    select
    address,
    amount,
    asset_name,
    a.asset_id,
    (block_timestamp),
    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 algorand.account_asset b on a.asset_id = b.asset_id
    where
    b.amount = 1
    and
    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'
    and asset_id = 801415454
    or
    asset_id = 800638117
    or
    asset_id = 800786951
    or
    asset_id = 800734484 or
    asset_id = 800751019
    or
    asset_id = 811076572
    or
    asset_id = 804741289
    or
    asset_id = 801828334
    or
    asset_id = 800756474
    Run a query to Download Data