PLAYER_PROFILE | FOOD_BURNED | SDU_COLLECTED | FOOD_BURNED_24H | SDU_COLLECTED_24H | FOOD_BURNED_SORT | SDU_COLLECTED_SORT | FOOD_BURNED_24H_SORT | SDU_COLLECTED_24H_SORT | |
---|---|---|---|---|---|---|---|---|---|
1 | FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB | 1,847,720,037 | 95,770,241 | 31,247,501 | 1,470,879 | 1847720037 | 95770241 | 31247501 | 1470879 |
2 | DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC | 3,337,146,216 | 138,805,855 | 38,066,270 | 1,453,046 | 3337146216 | 138805855 | 38066270 | 1453046 |
3 | BVUUhbHXTwKA8YbZBRixiG3jYm1QDKPZKnJGL8F5Zb1W | 4,782,118 | 104,599,769 | 438,278 | 1,252,139 | 4782118 | 104599769 | 438278 | 1252139 |
4 | BxYDuNR9AufjcT5DWrUFQgToF77ceESSACG8EbX8DE8r | 2,259,723,437 | 116,227,724 | 35,558,047 | 1,127,499 | 2259723437 | 116227724 | 35558047 | 1127499 |
5 | 7Ac12FJEM95X21QCFo3jC6wds1cYQxxwJHUvtEVJf3SX | 1,081,022 | 238,737,140 | 233,920 | 1,068,795 | 1081022 | 238737140 | 233920 | 1068795 |
6 | BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN | 56,427,089 | 21,100,072 | 2,433,612 | 802,035 | 56427089 | 21100072 | 2433612 | 802035 |
7 | DCNuSEAgHMus5FGykLTPJuoraSvdNbTsUod5w6JAXw5U | 115,668,164 | 39,501,740 | 1,151,312 | 495,327 | 115668164 | 39501740 | 1151312 | 495327 |
8 | 4vgQD1xCZ1pZ9R8U27d2kRgJZFmeV1qc8N7ehDHbKSQd | 574,238,503 | 95,041,653 | 4,268,503 | 492,493 | 574238503 | 95041653 | 4268503 | 492493 |
9 | ARgWiVzPsdTFr5xUus8DpCkK63BsS5xAc54StfFTRvu | 11,120,483 | 43,218,284 | 769,824 | 414,920 | 11120483 | 43218284 | 769824 | 414920 |
10 | FGymLRyvMYVEA1eV2FcB7v7e3rcNN1XNE34MNhrSCw61 | 13,511,751 | 107,449,723 | 51,920 | 369,789 | 13511751 | 107449723 | 51920 | 369789 |
11 | 7jKp5e9jgjHn6mLaoHNpzze4ZC31uixfJABsj85SjC8m | 224,245,568 | 85,271,976 | 360,180 | 305,496 | 224245568 | 85271976 | 360180 | 305496 |
12 | 7X2qXTB4LR7r7s9NLp2ZZFpvQNhrmFZJ7WpyaqbkRKjx | 11,570,189 | 7,870,332 | 347,822 | 282,484 | 11570189 | 7870332 | 347822 | 282484 |
13 | HFGnp4YDBcCUVaXQNadg42XUf4zC7vQEYoACEXnvnRmn | 110,151,033 | 13,089,980 | 4,359,063 | 267,795 | 110151033 | 13089980 | 4359063 | 267795 |
14 | HeoRu2gu4XhVHbg4BVdMX7S7XXhEDRaPUSSEC1coGrtg | 169,522,123 | 14,679,318 | 4,567,414 | 266,636 | 169522123 | 14679318 | 4567414 | 266636 |
15 | 7e1gmus9ZU22k6inn8VoBKwEQpL3W6wZCtQhLhK6X6KN | 189,655,605 | 27,958,957 | 3,598,420 | 259,549 | 189655605 | 27958957 | 3598420 | 259549 |
16 | GbYJXyruJ7CqTtXr8gwZZji3dNabCq83jLk7J7ew6n4S | 249,079,339 | 29,535,605 | 2,891,455 | 257,004 | 249079339 | 29535605 | 2891455 | 257004 |
17 | 8GL7D7yQi6fRpMs6dugVmz9TLSrpwYoR71ewpFiekKBL | 43,172,826 | 16,864,037 | 676,104 | 256,371 | 43172826 | 16864037 | 676104 | 256371 |
18 | 5BECUpf8GdNUJW3WNbDumBv3RXLNbnr7YrMocYUhhYeu | 420 | 47,528,967 | 246,314 | 420 | 47528967 | 0 | 246314 | |
19 | DaFGAcMaQ7gNygyjbTJujzUE5uwKrtXtgRyMCLtV1wvR | 413,765,599 | 16,360,708 | 5,434,381 | 243,951 | 413765599 | 16360708 | 5434381 | 243951 |
20 | HUmgEebQnh7CDVByo4Vz85JUHXw4ashNcjGmfe3tPzmm | 97,519,350 | 21,132,649 | 1,564,992 | 231,646 | 97519350 | 21132649 | 1564992 | 231646 |
AephiaSAGE scanning leaderboard
Updated 1 hour ago
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
›
⌄
WITH scanning AS (
select
instruction:accounts[1] as player_profile
----------------------------------------------------
,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:authority IN ('C2478tbSLC1gfcDuCyr4pv66QQiybn77EiR1a4k7htT5')
AND value:parsed:type = 'transfer'
then value:parsed:info:amount
end) as SDU_collected
---------------------------------------------------------------
from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
AND succeeded = 'true'
AND instruction:accounts[4] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
AND instruction:accounts[18] = 'DataJpxFgHhzwu4zYJeHCnAv21YqWtanEBphNxXBHdEY'
AND instruction:accounts[24] = 'Point2iBvz7j5TMVef8nEgpmz4pDr7tU7v3RjAfkQbM'
--AND tx_id = '35gjyumTsW9wr7taN3rx8NeyDfKWFKofNGby6HXPt6eY8qZCXqnnnEkR4FtNXL64r6d4skEV1VTrGfhfX5hMrtue'
AND block_timestamp > '2024-04-01' --AND block_timestamp < current_date
group by 1
),
scanning_24h AS (
select
instruction:accounts[1] as player_profile
----------------------------------------------------
,sum(case when value:parsed:info:mint = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'
AND value:parsed:type = 'burn'
then value:parsed:info:amount
Last run: about 1 hour agoAuto-refreshes every 12 hours
...
2163
189KB
104s