SELECT tx_hash

FROM arbitrum.core.fact_transactions

WHERE to_address LIKE lower('0x912CE59144191C1204E64559FE8253a0e49E6548')

SELECT

delegator,

event_inputs:toDelegate as Delegate

FROM arbitrum.core.fact_event_logs

LEFT outer JOIN (

SELECT

event_inputs:delegator as delegator,

--event_inputs:toDelegate as toDelegate,

max(block_timestamp) as max_delegate_time

FROM arbitrum.core.fact_event_logs

WHERE tx_hash in (SELECT * from tab1)

AND event_name LIKE 'DelegateChanged'

GROUP BY 1

)

on max_delegate_time = block_timestamp

AND delegator = event_inputs:delegator

WHERE tx_hash in (SELECT * from tab1)

AND event_name LIKE 'DelegateChanged'

AND not DELEGATOR is NULL