crabtriumph-3379Sponsored Boss event 4 (21th Nov 3 AM UTC - 28th Nov 3 AM UTC) copy
Updated 2024-11-24
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
›
⌄
-- forked from sssstatistic / Sponsored Boss event 4 (21th Nov 3 AM UTC - 28th Nov 3 AM UTC) @ https://flipsidecrypto.xyz/sssstatistic/q/m8-bqK4uFc-Q/sponsored-boss-event-4-21th-nov-3-am-utc---28th-nov-3-am-utc
-- forked from Sponsored Boss event 3 (11th Nov 3 AM UTC - 18th Nov 3 AM UTC) @ https://flipsidecrypto.xyz/studio/queries/a75a2560-113b-403a-84fa-91640b0de096
-- forked from Sponsored Boss event 2 (11th Oct 3 AM UTC - 28th Oct 3 AM UTC) @ https://flipsidecrypto.xyz/studio/queries/b7a464ca-116f-40ca-83f0-8e0335dae3f8
-- forked from Sponsored Boss event 1 @ https://flipsidecrypto.xyz/studio/queries/297fc630-a536-4d0b-90c1-9cf6c6c7d37f
select
DECODED_LOG ['attacker'] AS address,
SUM(DECODED_LOG ['damage']) AS total_damage
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name in ('AttackSponsorBoss')
and block_timestamp BETWEEN '2024-11-21 03:00:00.000' and '2024-11-28 03:00:00.000'
group by DECODED_LOG ['attacker']
ORDER by total_damage DESC;
QueryRunArchived: QueryRun has been archived