flipside

    UFC Event Counts
    ad_fanUFC Event Counts
    Updated 2024-12-31
    SELECT
    COUNT(*)
    FROM
    FLOW.CORE.FACT_EVENTS
    WHERE
    (
    ((EVENT_CONTRACT IN ('A.3cdbb3d569211ff3.NFTStorefrontV2', 'A.4eb8a10cb9f87357.NFTStorefront', 'A.4eb8a10cb9f87357.NFTStorefrontV2')
    -- AND EVENT_DATA :: string LIKE '%UFC_NFT.NFT%'
    AND event_data:nftType like '%UFC_NFT.NFT%')
    OR (EVENT_CONTRACT IN ('A.329feb3ab062d289.UFC_NFT') or EVENT_CONTRACT IN ('A.329feb3ab062d289.UFC_NFT.NFT.ResourceDestr')))
    AND TX_SUCCEEDED = TRUE
    )
    QueryRunArchived: QueryRun has been archived