DiamondBurn Portal Lamar Jackson Burns (Common)
    Updated 2023-08-20
    -- forked from Burn Portal Tyrann Mathieu Burns (Common) @ https://flipsidecrypto.xyz/edit/queries/6b343ad0-f688-440a-b123-9eeb523b8997

    -- forked from Burn Portal Derrick Henry Burns (Common) @ https://flipsidecrypto.xyz/edit/queries/7be01add-9b0d-48b6-9b70-38bbd7273e24

    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:team::STRING
    ) AS "Team",
    series_name as "Series",
    set_name AS "Set Name",
    NULL AS "marketplace_id",
    tier AS "Tier",
    Run a query to Download Data