BT4042024-04-04 02:52 PM
    Updated 2024-04-23
    WITH all_seed_nft AS (
    with seed_nft as (
    SELECT
    tx_hash AS in_TX_HASH,
    FROM_ADDRESS AS in_ua,
    block_timestamp AS in_BLOCK_TIMESTAMP
    FROM
    ethereum.core.fact_transactions
    WHERE
    to_address = '0x00000000fe898dae93619d020f1826333e1cfb85'
    AND ORIGIN_FUNCTION_SIGNATURE = '0xa22cb465'
    AND substr(input_data, 75, 64) = '0000000000000000000000000000000000000000000000000000000000000001'
    AND substr(input_data, 11, 64) = '00000000000000000000000027374086a3ed6d926326956da4dcd8109a753189'
    AND STATUS = 'SUCCESS'
    ),
    Unseed_nft AS (
    SELECT
    tx_hash AS out_TX_HASH,
    FROM_ADDRESS AS out_ua,
    block_timestamp AS out_BLOCK_TIMESTAMP
    FROM
    ethereum.core.fact_transactions
    WHERE
    to_address = '0x00000000fe898dae93619d020f1826333e1cfb85'
    AND ORIGIN_FUNCTION_SIGNATURE = '0xa22cb465'
    AND substr(input_data, 75, 64) = '0000000000000000000000000000000000000000000000000000000000000000'
    AND substr(input_data, 11, 64) = '00000000000000000000000027374086a3ed6d926326956da4dcd8109a753189'
    AND STATUS = 'SUCCESS'
    ),
    seed_unseed_ranks AS (
    SELECT
    seed_nft.in_TX_HASH,
    seed_nft.in_ua,
    seed_nft.in_BLOCK_TIMESTAMP,
    Unseed_nft.out_TX_HASH,
    Unseed_nft.out_ua,
    QueryRunArchived: QueryRun has been archived