(select

tx_id,

block_timestamp::date as burn_date,

event_data:id::int as moment_id

from

flow.core.fact_events

where event_contract = 'A.0b2a3299cc857e29.TopShot'

and event_type = 'MomentDestroyed'

-- and tx_id = '22860886f0cb731fd83c66f18c2e840cb477aaa5aa12a2f64c1d44249aa027f3'

and tx_succeeded),

metadata as

(select

nft_id::int as id,

set_series_number as series,

set_name,

player,

serial_number,

total_circulation,

team

-- , video_urls[0]:url as vertical_video

from

flow.core.dim_topshot_metadata)

select

metadata.series as "Series",

metadata.set_name as "Set",

metadata.player as "Player",

metadata.serial_number as "SN",

burn_events.burn_date as "Burned At",

tx.proposer as "User",

burn_events.tx_id as "Tx"

from

burn_events

left join flow.core.fact_transactions tx on burn_events.tx_id = tx.tx_id

left join metadata on burn_events.moment_id = metadata.id