kaibladeTotal Minted Pooly NFTs
Updated 2023-04-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
›
⌄
--How many Pooly NFTs have been minted thus far?
WITH pooly_supporter_data
AS
(SELECT
'Pooly_Supporter' AS nft_name,
tokenid
FROM ethereum.core.ez_nft_mints
WHERE nft_address = lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed')
),
pooly_lawyer_data
AS
(SELECT
'Pooly_Lawyer' AS nft_name, tokenid
FROM ethereum.core.ez_nft_mints
WHERE nft_address = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9')
),
pooly_judge_data
AS
(SELECT
'Pooly_Judge' AS nft_name, tokenid
FROM ethereum.core.ez_nft_mints
WHERE nft_address = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
)
SELECT
(SELECT COUNT(tokenid) FROM pooly_supporter_data) AS pooly_supporters,
(SELECT COUNT(tokenid) FROM pooly_lawyer_data) AS pooly_lawyers,
(SELECT COUNT(tokenid) FROM pooly_judge_data) AS pooly_jugdes,
pooly_supporters + pooly_lawyers + pooly_jugdes AS total_minted_pooly
Run a query to Download Data