ludicrousSDU Leaderboard month fixed
Updated 2024-06-29
999
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 tankshipguy-YPATzb / SDU Leaderboard copy @ https://flipsidecrypto.xyz/tankshipguy-YPATzb/q/8IjO5PUs96h4/sdu-leaderboard-copy
-- forked from SDU Leaderboard @ https://flipsidecrypto.xyz/edit/queries/2e02a9dc-fffe-46bb-9db1-f703f4fd524f
WITH scanning AS (
select
--block_timestamp as date,
case when signers[0] = 'FUnDSXuqNmhZxoeE4PC7F199HhrxX3kSBC21XgVRoUxG'
then signers[1]
ELSE signers[0] end as wallet,
----------------------------------------------------
sum(case when value:parsed:info:mint = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'
AND value:parsed:type = 'burn'
then value:parsed:info:amount
end) as FOOD_burned,
sum(case when value:parsed:info:mint = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'
AND value:parsed:type = 'burn'
then value:parsed:info:amount
end) as FUEL_burned,
sum(case when value:parsed:info:mint = 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK'
AND value:parsed:type = 'burn'
then value:parsed:info:amount
end) as AMMO_burned,
sum(case when value:parsed:info:mint = 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL'
AND value:parsed:type = 'burn'
then value:parsed:info:amount
end) as TOOLKIT_burned,
sum(case when value:parsed:info:mint = 'LUMACqD5LaKjs1AeuJYToybasTXoYQ7YkxJEc4jowNj'
AND value:parsed:type = 'burn'
then value:parsed:info:amount
end) as LUMAN_burned,
sum(case when value:parsed:info:mint = 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg'
AND value:parsed:type = 'burn'
then value:parsed:info:amount
end) as ARCO_burned,
sum(case when value:parsed:info:mint = 'HYDR4EPHJcDPcaLYUcNCtrXUdt1PnaN4MvE655pevBYp'
QueryRunArchived: QueryRun has been archived