SPORTPASSFind all Burnt NFT Ids since migration
Updated 2024-10-08
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 excluded_nfts AS (
SELECT
EVENT_DATA:nftId::INTEGER AS nftId
FROM
flow.core.fact_events
WHERE
tx_id IN (
'72f196759a3565ca0a809bdbaef84f1b48b3a55e95e698988f76c72046d537ba',
'01495e71620a9d5f71ed0b809b4dd2eed3ad702f395e2d03da255bb208afe32e',
'd6012fe72506fe3a43d472777b220e2d5129fe8bc953e85240b79c2ffa6c3015',
'790916c37a207730091a0544667a95e3085cea72ead691dc9b04c1e65260826f'
)
AND EVENT_CONTRACT = 'A.8f9231920da9af6d.AFLNFT'
AND EVENT_TYPE = 'Minted'
),
pack_openings AS (
SELECT
EVENT_DATA:nftId::INTEGER AS nftId
FROM
flow.core.fact_events
WHERE
EVENT_CONTRACT = 'A.8f9231920da9af6d.AFLNFT'
AND EVENT_TYPE = 'HashedPackOpened'
),
for_sale_nfts AS (
SELECT
EVENT_DATA:id::INTEGER AS id
FROM
flow.core.fact_events
WHERE
EVENT_CONTRACT = 'A.8f9231920da9af6d.AFLMarketplaceV2'
AND EVENT_TYPE = 'ForSale'
),
withdrawn_nfts AS (
SELECT
event_data:id::INTEGER as id,
QueryRunArchived: QueryRun has been archived