DiamondNFLAD: Video (R)
    Updated 2024-01-03
    WITH updated_metadata AS (
    SELECT
    moment_stats_full ['id'] AS "unique_id",
    CASE
    WHEN player = 'N/A' THEN team
    ELSE player
    END AS "Player",
    team AS "Team",
    moment_stats_full ['flowID'] AS "marketplace_id",
    set_name AS "Set Name",
    total_circulation AS "Mint Count",
    CONCAT(
    'https://assets.nflallday.com/editions/',
    LOWER(REPLACE(set_name, ' ', '_')),
    '/',
    "unique_id",
    '/play_',
    "unique_id",
    '_',
    LOWER(REPLACE(set_name, ' ', '_')),
    '_capture_AnimationCapture_Video_Square_Grey_1080_1080_Grey.mp4'
    ) AS nflallday_assets_url,
    CONCAT(
    'https://nflallday.com/listing/moment/',
    "marketplace_id"
    ) AS "Moment Listing"
    FROM
    flow.nft.dim_allday_metadata
    )
    SELECT
    "marketplace_id"::NUMBER as "id",
    "Player",
    "Team",
    "Set Name",
    "Mint Count",
    "Moment Listing",
    QueryRunArchived: QueryRun has been archived