piperFREEZERVERSE NFTs holders
Updated 2024-10-13
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
›
⌄
⌄
/*
FREEZERVERSE
-- https://www.freezerverse.com/
-- Paleto: 0x446b0Ba7504308fB13E6C4D9e636198F8d4Bd774
-- 3D Helado: 0xfdef1292b9d819f88f98B8B012974cb7DeA0599c
-- Pizza Buddies: 0xB8eC756f124A4C58F397fC88e40d79725b5A28Cd
-- Ranas Chidas: 0x2bDFA6Db300157Bba99A4D848a7dAcF234250143
Fork of https://flipsidecrypto.xyz/lifi/q/8ilnFCRLsMA-/nft-holders-f5Dt0W
Forked the query from https://flipsidecrypto.xyz/teams/lifi/ and adjusted it to my needs!
*/
WITH collection AS
(
SELECT
'Paleto' AS collection,
lower('0x446b0Ba7504308fB13E6C4D9e636198F8d4Bd774') AS nft_address
UNION
SELECT
'3D Helado' AS collection,
lower('0xfdef1292b9d819f88f98B8B012974cb7DeA0599c') AS nft_address
UNION
SELECT
'Pizza Buddies' AS collection,
lower('0xB8eC756f124A4C58F397fC88e40d79725b5A28Cd') AS nft_address
UNION
SELECT
'Ranas Chidas' AS collection,
lower('0x2bDFA6Db300157Bba99A4D848a7dAcF234250143') AS nft_address
),
t2 AS
(
SELECT
e.TOKENID,
e.NFT_ADDRESS,
QueryRunArchived: QueryRun has been archived