-- forked from Diamond / Total Moments Burned (Burn Feed) PBII @ https://flipsidecrypto.xyz/Diamond/q/msHf-loV98WP/total-moments-burned-burn-feed-pbii

-- forked from Total Moments Burned (Burn Feed) @ https://flipsidecrypto.xyz/edit/queries/70d0c128-9a99-4d6b-a147-bf8ff775a0fd

-- forked from Legendary Moments Burned (Burn Playbook) copy @ https://flipsidecrypto.xyz/edit/queries/bef7bcb1-b33e-4d62-9e33-fba90775f4e7

-- forked from Legendary Moments Burned (Burn Playbook) @ https://flipsidecrypto.xyz/edit/queries/6e0de03b-c599-4750-aca3-0bbc731eeee8

WITH updated_metadata_0 AS (

SELECT

nft_id as "ID",

--moment_stats_full['ID'] AS "unique_id",

CASE

WHEN player = 'N/A' THEN team

ELSE player

END AS "Player",

team as "Team",

series as "Series",

set_name AS "Set Name",

moment_stats_full ['flowID'] AS "marketplace_id",

moment_tier AS "Tier",

SERIAL_NUMBER AS "Serial #"

FROM

flow.nft.dim_allday_metadata

UNION

SELECT

nft_id AS "ID",

CONCAT(

metadata:playerFirstName :: STRING,

' ',

metadata:playerLastName :: STRING

) AS "Player",

CONCAT(metadata:teamName :: STRING) AS "Team",

series_name as "Series",