rezarwzALL Configure gas mode TX
    Updated 2024-03-22
    SELECT
    tx_hash,
    ORIGIN_FUNCTION_SIGNATURE,
    'Claimable' as gas_mode,
    'configureClaimableGasOnBehalf' as function,
    CONCAT('0x', substring(input_data, 35)) AS contract_address
    FROM
    blast.core.fact_transactions
    where
    to_Address = '0x4300000000000000000000000000000000000002'
    and origin_function_signature = '0x908c8502'
    and status = 'SUCCESS'
    UNION
    all
    SELECT
    tx_hash,
    ORIGIN_FUNCTION_SIGNATURE,
    'Void' as gas_mode,
    'configureVoidGasOnBehalf' as function,
    CONCAT('0x', substring(input_data, 35)) AS contract_address
    FROM
    blast.core.fact_transactions
    where
    to_Address = '0x4300000000000000000000000000000000000002'
    and origin_function_signature = '0xeb59acdc'
    and status = 'SUCCESS'
    union
    all
    SELECT
    tx_hash,
    ORIGIN_FUNCTION_SIGNATURE,
    CASE
    when gasMode = 0 then 'Void'
    when gasmode = 1 then 'Claimable'
    end as gas_mode,
    'configureContract' as function,
    QueryRunArchived: QueryRun has been archived