flipside

    SAGE mining leaderboard
    AephiaSAGE mining leaderboard
    Updated 7 hours ago
    WITH profile_wallets AS (
    SELECT
    instruction:accounts[1] as profiles,
    instruction:accounts[0] as wallets

    FROM solana.core.fact_events
    WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
    --AND instruction:accounts[1] = '4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ'
    AND instruction:accounts[4] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
    AND succeeded = 'true'
    AND block_timestamp > '2024-04-04' --AND block_timestamp < current_date

    group by 1,2
    --order by 1 desc

    )


    ,mining AS (
    select
    Case when signers[0] = 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'
    then signers[1] else signers[0] end as wallet

    ----------------------------------------------------
    ,zeroifnull(sum(case when value:parsed:info:authority = 'qe84yNaK76yaZqGqyWJ9A1Npgnt4NSzicbcZvxEQuJy'
    then value:parsed:info:amount
    end)) as ARCO_mined
    ,zeroifnull(sum(case when value:parsed:info:authority = 'CHxH1BkLp5A6VcQFCYqKGW88i5XFJV5KyyxewSiwcbkB'
    then value:parsed:info:amount
    end)) as BIOMASS_mined
    ,zeroifnull(sum(case when value:parsed:info:authority = '6ny545QXZbGDWXo6F7UEVC7MncAzNNxB62tbVoYWG5gs'
    then value:parsed:info:amount
    end)) as CARBON_mined
    ,zeroifnull(sum(case when value:parsed:info:authority = '4rZNPtbe9kD44RNdf5XxB6RBWsWaHTg76esbrkWGpkXU'
    then value:parsed:info:amount
    Last run: about 8 hours agoAuto-refreshes every 12 hours
    PLAYER_PROFILE
    ARCO_MINED
    BIOMASS_MINED
    CARBON_MINED
    CUORE_MINED
    DIAMOND_MINED
    FEORE_MINED
    HYG_MINED
    LUMANITE_MINED
    NITRO_MINED
    ROCHINOL_MINED
    SAND_MINED
    TIORE_MINED
    TOTAL_MINED
    TOTAL_MINED_24H
    ARCO_SORT
    BIOMASS_SORT
    CARBON_SORT
    CUORE_SORT
    DIAMOND_SORT
    FEORE_SORT
    HYG_SORT
    LUMANITE_SORT
    NITRO_SORT
    ROCHINOL_SORT
    SAND_SORT
    TIORE_SORT
    TOTAL_SORT
    TOTAL_24H_SORT
    1
    		BxYDuNR9AufjcT5DWrUFQgToF77ceESSACG8EbX8DE8r4,479,114,43917,649,374,05824,826,091,16926,889,018,80809,728,186,958105,780,998,8075,803,517,8095,531,531,04102,881,414,1314,508,009,347208,077,256,567777,182,31744791144391764937405824826091169268890188080972818695810578099880758035178095531531041028814141314508009347208077256567777182317
    2
    		9SKdZ9FikTSuhmMXYp17HXbPNAqr5LFoMEMyzZfVVQeV4,297,358,81817,607,076,78524,753,283,48226,750,399,65709,696,615,431105,007,317,3715,758,309,0635,498,549,32302,851,221,9174,493,021,044206,713,152,891775,662,04542973588181760707678524753283482267503996570969661543110500731737157583090635498549323028512219174493021044206713152891775662045
    3
    		DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC23,510,02511,416,103,42543,756,038,73723,285,761,6884,468,172,5575,195,141,38566,689,226,0586,549,870,6763,299,436,02801,836,686,8444,798,260,895171,318,208,318538,732,72223510025114161034254375603873723285761688446817255751951413856668922605865498706763299436028018366868444798260895171318208318538732722
    4
    		5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn05,245,569,75526,540,846,32818,837,043,92308,347,039,51859,021,857,3765,875,515,1914,836,696,8213,431,898,1882,548,438,0101,440,205,936136,125,111,046410,987,719052455697552654084632818837043923083470395185902185737658755151914836696821343189818825484380101440205936136125111046410987719
    5
    		4vgQD1xCZ1pZ9R8U27d2kRgJZFmeV1qc8N7ehDHbKSQd01,221,008,4129,255,313,36515,448,228,0451,530,351,22819,471,702,59550,445,051,9602,102,684,8292,463,481,60203,517,639,4940105,455,461,530359,683,721012210084129255313365154482280451530351228194717025955044505196021026848292463481602035176394940105455461530359683721
    6
    		FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB2,745,729,5437,948,185,84120,293,870,18111,583,304,18004,610,828,45147,198,317,2133,357,717,1162,637,240,4860603,312,711311,549,946101,290,055,668819,047,9882745729543794818584120293870181115833041800461082845147198317213335771711626372404860603312711311549946101290055668819047988
    7
    		ARgWiVzPsdTFr5xUus8DpCkK63BsS5xAc54StfFTRvu01,565,457,64222,311,215,88911,859,421,54806,348,186,22244,207,003,1104,508,144,4752,341,328,2022,598,419,7911,043,006,5414,135,332,071100,917,515,491669,922,223015654576422231121588911859421548063481862224420700311045081444752341328202259841979110430065414135332071100917515491669922223
    8
    		EBUYGaEExGu5iwatKdMDAeXV96YDbeHC9n48xR59LTdm04,935,632,60924,276,220,3306,870,711,23704,402,936,71049,188,526,4935,727,806,0321,234,681,6792,871,845,903532,588,136658,371,657100,699,320,786440,746,072049356326092427622033068707112370440293671049188526493572780603212346816792871845903532588136658371657100699320786440746072
    9
    		7e1gmus9ZU22k6inn8VoBKwEQpL3W6wZCtQhLhK6X6KN2,011,983,481980,657,01513,437,300,4233,836,222,95701,396,712,17730,665,272,6954,212,165,6811,822,947,2280984,237,7091,345,951,70360,693,451,069289,436,87620119834819806570151343730042338362229570139671217730665272695421216568118229472280984237709134595170360693451069289436876
    10
    		Agz8gPriTTuw4U2ZhxYZ64w6bEaBCAtSUUyD48iYkxoS05,251,422,6828,146,410,3849,483,225,776013,415,944,91516,373,144,0031,152,471,42562,741,67878,958,37232,935,363138,436,75054,135,691,348191,090,163052514226828146410384948322577601341594491516373144003115247142562741678789583723293536313843675054135691348191090163
    11
    		AaqHDNcUBWxNcQXcJdH4gQUxd4QmrCjrc8mU2qGhtWJA03,324,245,8948,572,831,6679,337,892,36408,189,358,73817,038,874,7212,164,703,602372,583,741422,154,295187,259,312142,508,39849,752,412,732147,406,54203324245894857283166793378923640818935873817038874721216470360237258374142215429518725931214250839849752412732147406542
    12
    		FGymLRyvMYVEA1eV2FcB7v7e3rcNN1XNE34MNhrSCw6103,541,013,50310,117,263,6826,918,593,84104,372,335,67815,109,745,8853,098,573,0031,087,458,548686,463,757543,831,704113,536,41745,588,816,018163,437,7900354101350310117263682691859384104372335678151097458853098573003108745854868646375754383170411353641745588816018163437790
    13
    		89hQFoWAX3ZBdUnDXvV5GwdjEYBNfNk788Njz3i4BCmD682,590,5265,378,858,4648,789,344,6212,808,260,26401,510,877,88519,407,852,1522,737,113,783738,364,7510366,734,002606,937,88043,026,934,328324,006,27268259052653788584648789344621280826026401510877885194078521522737113783738364751036673400260693788043026934328324006272
    14
    		GbYJXyruJ7CqTtXr8gwZZji3dNabCq83jLk7J7ew6n4S09,516,315,3476,763,957,9623,842,004,955786,274,9692,610,393,39312,951,559,261410,036,8790001,804,876,97538,685,419,741162,811,5340951631534767639579623842004955786274969261039339312951559261410036879000180487697538685419741162811534
    15
    		EAk4QhxiX2VdeonXUSS8zsBAgST2tmv2LhkwwSVb7Uqy453,237,758826,823,20510,362,464,1946,333,710,52603,945,923,83511,895,651,1842,212,227,144513,944,7130133,994,6051,704,555,80538,382,532,969122,824,473453237758826823205103624641946333710526039459238351189565118422122271445139447130133994605170455580538382532969122824473
    16
    		4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ878,275,2612,291,321,2336,570,124,2662,204,639,59601,536,575,82018,149,487,2111,136,707,646888,355,8990430,119,8941,352,705,98035,438,312,806181,545,980878275261229132123365701242662204639596015365758201814948721111367076468883558990430119894135270598035438312806181545980
    17
    		HeRYysmTv3gxpBrngirUau5UnwJ6ZxULSCU7sCFmLpXf446,260,378321,650,5689,891,506,9673,385,853,96703,752,731,10511,800,308,5042,195,609,8781,456,354,1110445,425,8771,363,818,67535,059,520,030152,130,961446260378321650568989150696733858539670375273110511800308504219560987814563541110445425877136381867535059520030152130961
    18
    		HeoRu2gu4XhVHbg4BVdMX7S7XXhEDRaPUSSEC1coGrtg1,429,638,3942,242,708,8596,734,685,1403,230,033,23901,087,490,10316,379,278,6272,318,024,595171,773,120082,226,1571,292,092,25334,967,950,487159,403,150142963839422427088596734685140323003323901087490103163792786272318024595171773120082226157129209225334967950487159403150
    19
    		5BECUpf8GdNUJW3WNbDumBv3RXLNbnr7YrMocYUhhYeu01,006,343,7045,842,519,8323,787,515,18501,013,917,37314,489,095,8611,008,612,938553,845,3331,420,903,905263,744,676926,714,85030,313,213,657209,395,067010063437045842519832378751518501013917373144890958611008612938553845333142090390526374467692671485030313213657209395067
    20
    		2187Kyeid6AMMDMH6GQwbjgauuA2AUUmDxzJab9PLy4U09,689,95983,304,666101,217,847082,459,43629,062,405,9774,898,2652,596,24775,0801,275,221029,347,922,6984,078,041096899598330466610121784708245943629062405977489826525962477508012752210293479226984078041
    ...
    18675
    3MB
    750s