sssstatisticClan - Rank
    Updated 2024-12-16
    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
    Season
    Clan ID
    Clan Name
    Power
    Members
    Clan Owner
    1
    SS_4#397
    SnowWhite and 50 dwarfs
    409500x78dd16cad8f1f7e0c76b1aa06a66413bb865cc0e
    2
    SS_4#54
    Sansui Kyō
    365500x4e10476ae2b34e0725f0a98b2e4ec9efe3c30364
    3
    SS_4#198
    Thrillcraft Titans
    364500xbdb0cd81cf51c9765b2cc547c750892635754d84
    4
    SS_4#493
    The Crimson Blades
    270500xcfd5c8bf02cd99e688722b2a8a9e88893c00901c
    5
    SS_4#244
    TheDiggers
    109500x99780ceab5e77f319d92f22301f75bf49380c7cf
    6
    SS_4#37
    Legendary
    82420x7de501190ad282b7e9db78991b5a6a7e87d37643
    7
    SS_4#420
    Bartertown Warlords 420
    81500xf607fff17af11e93d594cead88c409c32943ba20
    8
    SS_4#101
    IB ARC Community
    42100x93a1ba963fc77591ebcf9731feec412764d7abf1
    9
    SS_4#349
    Land 349
    22180x052d34efb55c755177b056b05f13fd02f07c35c0
    9
    771B
    220s