lusinat-yTciEaSponsored Boss event 5 (Dec 10, 3am UTC - Dec 28, 3am UTC) copy copy
Updated 2024-12-23
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
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Sponsored Boss event 5 (Dec 10, 3am UTC - Dec 28, 3am UTC) copy @ https://flipsidecrypto.xyz/studio/queries/ac18d613-bcbe-40cf-b7af-814ec425212c
-- forked from sssstatistic / Sponsored Boss event 5 (Dec 10, 3am UTC - Dec 28, 3am UTC) @ https://flipsidecrypto.xyz/sssstatistic/q/m8-bqK4uFc-Q/sponsored-boss-event-5-dec-10-3am-utc---dec-28-3am-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
With nft_info as (
select decoded_log['accountOwner'] AS address,
event_name,
decoded_log['assetId'] AS asset_id,
CASE
WHEN SUBSTRING(decoded_log['assetId'], 5,4) < 2050 THEN 1
WHEN SUBSTRING(decoded_log['assetId'], 5,4) < 2056 THEN 2
WHEN SUBSTRING(decoded_log['assetId'], 5,4) = 2056 THEN 3
WHEN SUBSTRING(decoded_log['assetId'], 5,4) > 2056 THEN 5
ELSE 1
END AS power,
block_timestamp
from blast.core.ez_decoded_event_logs
where contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name in ('WithdrawAsset', 'DepositAsset')
and decoded_log['assetAddress'] = '0xddd29c8b9ef72a11fcd3c97357eb3786bfa3d214'
), deposited_nft AS (
SELECT address,
SUM(power) AS total_power,
COUNT(*) AS total_nft
FROM nft_info n1
WHERE event_name = 'DepositAsset'
AND NOT EXISTS (
SELECT 1
FROM nft_info n2
WHERE n2.asset_id = n1.asset_id
AND n2.event_name = 'WithdrawAsset'
QueryRunArchived: QueryRun has been archived