DiamondNFLAD: Video (R)
Updated 2024-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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