sssstatisticTOP Samurai
    Updated 13 hours ago
    With reset_time as (
    select
    origin_from_address,
    max(block_timestamp) AS block_timestamp
    from blast.core.ez_decoded_event_logs
    where contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
    and event_name IN ('WithdrawRewardFromPool')
    group by origin_from_address
    ),
    timeline as (
    select
    origin_from_address,
    event_name,
    max(block_timestamp) AS block_timestamp
    from blast.core.ez_decoded_event_logs el
    where contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
    and event_name IN ('LevelUpSamurai', 'LevelUpPet')
    and not exists (
    select 1
    from reset_time rt
    where rt.origin_from_address = el.origin_from_address
    and rt.block_timestamp > el.block_timestamp
    )
    group by origin_from_address, event_name
    )
    select
    el.origin_from_address AS "Player Address",
    max(
    CASE
    WHEN el.event_name = 'LevelUpSamurai'
    and tl.event_name = 'LevelUpSamurai'
    THEN decoded_log['level']
    ELSE 1
    END
    ) as "Samurai Level",
    max(
    Last run: about 13 hours agoAuto-refreshes every 12 hours
    Player Address
    Samurai Level
    Pet Level
    TIME
    1
    0x723ceb055045433c642afcc2735e11bc9d9d7e73
    50
    50
    2024-05-17 12:46:03.000
    2
    0x7de501190ad282b7e9db78991b5a6a7e87d37643
    50
    50
    2024-10-20 10:17:59.000
    3
    0xe379f51d31a754d01a440819c384ba5126bbbd96
    50
    50
    2024-11-09 13:50:59.000
    4
    0xe8f3ca605e29eeba962a527b360351a66c882d50
    50
    50
    2024-11-29 16:38:17.000
    5
    0x0c91a722504013398cebfd6f003de093207c430a
    48
    48
    2024-12-30 21:13:33.000
    6
    0xfdb3cfe0b781fc3124b9d12a1560b0766058edfa
    44
    37
    2025-01-10 07:56:31.000
    7
    0x5792cf8fd14f743bb476a9fb0d0032d2e827032c
    39
    38
    2025-01-27 13:38:39.000
    8
    0x4b09c6b3a9ca43d108bcb1e17eace8adc3abe1da
    37
    34
    2025-01-25 04:08:09.000
    9
    0xeea94d300f91cd5aea476b22b367640a7f0fa81b
    35
    34
    2024-11-29 07:48:35.000
    10
    0xea6a3b3f6e3a48d71e19e327eeca7bd64ad7cefe
    35
    34
    2024-11-29 07:57:19.000
    11
    0x9232f4dc137f8468a88d3ba49d1e6517c4d27618
    34
    34
    2024-05-21 15:32:41.000
    12
    0x28d9682fd14e84129ec22e9e2201e335771da396
    31
    28
    2025-02-07 09:17:35.000
    13
    0x4e10476ae2b34e0725f0a98b2e4ec9efe3c30364
    30
    30
    2024-06-04 04:18:59.000
    14
    0xcfdf39c51356d885be718baab013d09506f50cc8
    30
    30
    2024-06-12 02:50:17.000
    15
    0x20b6d03a0caedfe4409f75f14dfd94838b864199
    30
    29
    2024-06-18 12:59:19.000
    16
    0x497189977ffb615aebb8940c808799adb8f784cb
    30
    29
    2024-10-14 05:42:23.000
    17
    0x18a7ae7693c3da9219a33f7a8fcdd12398c0f4c5
    30
    26
    2024-11-14 06:47:41.000
    18
    0xe6484822eb9d4e991da3e72d4c2607693f2f2529
    29
    29
    2024-12-26 07:54:37.000
    19
    0xfd45f12eee74f3b5382e53fcc885bde4ee869d77
    29
    28
    2024-05-21 13:42:03.000
    20
    0xa3d8ad09798e4bad0dd562bd1700bb261b5ce9c3
    29
    28
    2025-01-27 02:38:43.000
    ...
    13032
    983KB
    49s