adambalaUntitled Query
Updated 2022-09-29
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
›
⌄
SELECT
RIGHT(token_name, LENGTH(token_name) - CHARINDEX('#',token_name))::INT AS token_id
, 'Background' AS trait_type
, LOWER(token_metadata:background) AS trait_value
FROM ethereum.core.dim_nft_metadata
WHERE TRUE
AND contract_name = 'DOODLE'
UNION ALL
SELECT
RIGHT(token_name, LENGTH(token_name) - CHARINDEX('#',token_name))::INT AS token_id
, 'Body' AS trait_type
, LOWER(token_metadata:body) AS trait_value
FROM ethereum.core.dim_nft_metadata
WHERE TRUE
AND contract_name = 'DOODLE'
UNION ALL
SELECT
RIGHT(token_name, LENGTH(token_name) - CHARINDEX('#',token_name))::INT AS token_id
, 'Face' AS trait_type
, LOWER(token_metadata:face) AS trait_value
FROM ethereum.core.dim_nft_metadata
WHERE TRUE
AND contract_name = 'DOODLE'
UNION ALL
SELECT
RIGHT(token_name, LENGTH(token_name) - CHARINDEX('#',token_name))::INT AS token_id
Run a query to Download Data