eferBase_Mint_Fun
Updated 2024-04-02
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 variables AS (
SELECT
'0xfe03Db4ffaebe20281862c0edFD8718484F344f3' AS first, -- Lint
'0xED6307bF778E98BcA372b2E466e3954c9aFcE065' AS second, -- Bon
'0x05490ae02F71D2f3d1C96a7E62b44a1B2348C66b' AS third -- Rune
), first AS(
SELECT DISTINCT(NFT_TO_ADDRESS) FROM base.nft.ez_nft_transfers
WHERE NFT_ADDRESS = LOWER(SELECT first FROM variables)
AND NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
LIMIT 10000
), second AS(
SELECT DISTINCT(NFT_TO_ADDRESS) FROM base.nft.ez_nft_transfers
WHERE NFT_ADDRESS = LOWER(SELECT second FROM variables)
AND NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
LIMIT 12000
), third AS(
SELECT
DISTINCT(NFT_TO_ADDRESS) AS address,
BLOCK_TIMESTAMP
FROM base.nft.ez_nft_transfers
WHERE NFT_ADDRESS = LOWER(SELECT third FROM variables)
AND NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
ORDER BY BLOCK_TIMESTAMP
LIMIT 5000
), result AS (
SELECT * FROM first
UNION ALL
SELECT * FROM second
UNION ALL
SELECT address FROM third
)
SELECT DISTINCT(NFT_TO_ADDRESS) FROM result
/**
QueryRunArchived: QueryRun has been archived