SPORTPASSRemaining-Dupes report
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
duplicates AS (
SELECT
EVENT_DATA:templateId AS templateId,
EVENT_DATA:mintNumber AS serialNumber,
EVENT_DATA:nftId AS nftId,
tx_id,
block_timestamp,
ROW_NUMBER() OVER (
PARTITION BY
EVENT_DATA:templateId,
EVENT_DATA:mintNumber
ORDER BY
BLOCK_TIMESTAMP
) AS row_num
FROM
flow.core.fact_events
WHERE
EVENT_CONTRACT = 'A.8f9231920da9af6d.AFLNFT'
AND EVENT_TYPE = 'NFTMinted'
AND TX_SUCCEEDED = 'TRUE'
AND BLOCK_HEIGHT > 47565880
),
duplicate_nfts AS (
SELECT DISTINCT
nftId
FROM
duplicates
WHERE
row_num > 1
),
excluded_nfts AS (
SELECT
EVENT_DATA:nftId AS nftId
FROM
flow.core.fact_events
Run a query to Download Data