Sniperashamed-magenta
    Updated 2025-02-16
    with tbl as (
    select
    'Pearl Beta' as platform,
    DECODED_LOG:reward / 1e18 as reward
    from gnosis.core.ez_decoded_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')


    )
    and EVENT_NAME = 'ServiceUnstaked'
    UNION all
    select
    'Quickstart Beta - Expert' as platform,
    DECODED_LOG:reward / 1e18 as reward
    from gnosis.core.ez_decoded_event_logs
    where (CONTRACT_ADDRESS = lower('0x5344B7DD311e5d3DdDd46A4f71481bD7b05AAA3e')
    OR
    contract_address = lower('0xb964e44c126410df341ae04B13aB10A985fE3513')
    OR
    contract_address = lower('0x80faD33Cadb5F53f9D29F02Db97D682E8b101618')
    OR
    contract_address = lower('0xad9d891134443b443d7f30013c7e14fe27f2e029')
    OR
    contract_address = lower('0xe56df1e563de1b10715cb313d514af350d207212')
    OR
    contract_address = lower('0x2546214aee7eea4bee7689c81231017ca231dc93')
    OR
    contract_address = lower('0xd7a3c8b975f71030135f1a66e9e23164d54ff455')
    Last run: about 2 months ago
    Total reward
    1
    149642.097
    1
    14B
    7s