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