MLDZMNCoastal 1
    Updated 2024-06-17
    with tb1 as (select
    BLOCK_TIMESTAMP,
    tx_hash,
    DECODED_LOG:multisig as multisig,
    DECODED_LOG:owner as owner,
    DECODED_LOG:serviceId as serviceId,
    row_number() OVER (partition BY serviceId order by BLOCK_TIMESTAMP desc) as r_no
    from gnosis.core.ez_decoded_event_logs
    where CONTRACT_ADDRESS = lower('0x43fB32f25dce34EB76c78C7A42C8F40F84BCD237')
    and EVENT_NAME = 'ServiceStaked'
    ),

    tb2 as (select
    *
    from tb1
    where r_no = 1)

    select
    count(*) as participants
    from tb2



    Last run: 3 days ago
    PARTICIPANTS
    1
    112
    1
    7B
    8s