sssstatisticLand - Level Ranking
    Updated 8 hours ago
    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
    LAND
    Level (Samurai + Pet)
    MEMBERS
    1
    #3334413481
    2
    #405169955
    3
    #37147954
    4
    #406136255
    5
    #63129668
    6
    #512124452
    7
    #339117251
    8
    #91116257
    9
    #108109756
    10
    #156103750
    11
    #78102576
    12
    #420100171
    13
    #16598647
    14
    #10197671
    15
    #54197467
    16
    #25792855
    17
    #45892269
    18
    #30888055
    19
    #19884264
    20
    #5480763
    ...
    555
    8KB
    90s