SAGE upkeep leaderboard

AephiaSAGE upkeep leaderboard

Updated 13 hours ago

WITH starbases_tier (starbase, tier) AS (

SELECT

FROM $query('c7032c69-c096-412e-bc89-46fbfa63d7c9')

)

,upkeep AS (

SELECT

starbase

,case when tier = 1 then 103

when tier = 2 then 154

when tier = 3 then 206

when tier = 4 then 258

when tier = 5 then 306

when tier = 6 then 361

end as food_s

,food_s * 86400 * 30 as sb_upkeep_30days_sort

FROM starbases_tier

group by 1,2

)

,SAGE_upkeep AS (

SELECT

instruction:accounts[9]::string as player_profile

,case when instruction:accounts[1] = '98E4PDEwAYFCNcdbt5EL7JYMj5Rqpd4BkMRsDuYBaytF'

then 'MRZ_1'

when instruction:accounts[1] = 'mAfGxchko6ZU8bRpVHQHXjfYEGBsPwmzGWxUuo4csCa'

then 'MRZ_10'

when instruction:accounts[1] = '6nuTqwN5pPaF7KrPg6A82HigwwzuXPA4hRomfvmQyY8t'

then 'MRZ_11'

when instruction:accounts[1] = '4a1ZvTYdSxo688PNqVwWHzmnoLkm2Hw246DGwxRw8PTE'

Last run: about 13 hours ago

	PLAYER_PROFILE	FACTION	STARBASE	FOOD_UPKEEP	FOOD_UPKEEP_TOTAL_PP	FOOD_UPKEEP_TOTAL_SB	SB_UPKEEP_30DAYS	PLAYER_UPKEEP_SB_PCT	SB_UPKEEP_TIMES_PCT	FOOD_UPKEEP_SORT	FOOD_UPKEEP_TOTAL_PP_SORT	FOOD_UPKEEP_TOTAL_SB_SORT	SB_UPKEEP_30DAYS_SORT	PLAYER_UPKEEP_SB_PCT_SORT	SB_UPKEEP_TIMES_PCT_SORT
1	BxYDuNR9AufjcT5DWrUFQgToF77ceESSACG8EbX8DE8r	USTUR	MRZ_21	332,127,961	345,476,761	630,898,306	793,152,000	52.64%	79.54%	332127961	345476761	630898306	793152000	52.643660292	79.543177852
2	CHdDaGKnxHqreQzZ3NZpdd7TbehcuSTeHZwRyenuxTUa	MUD	MRZ_9	301,409,001	310,393,106	722,606,567	793,152,000	41.71%	91.11%	301409001	310393106	722606567	793152000	41.711356465	91.105685543
3	BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN	USTUR	MRZ_22	297,332,844	297,332,844	649,399,585	793,152,000	45.79%	81.88%	297332844	297332844	649399585	793152000	45.785807516	81.875805016
4	JDw4XDhTtPowdPhxVZ9DF1o9inqYMfLJ1xUsRzjjpw7	USTUR	MRZ_23	267,639,636	272,794,962	698,611,561	793,152,000	38.31%	88.08%	267639636	272794962	698611561	793152000	38.310221436	88.080413464
5	89hQFoWAX3ZBdUnDXvV5GwdjEYBNfNk788Njz3i4BCmD	USTUR	MRZ_28	247,288,012	274,017,888	251,811,754	533,952,000	98.2%	47.16%	247288012	274017888	251811754	533952000	98.203522303	47.159998277
6	Agz8gPriTTuw4U2ZhxYZ64w6bEaBCAtSUUyD48iYkxoS	ONI	MRZ_30	231,203,838	247,839,739	458,896,896	668,736,000	50.38%	68.62%	231203838	247839739	458896896	668736000	50.382523834	68.621533161
7	6vP5iauUBxjJBcDEUyMe41sWo4rtRKwjm1MPNRYBZHMi	USTUR	MRZ_23	226,776,628	255,114,036	698,611,561	793,152,000	32.46%	88.08%	226776628	255114036	698611561	793152000	32.46104712	88.080413464
8	JCPgwqkNTx79FkeZwptbZUN1mzHLw7mWKbMH4xroSxbT	MUD	MRZ_9	207,790,824	218,290,824	722,606,567	793,152,000	28.76%	91.11%	207790824	218290824	722606567	793152000	28.755734239	91.105685543
9	5BECUpf8GdNUJW3WNbDumBv3RXLNbnr7YrMocYUhhYeu	ONI	MRZ_20	183,913,546	193,213,546	774,206,779	793,152,000	23.76%	97.61%	183913546	193213546	774206779	793152000	23.755093728	97.611400967
10	HeRYysmTv3gxpBrngirUau5UnwJ6ZxULSCU7sCFmLpXf	USTUR	MRZ_21	181,065,040	198,421,156	630,898,306	793,152,000	28.7%	79.54%	181065040	198421156	630898306	793152000	28.699560338	79.543177852
11	8bg1jCWanSquMo1EhsYofbsUoV1vQaFCvwbjucq1fEF7	USTUR	MRZ_35	154,100,795	154,100,795	165,715,432	533,952,000	92.99%	31.04%	154100795	154100795	165715432	533952000	92.991215809	31.035642155
12	G6LqzGw77S6HdYP7hWUAmwzHE4iTB7fwGuwJP8TBbBXp	MUD	MRZ_7	148,950,000	150,350,000	629,727,273	668,736,000	23.65%	94.17%	148950000	150350000	629727273	668736000	23.653096568	94.166797211
13	FTZpQHfqWkk9W9uvP9VXu9EDJYezbWJdYqpcKJ9iYtpF	MUD	MRZ_5	145,183,135	155,530,969	467,110,418	793,152,000	31.08%	58.89%	145183135	155530969	467110418	793152000	31.081116885	58.892925694
14	4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ	USTUR	MRZ_22	138,660,736	162,669,158	649,399,585	793,152,000	21.35%	81.88%	138660736	162669158	649399585	793152000	21.352144227	81.875805016
15	H9gsnNN4V9soNgx6ALAoDQ2RHuY1dsJsGyo1VZpZVPPb	USTUR	MRZ_33	134,985,731	134,985,731	140,568,235	399,168,000	96.03%	35.22%	134985731	134985731	140568235	399168000	96.02861628	35.215306588
16	FsqHiS2J9CGb8hsy8FgoRRYZRctKZcL3yFnCw1eiXr8h	MUD	MUD_1	119,898,132	119,898,132	447,251,635	935,712,000	26.81%	47.8%	119898132	119898132	447251635	935712000	26.807757114	47.798001415
17	CCu68caMd5u9aGSysSpEeXk1BptmuysAey2Bu21q4iPy	MUD	MRZ_6	116,823,116	289,473,622	439,173,562	668,736,000	26.6%	65.67%	116823116	289473622	439173562	668736000	26.600671376	65.672187829
18	CCu68caMd5u9aGSysSpEeXk1BptmuysAey2Bu21q4iPy	MUD	MRZ_7	112,940,457	289,473,622	629,727,273	668,736,000	17.93%	94.17%	112940457	289473622	629727273	668736000	17.934820651	94.166797211
19	AJ2snfS7NfLDJtiBfvG9Kodi51X17rvYx4t6H4MoSTyd	ONI	MRZ_20	105,044,552	107,446,833	774,206,779	793,152,000	13.57%	97.61%	105044552	107446833	774206779	793152000	13.568022762	97.611400967
20	GW28A2tCCd2Z976wLxYSEtEpRcay5EgscyuXLN5fBMEe	MUD	MUD_1	100,476,000	100,476,000	447,251,635	935,712,000	22.47%	47.8%	100476000	100476000	447251635	935712000	22.465205745	47.798001415

...

520

98KB

10s

flipside

flipside