with alldata as

WITH database AS (

WITH tbl AS (

SELECT *

FROM berachain.testnet.fact_event_logs

WHERE

ORIGIN_TO_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'

AND CONTRACT_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'

AND ORIGIN_FUNCTION_SIGNATURE = '0xe1f63d2e'

AND TX_SUCCEEDED = 'TRUE'

)

SELECT

block_timestamp,

tx_hash,

'0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) AS user_wallet,

'0x' || SUBSTR(PARSE_JSON(TOPICS)[2]::string, -40) AS validator_address,

utils.udf_hex_to_int(DATA) / pow(10, 18)*-1 AS amount

FROM tbl

)

SELECT tx_hash, user_wallet, validator_address, amount

FROM database

where validator_address = '0x35c1e9c7803b47af738f37beada3c7c35eed73d4'

union all

WITH database AS (

WITH tbl AS (

SELECT *

FROM berachain.testnet.fact_event_logs

WHERE

ORIGIN_TO_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'