select
asset_id,
asset_name,
total_supply,
asset_url
from flipside_prod_db.algorand.asset
where
--total_supply = 1
--and asset_id in (786130476,786131555)
CREATOR_ADDRESS='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
and ASSET_DELETED='FALSE'
and ASSET_NAME not in ('SINGULARITY ERA COMMEMORATIVE','Cosmic Champs Whitelist TOKEN')
order by total_supply DESC