intellidegentMad Boy Crew - Return Minters
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
›
⌄
with WhiteListMint as (
select
distinct(nft_to_address) as Minter
from ethereum.core.ez_nft_mints ezm
where ezm.nft_address = '0x2c41a1f838f74e4389392dff3d5f21b272a48a8f'
and mint_price_eth in (0,0.039)
order by Minter
),
PublicMint as (
select
distinct(nft_to_address) as Minter
from ethereum.core.ez_nft_mints ezm
where ezm.nft_address = '0x2c41a1f838f74e4389392dff3d5f21b272a48a8f'
and mint_price_eth not in (0, 0.039)
order by Minter
),
AllMint as (
select
distinct(nft_to_address) as Minter
from ethereum.core.ez_nft_mints ezm
where ezm.nft_address = '0x2c41a1f838f74e4389392dff3d5f21b272a48a8f'
),
MintReturns as (
select
WhiteListMint.Minter as White_List_Minter,
PublicMint.Minter as Public_Minter,
case when White_List_Minter = Public_Minter then 'Yes' else 'No' end as Return_Minter
Run a query to Download Data