LAND | Level (Samurai + Pet) | MEMBERS | |
---|---|---|---|
1 | #333 | 4413 | 481 |
2 | #405 | 1699 | 55 |
3 | #37 | 1479 | 54 |
4 | #406 | 1362 | 55 |
5 | #63 | 1296 | 68 |
6 | #512 | 1244 | 52 |
7 | #339 | 1172 | 51 |
8 | #91 | 1162 | 57 |
9 | #108 | 1097 | 56 |
10 | #156 | 1037 | 50 |
11 | #78 | 1025 | 76 |
12 | #420 | 1001 | 71 |
13 | #165 | 986 | 47 |
14 | #101 | 976 | 71 |
15 | #541 | 974 | 67 |
16 | #257 | 928 | 55 |
17 | #458 | 922 | 69 |
18 | #308 | 880 | 55 |
19 | #198 | 842 | 64 |
20 | #54 | 807 | 63 |
sssstatisticLand - Level Ranking
Updated 8 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 land1 AS (
select
decoded_log ['account'] AS address,
decoded_log ['landId'] AS landId,
block_number,
block_timestamp
-- select *
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name = 'NewAccount'
),
reset_account AS (
SELECT origin_from_address AS address,
max(block_timestamp) AS block_timestamp
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name = 'WithdrawRewardFromPool'
GROUP BY origin_from_address
),
levelups AS (
SELECT origin_from_address AS address,
count(*) + 1 AS level
from
blast.core.ez_decoded_event_logs lv
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name IN ('LevelUpSamurai', 'LevelUpPet')
AND not exists (
SELECT 1
from reset_account rs
WHERE rs.address = lv.origin_from_address
AND rs.block_timestamp > lv.block_timestamp
Last run: about 8 hours agoAuto-refreshes every 12 hours
...
555
8KB
90s