select

BLOCK_TIMESTAMP,

tx_hash,

MULTISIG_ADDRESS as multisig,

OWNER_ADDRESS as owner,

SERVICE_ID as serviceId,

row_number() OVER (

partition BY serviceId

order by

BLOCK_TIMESTAMP desc

) as r_no

from

crosschain.olas.ez_service_staking

where

PROGRAM_NAME ilike '%Beta%'

and EVENT_NAME = 'ServiceStaked'

union all

BLOCK_TIMESTAMP,

tx_hash,

concat('0x',substring(topics[3], 26+1, 40)) AS multisig,

concat('0x',substring(topics[2], 26+1, 40)) AS owner,

ethereum.public.udf_hex_to_int(TOPICS[1])::float as serviceId,

row_number() OVER (partition BY serviceId order by BLOCK_TIMESTAMP desc) as r_no

from gnosis.core.fact_event_logs

where (CONTRACT_ADDRESS = lower('0xeF44Fb0842DDeF59D37f85D61A1eF492bbA6135d')

OR contract_address = lower('0x1c2F82413666d2a3fD8bC337b0268e62dDF67434')

OR contract_address = lower('0xbd59ff0522aa773cb6074ce83cd1e4a05a457bc1')

OR contract_address = lower('0x3052451e1eaee78e62e169afdf6288f8791f2918')

OR contract_address = lower('0x4abe376fda28c2f43b84884e5f822ea775dea9f4')

OR contract_address = lower('0x6c6d01e8ea8f806ef0c22f0ef7ed81d868c1ab39')

and TOPICS[0] = '0xaa6b005b4958114a0c90492461c24af6525ae0178db7fbf44125ae9217c69ccb'