SPORTPASSDuplicates by Wallet
Updated 2025-04-09
999
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 excluded_nfts AS (
SELECT
EVENT_DATA:nftId::STRING AS nftId
FROM
flow.core.fact_events
WHERE
tx_id IN (
'72f196759a3565ca0a809bdbaef84f1b48b3a55e95e698988f76c72046d537ba',
'01495e71620a9d5f71ed0b809b4dd2eed3ad702f395e2d03da255bb208afe32e',
'd6012fe72506fe3a43d472777b220e2d5129fe8bc953e85240b79c2ffa6c3015',
'790916c37a207730091a0544667a95e3085cea72ead691dc9b04c1e65260826f'
)
AND EVENT_CONTRACT = 'A.8f9231920da9af6d.AFLNFT'
AND EVENT_TYPE = 'NFTMinted'
),
all_mints AS (
SELECT
EVENT_DATA:templateId::STRING AS templateId,
EVENT_DATA:mintNumber::STRING AS serialNumber,
EVENT_DATA:nftId::STRING AS nftId,
block_timestamp,
ROW_NUMBER() OVER (
PARTITION BY
EVENT_DATA:templateId::STRING,
EVENT_DATA:mintNumber::STRING
ORDER BY
block_timestamp ASC
) AS mint_order
FROM
flow.core.fact_events
WHERE
EVENT_CONTRACT = 'A.8f9231920da9af6d.AFLNFT'
AND EVENT_TYPE = 'NFTMinted'
AND TX_SUCCEEDED = TRUE
AND EVENT_DATA:nftId::STRING NOT IN (SELECT nftId FROM excluded_nfts)
),
Last run: 16 days ago
...
102
37KB
56s