Season | Clan ID | Clan Name | Power | Members | Clan Owner | |
---|---|---|---|---|---|---|
1 | SS_4 | #397 | SnowWhite and 50 dwarfs | 409 | 50 | 0x78dd16cad8f1f7e0c76b1aa06a66413bb865cc0e |
2 | SS_4 | #54 | Sansui Kyō | 365 | 50 | 0x4e10476ae2b34e0725f0a98b2e4ec9efe3c30364 |
3 | SS_4 | #198 | Thrillcraft Titans | 364 | 50 | 0xbdb0cd81cf51c9765b2cc547c750892635754d84 |
4 | SS_4 | #493 | The Crimson Blades | 270 | 50 | 0xcfd5c8bf02cd99e688722b2a8a9e88893c00901c |
5 | SS_4 | #244 | TheDiggers | 109 | 50 | 0x99780ceab5e77f319d92f22301f75bf49380c7cf |
6 | SS_4 | #37 | Legendary | 82 | 42 | 0x7de501190ad282b7e9db78991b5a6a7e87d37643 |
7 | SS_4 | #420 | Bartertown Warlords 420 | 81 | 50 | 0xf607fff17af11e93d594cead88c409c32943ba20 |
8 | SS_4 | #101 | IB ARC Community | 42 | 10 | 0x93a1ba963fc77591ebcf9731feec412764d7abf1 |
9 | SS_4 | #349 | Land 349 | 22 | 18 | 0x052d34efb55c755177b056b05f13fd02f07c35c0 |
sssstatisticClan - Rank
Updated 2024-12-16
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 clans AS (
select
decoded_log ['seasonId'] AS seasonId,
decoded_log ['clanId'] AS clanId,
decoded_log ['memberAddress'] AS address,
block_number,
block_timestamp
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name = 'NewMemberJoined'
),
levelups AS (
SELECT
origin_from_address AS address,
block_number,
block_timestamp,
1 AS power
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name = 'LevelUpSamurai'
),
clan_info AS (
SELECT
origin_from_address AS address,
decoded_log ['seasonId'] AS seasonId,
decoded_log ['clanId'] AS clanId,
decoded_log ['name'] AS clanName -- select decoded_log
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name = 'NewClanCreated'
Last run: 2 months agoAuto-refreshes every 12 hours
9
771B
220s