crypto_edgar2024-05-19 09:38 PM
    Updated 2024-05-19
    1WITH MINT_NFTS AS (
    SELECT
    DISTINCT TX_ID, SIGNERS[2]
    FROM
    solana.core.fact_events
    WHERE
    BLOCK_TIMESTAMP >= '2023-03-25'
    AND SUCCEEDED
    AND ARRAY_SIZE(SIGNERS) = 3
    AND SIGNERS [0] = '7k5qzD2LLJCchakNG9wu9G3AvyFP7eWXBk4WbqgQypm6'
    AND PROGRAM_ID = 'updg8JyjrmFE2h3d71p71zRXDR8q4C6Up8dDoeq3LTM'
    ),
    FILTERED_SAGA_GENESIS_MINTS AS (
    SELECT
    TX_ID
    FROM
    solana.nft.fact_nft_mints
    WHERE
    BLOCK_TIMESTAMP >= '2023-03-25'
    AND TX_ID IN (
    SELECT
    TX_ID
    FROM
    MINT_NFTS
    )
    AND SUCCEEDED
    )
    -- SELECT
    -- DISTINCT TX_ID, SIGNERS[2]
    -- FROM
    -- solana.core.fact_events
    -- WHERE
    -- BLOCK_TIMESTAMP >= '2023-03-25'
    -- AND PROGRAM_ID = 'updg8JyjrmFE2h3d71p71zRXDR8q4C6Up8dDoeq3LTM'
    -- AND SUCCEEDED
    -- AND TX_ID IN (
    QueryRunArchived: QueryRun has been archived