flipside

    2023-10-21 01:12 PM
    ad_fan2023-10-21 01:12 PM
    Updated 2025-01-04
    SELECT
    COUNT(*)
    FROM
    FLOW.CORE.FACT_EVENTS
    WHERE
    (
    EVENT_CONTRACT IN ('A.329feb3ab062d289.UFC_NFT','A.329feb3ab062d289.UFC_NFT.NFT.ResourceDestr')
    AND TX_SUCCEEDED = TRUE
    AND ((EVENT_TYPE = 'Deposit' AND event_data:to != 'null') OR (EVENT_TYPE = 'NFTDestroyed'))
    AND event_data:to != '0x329feb3ab062d289'
    )
    QueryRunArchived: QueryRun has been archived