sssstatisticLand Activity Points - All Time
    Updated 2024-11-27
    -- user land info
    with land AS (
    select
    decoded_log ['account'] AS address,
    decoded_log ['landId'] AS landId,
    block_number,
    block_timestamp
    from
    blast.core.ez_decoded_event_logs
    where
    contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
    and event_name = 'NewAccount'
    UNION
    ALL
    SELECT
    decoded_log ['account'] AS address,
    decoded_log ['toLandId'] AS landId,
    block_number,
    block_timestamp
    from
    blast.core.ez_decoded_event_logs el
    where
    contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
    and event_name in (
    'TeleportToLand',
    'KickPlayerOutOfLand'
    )
    ),
    tables AS (
    -- Lucky Coin 500 points per 10 billion Interest
    select
    decoded_log ['tableId'] AS tableId,
    max(decoded_log ['host']) AS host,
    max(decoded_log ['player']) AS player,
    max(decoded_log ['winner']) AS winner,
    max(decoded_log ['cost'] / pow(10, 18)) AS cost,
    Last run: 3 months ago
    Land ID
    POINTS
    1
    #911567067
    2
    #4051141804
    3
    #397976122
    4
    #37867198
    5
    #339632961
    6
    #512599629
    7
    #349488166
    8
    #406398004
    9
    #54189856
    10
    #333110853
    11
    #291104580
    12
    #198102762
    13
    #21391895
    14
    #6975014
    15
    #30870855
    16
    #20465349
    17
    #20758802
    18
    #43358534
    19
    #42050434
    20
    #15643409
    ...
    555
    8KB
    136s