SELECT DISTINCT

EVENT_DATA:nftId :: STRING AS nftId,

EVENT_DATA:templateId :: STRING AS templateId

FROM

flow.core.fact_events

WHERE

EVENT_CONTRACT LIKE '%AFLNFT%'

AND EVENT_TYPE = 'NFTMinted'

AND EVENT_DATA:templateId :: STRING = '129'

, AddressTransactions AS (

SELECT

e.EVENT_DATA:id :: STRING AS nftId,

e.EVENT_TYPE,

e.EVENT_DATA:to :: STRING AS to_address,

e.EVENT_DATA:from :: STRING AS from_address,

e.BLOCK_TIMESTAMP,

e.TX_ID

FROM

flow.core.fact_events e

JOIN GenesisNFTs g ON e.EVENT_DATA:id :: STRING = g.nftId

WHERE

e.EVENT_CONTRACT LIKE '%AFLNFT%'

AND (e.EVENT_DATA:to :: STRING = '0x64222cd5d597d23b' OR e.EVENT_DATA:from :: STRING = '0x64222cd5d597d23b')

AND e.EVENT_TYPE IN ('Deposit', 'Withdraw', 'NFTDestroyed')

, CategorizedTransactions AS (

SELECT

nftId,

EVENT_TYPE,

CASE

WHEN EVENT_TYPE = 'Deposit' AND from_address = '0x8f9231920da9af6d' THEN 'Revealed'