SELECT

DISTINCT(asset_id) AS genesis_nft

FROM flipside_prod_db.algorand.transfers

WHERE asset_sender ILIKE 'MS7TKJ3MXE6CQ5IZW2ZQC2KT3NWJFQPRSDAFTZPGYPFCZZ43PL7UPBTZXE'

AND receiver NOT ILIKE 'CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'

AND receiver NOT ILIKE 'VWZBFLBUN6O5A5W6IWHMDUVP5NH2LPV4ZYFMAHP4FQBBYP627MP6WPOEG4'

AND block_timestamp >= '2022-07-06 19:00:00'

),

wallets AS (

SELECT DISTINCT(address) AS holders

FROM flipside_prod_db.algorand.account_asset

WHERE address NOT ILIKE 'CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'

AND amount > 0

AND asset_id IN (

SELECT genesis_nft

FROM assets

)

SELECT

address,

asset_name,

amount

FROM flipside_prod_db.algorand.account_asset

WHERE asset_id = '571576867'

AND address IN (

SELECT holders

FROM wallets

)

ORDER BY amount DESC