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 |
sssstatisticTOP Samurai
Updated 13 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
...
13032
983KB
49s