DiamondBurn Portal Burn #2
Updated 2023-11-07
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
›
⌄
-- forked from Burn Portal Burn #1 @ https://flipsidecrypto.xyz/edit/queries/3c582ee1-abe8-46c5-8703-ab1ce390269a
WITH
updated_metadata_0 AS (
SELECT
nft_id as "ID",
--moment_stats_full['ID'] AS "unique_id",
CONCAT(MOMENT_STATS_FULL:metadata:playerFullName::STRING) AS "Player",
CONCAT(MOMENT_STATS_FULL:metadata:teamName::STRING) 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.core.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",
set_name AS "Set Name",
NULL AS "marketplace_id",
tier AS "Tier",
SERIAL_NUMBER AS "Serial #"
from
flow.core.dim_moment_metadata
),
updated_metadata AS (
SELECT
*
Run a query to Download Data