sssstatisticCheck Level up - Renewal - Harvest
Updated 2024-10-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
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