SAGE scanning leaderboard

AephiaSAGE scanning leaderboard

Updated 1 hour ago

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

	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

...

2163

189KB

104s

flipside

flipside