0x000eth-sW-WATLucky Coin History copy
Updated 2024-10-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from sssstatistic / Lucky Coin History @ https://flipsidecrypto.xyz/sssstatistic/q/jz0rGB9d55b6/lucky-coin-history
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['reward'] / pow(10, 18)) AS reward
from blast.core.ez_decoded_event_logs
where contract_address = '0xaf466677d96e6df2e31a86fda7e54a31d64647ed'
and event_name in (
'NewTable',
'Play',
'Claim'
)
GROUP BY decoded_log['tableId']
order by tableId DESC
QueryRunArchived: QueryRun has been archived