crabtriumph-3379Boss Hunting - Contributors copy
Updated 2024-08-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from sssstatistic / Boss Hunting - Contributors @ https://flipsidecrypto.xyz/sssstatistic/q/FUAFHzKlH8Nr/boss-hunting---contributors
select
CONCAT('#', decoded_log ['bossId']) AS "Boss ID",
origin_from_address AS "Address",
decoded_log ['damage'] / pow(10, 18) AS "Damage",
CASE
event_name
WHEN 'AttackBoss' THEN 'Helper'
ELSE 'Summoner'
END AS "Role",
block_timestamp
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name in ('AttackBoss', 'SummonBoss')
ORDER BY
decoded_log ['bossId'] DESC,
"Role" DESC,
block_timestamp
QueryRunArchived: QueryRun has been archived