sssstatisticCheck Level up - Renewal - Harvest
    Updated 2024-10-21
    select
    block_timestamp,
    CASE event_name
    WHEN 'ClaimLevelUpSpentToken' THEN 'Harvest'
    WHEN 'WithdrawRewardFromPool' THEN 'Renewal'
    ELSE event_name
    END AS event_name,
    decoded_log,
    origin_from_address
    from
    blast.core.ez_decoded_event_logs
    where
    contract_address in (
    '0xc48f6213a1a4d3ead79db812c2b91817980532c3',
    -- game
    '0x74d9c915c64ab7587a3abde1827f3a09eac97bac',
    -- the last samurai
    '0xaf466677d96e6df2e31a86fda7e54a31d64647ed' -- flip coin
    )
    and origin_from_address = {{param_Address}}
    and event_name in (
    'ClaimLevelUpSpentToken',
    'LevelUpPet',
    'WithdrawRewardFromPool',
    'LevelUpSamurai'
    )
    order by block_timestamp
    QueryRunArchived: QueryRun has been archived