Duplicate Ids, USED IN FRONT END

SPORTPASSDuplicate Ids, USED IN FRONT END

Updated 2025-04-10

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 LIKE '%AFL%'

AND EVENT_TYPE = 'NFTMinted'

AND TX_SUCCEEDED = 'TRUE'

AND BLOCK_HEIGHT > 46636000

AND tx_id NOT IN (

'72f196759a3565ca0a809bdbaef84f1b48b3a55e95e698988f76c72046d537ba',

'01495e71620a9d5f71ed0b809b4dd2eed3ad702f395e2d03da255bb208afe32e',

'd6012fe72506fe3a43d472777b220e2d5129fe8bc953e85240b79c2ffa6c3015',

'790916c37a207730091a0544667a95e3085cea72ead691dc9b04c1e65260826f'

)

exchanges AS (

SELECT

EVENT_DATA:"oldTokenId" AS oldTokenId,

EVENT_DATA:"newTokenId" AS newTokenId

FROM

flow.core.fact_events

WHERE

Last run: 18 days ago

	DUPLICATEIDS
1	[ "143162", "150163", "150661", "143165", "160936", "175085", "113919", "114125", "90041", "175137", "159088", "113479", "90044", "113918", "170670", "85757", "125558", "128635", "100446", "113474", "128715", "113472", "164872", "125547", "164871", "164874", "108049", "115545", "150662", "164873", "176649", "105720", "170839", "164716", "140927", "159133", "113477", "149422", "175131", "126164", "141259", "149424", "170840", "114466", "160931", "113917", "175135", "141260", "176704", "113478", "113476", "149406", "125556", "159052", "90040", "159086", "162730", "95481", "85754", "113475", "175132", "140928", "126165", "100445", "175625", "164880", "158750", "159067", "151460", "115477", "164875", "131733", "170671", "85756", "167483", "149409", "164878", "114126", "164876", "90046", "95482", "149421", "122220", "176647", "108048", "175087", "175133", "84204", "160934", "159132", "175036", "164457", "127714", "175083", "159066", "85755", "128634", "159089", "175026", "159131", "127421", "170607", "131717", "125557", "170672", "149407", "175025", "159087", "175086", "159065", "160933", "84203", "90047", "114124", "149423", "114123", "128717", "128716", "159068", "140929", "165039", "127422", "141261", "175134", "125555", "176468", "175136", "113916", "175084", "160932", "90042", "90043", "159130", "149408", "128718", "90045", "101958", "127713", "175138", "162575", "160935", "143163", "164458", "143164" ]

DUPLICATEIDS

[ "143162", "150163", "150661", "143165", "160936", "175085", "113919", "114125", "90041", "175137", "159088", "113479", "90044", "113918", "170670", "85757", "125558", "128635", "100446", "113474", "128715", "113472", "164872", "125547", "164871", "164874", "108049", "115545", "150662", "164873", "176649", "105720", "170839", "164716", "140927", "159133", "113477", "149422", "175131", "126164", "141259", "149424", "170840", "114466", "160931", "113917", "175135", "141260", "176704", "113478", "113476", "149406", "125556", "159052", "90040", "159086", "162730", "95481", "85754", "113475", "175132", "140928", "126165", "100445", "175625", "164880", "158750", "159067", "151460", "115477", "164875", "131733", "170671", "85756", "167483", "149409", "164878", "114126", "164876", "90046", "95482", "149421", "122220", "176647", "108048", "175087", "175133", "84204", "160934", "159132", "175036", "164457", "127714", "175083", "159066", "85755", "128634", "159089", "175026", "159131", "127421", "170607", "131717", "125557", "170672", "149407", "175025", "159087", "175086", "159065", "160933", "84203", "90047", "114124", "149423", "114123", "128717", "128716", "159068", "140929", "165039", "127422", "141261", "175134", "125555", "176468", "175136", "113916", "175084", "160932", "90042", "90043", "159130", "149408", "128718", "90045", "101958", "127713", "175138", "162575", "160935", "143163", "164458", "143164" ]

1KB

20s

flipside

flipside