sssstatisticTOP Rice Bag
    Updated 2025-01-14
    With total AS (
    select
    SUM(
    CASE event_name
    WHEN 'ClaimPoint' THEN decoded_log ['points']
    WHEN 'ClaimPointOfLand' THEN decoded_log ['totalPoints']
    WHEN 'LandWithdrawRewardFromPool' THEN decoded_log ['points'] * -1
    WHEN 'WithdrawRewardFromPool' THEN decoded_log ['points'] * -1
    WHEN 'KickOutOfThePool' THEN decoded_log ['points'] * -1
    ELSE 0
    END / pow(10, 18)
    ) AS bag
    from
    blast.core.ez_decoded_event_logs
    where
    contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
    and event_name in (
    'ClaimPointOfLand',
    'ClaimPoint',
    'LandWithdrawRewardFromPool',
    'WithdrawRewardFromPool',
    'KickOutOfThePool'
    )
    )
    select
    coalesce(decoded_log ['account'], concat('#', decoded_log ['landId'])) AS account,
    round(SUM(
    CASE event_name
    WHEN 'ClaimPoint' THEN decoded_log ['points']
    WHEN 'ClaimPointOfLand' THEN decoded_log ['totalPoints']
    WHEN 'LandWithdrawRewardFromPool' THEN decoded_log ['points'] * -1
    WHEN 'WithdrawRewardFromPool' THEN decoded_log ['points'] * -1
    WHEN 'KickOutOfThePool' THEN decoded_log ['points'] * -1
    ELSE 0
    END / pow(10, 18)
    )) AS "Rice Bag",
    Last run: about 1 month ago
    ACCOUNT
    Rice Bag
    Percent
    1
    0xe8f3ca605e29eeba962a527b360351a66c882d50155490136208.292
    2
    0xe379f51d31a754d01a440819c384ba5126bbbd96116946284996.2365
    3
    0x768edd76e031c306e914023e5111dfa00115b4ba76663222034.0883
    4
    0x4b09c6b3a9ca43d108bcb1e17eace8adc3abe1da59526737113.1745
    5
    0x20b6d03a0caedfe4409f75f14dfd94838b86419959075776983.1504
    6
    0x3b9ef63b6566d7e4f18e1666e8536da697d001b049605614262.6454
    7
    0x723ceb055045433c642afcc2735e11bc9d9d7e7349500540182.6398
    8
    0x915db307039201053e0e8ccc8941cefe9f2c894846646411892.4876
    9
    0x9ab8117c4bf86010fd378e7fb9d6b9986d9ffe2145997933222.453
    10
    #51245096012962.4049
    11
    #40545096012962.4049
    12
    #3745096012962.4049
    13
    #15645096012962.4049
    14
    0x28d9682fd14e84129ec22e9e2201e335771da39640598989732.1651
    15
    0xc9c11dda6a034af5bfbd8c86adac0a331299e52b37241023441.986
    16
    0xea6a3b3f6e3a48d71e19e327eeca7bd64ad7cefe36076810371.9239
    17
    0x9d7b5f8a7abbad6ee526b88082e42dc525a84a0329769680281.5876
    18
    #5428684537551.5297
    19
    0x01a1bc8b2e4f069668f7e7b5579cba0b725b5a6b26036323801.3885
    20
    0xa43fb71a4ce839d8232b6b5b9703c000fe2fcc1925736048751.3725
    ...
    5140
    263KB
    119s