select
asset_name,
asset_id,
asset_url,
created_at
from algorand.asset
where --ASSET_NAME like '%Tiger Chi #%'
ASSET_DELETED= false
--and total_supply = 1
and creator_address= 'X6MNR4AVJQEMJRHAPZ6F4O4SVDIYN67ZRMD2O3ULPY4QFMANQNZOEYHODE'
order by asset_name