DiamondBurn Portal Lamar Jackson Burns (Common)
Updated 2023-08-20
999
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 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