BaseMinter List
Updated 2024-09-13Copy Reference Fork
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
mint_data AS (
SELECT
NFT_TO_ADDRESS AS minter_address,
COUNT(TOKENID) AS minted_count
FROM
base.nft.ez_nft_transfers
WHERE
EVENT_TYPE = 'mint' AND
NFT_ADDRESS = LOWER('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62') AND
NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
GROUP BY
NFT_TO_ADDRESS
),
current_holders AS (
WITH a AS (
SELECT
nft_to_address AS wallets,
'1' AS flag
FROM base.nft.ez_nft_transfers
WHERE nft_address = LOWER('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62')
UNION ALL
SELECT
nft_from_address AS wallets,
'-1' AS flag
FROM base.nft.ez_nft_transfers
WHERE nft_address = LOWER('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62')
)
SELECT
wallets AS holder_address,
SUM(flag) AS nfts
FROM
QueryRunArchived: QueryRun has been archived