flipside

    SAGE mining leaderboard
    AephiaSAGE mining leaderboard
    Updated 15 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 15 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,676,547,02118,547,870,83325,051,628,28927,611,401,33009,948,284,636107,655,276,1235,992,831,7885,531,531,04102,881,414,1314,508,009,347212,404,794,539787,854,79346765470211854787083325051628289276114013300994828463610765527612359928317885531531041028814141314508009347212404794539787854793
    2
    		9SKdZ9FikTSuhmMXYp17HXbPNAqr5LFoMEMyzZfVVQeV4,494,104,46818,505,573,56024,978,820,60227,466,340,93509,916,713,109106,869,298,0845,939,716,9675,498,549,32302,851,221,9174,493,021,044211,013,360,009779,948,71844941044681850557356024978820602274663409350991671310910686929808459397169675498549323028512219174493021044211013360009779948718
    3
    		DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC23,510,02511,416,103,42543,756,038,73723,285,761,6884,648,507,8895,195,141,38569,892,331,6746,549,870,6763,299,436,02801,836,686,8444,798,260,895174,701,649,266437,224,23923510025114161034254375603873723285761688464850788951951413856989233167465498706763299436028018366868444798260895174701649266437224239
    4
    		5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn05,261,133,26227,483,059,88419,167,367,45208,428,713,63159,698,479,0736,244,609,6834,836,696,8213,441,206,6402,548,438,0101,440,205,936138,549,910,392437,941,514052611332622748305988419167367452084287136315969847907362446096834836696821344120664025484380101440205936138549910392437941514
    5
    		4vgQD1xCZ1pZ9R8U27d2kRgJZFmeV1qc8N7ehDHbKSQd01,244,124,6069,409,333,67315,723,780,2841,561,177,74819,934,664,15151,338,049,4942,154,633,0482,507,196,34503,579,212,6870107,452,172,036348,041,678012441246069409333673157237802841561177748199346641515133804949421546330482507196345035792126870107452172036348041678
    6
    		FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB2,903,828,7178,464,231,14020,657,715,02811,984,867,54204,610,828,45149,781,894,1313,777,082,8372,637,240,4860603,312,711311,549,946105,732,550,989771,379,6692903828717846423114020657715028119848675420461082845149781894131377708283726372404860603312711311549946105732550989771379669
    7
    		ARgWiVzPsdTFr5xUus8DpCkK63BsS5xAc54StfFTRvu01,644,609,22523,141,218,95312,281,593,48006,573,070,72745,803,460,1624,665,405,9162,421,292,0232,685,085,7881,069,997,0974,284,211,095104,569,944,466652,908,113016446092252314121895312281593480065730707274580346016246654059162421292023268508578810699970974284211095104569944466652908113
    8
    		EBUYGaEExGu5iwatKdMDAeXV96YDbeHC9n48xR59LTdm04,935,632,60924,753,183,3547,088,235,38204,402,936,71050,756,890,1795,727,806,0321,234,681,6793,059,353,210532,588,136658,371,657103,149,678,948432,731,412049356326092475318335470882353820440293671050756890179572780603212346816793059353210532588136658371657103149678948432731412
    9
    		7e1gmus9ZU22k6inn8VoBKwEQpL3W6wZCtQhLhK6X6KN2,125,796,3301,079,610,23613,526,835,8633,916,525,08901,396,712,17731,713,998,3284,296,337,9141,822,947,2280984,237,7091,345,951,70362,208,952,577277,425,769212579633010796102361352683586339165250890139671217731713998328429633791418229472280984237709134595170362208952577277425769
    10
    		Agz8gPriTTuw4U2ZhxYZ64w6bEaBCAtSUUyD48iYkxoS05,611,560,9068,146,410,3849,615,354,135013,679,961,42216,534,478,3481,152,471,42562,741,67878,958,37232,935,363138,436,75055,053,308,783164,647,613056115609068146410384961535413501367996142216534478348115247142562741678789583723293536313843675055053308783164647613
    11
    		AaqHDNcUBWxNcQXcJdH4gQUxd4QmrCjrc8mU2qGhtWJA03,432,910,6068,803,933,7559,616,818,03308,189,358,73817,195,537,2022,164,703,602372,583,741422,154,295342,082,549142,508,39850,682,590,919167,803,71903432910606880393375596168180330818935873817195537202216470360237258374142215429534208254914250839850682590919167803719
    12
    		FGymLRyvMYVEA1eV2FcB7v7e3rcNN1XNE34MNhrSCw6103,752,298,97710,344,609,1406,963,006,12804,518,107,68415,398,069,3733,243,321,7531,087,458,548686,463,757564,404,983113,536,41746,671,276,760220,744,9210375229897710344609140696300612804518107684153980693733243321753108745854868646375756440498311353641746671276760220744921
    13
    		89hQFoWAX3ZBdUnDXvV5GwdjEYBNfNk788Njz3i4BCmD842,152,0535,378,858,4648,789,344,6212,861,198,11801,510,877,88519,803,108,1252,737,113,783738,364,7510366,734,002606,937,88043,634,689,682205,429,79384215205353788584648789344621286119811801510877885198031081252737113783738364751036673400260693788043634689682205429793
    14
    		GbYJXyruJ7CqTtXr8gwZZji3dNabCq83jLk7J7ew6n4S09,616,620,3316,860,556,3763,912,203,042848,128,3962,610,393,39313,642,088,463410,036,8790001,804,876,97539,704,903,855199,946,1780961662033168605563763912203042848128396261039339313642088463410036879000180487697539704903855199946178
    15
    		EAk4QhxiX2VdeonXUSS8zsBAgST2tmv2LhkwwSVb7Uqy503,620,478826,823,20510,598,453,1586,349,448,86403,945,923,83512,412,154,1022,234,077,938513,944,7130133,994,6051,704,555,80539,222,996,703153,026,425503620478826823205105984531586349448864039459238351241215410222340779385139447130133994605170455580539222996703153026425
    16
    		4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ905,820,8842,343,556,5416,756,970,6962,312,620,95001,581,974,95318,563,066,7601,184,545,589914,454,1110446,141,2611,371,699,97936,380,851,724180,022,478905820884234355654167569706962312620950015819749531856306676011845455899144541110446141261137169997936380851724180022478
    17
    		HeRYysmTv3gxpBrngirUau5UnwJ6ZxULSCU7sCFmLpXf519,480,151321,650,56810,294,448,5343,665,155,65003,762,027,30711,800,308,5042,195,609,8781,456,354,1110449,094,1741,363,818,67535,827,947,552156,970,5205194801513216505681029444853436651556500376202730711800308504219560987814563541110449094174136381867535827947552156970520
    18
    		HeoRu2gu4XhVHbg4BVdMX7S7XXhEDRaPUSSEC1coGrtg1,508,517,8102,318,259,2536,788,197,0693,285,415,24801,087,490,10316,612,941,9532,395,736,618171,773,120082,226,1571,292,092,25335,542,649,584136,433,851150851781023182592536788197069328541524801087490103166129419532395736618171773120082226157129209225335542649584136433851
    19
    		5BECUpf8GdNUJW3WNbDumBv3RXLNbnr7YrMocYUhhYeu01,146,491,9956,111,793,2734,011,214,73501,013,917,37315,143,144,7871,008,612,938553,845,3331,494,835,444263,744,676926,714,85031,674,315,404276,684,664011464919956111793273401121473501013917373151431447871008612938553845333149483544426374467692671485031674315404276684664
    20
    		2187Kyeid6AMMDMH6GQwbjgauuA2AUUmDxzJab9PLy4U09,689,95983,304,666101,299,987082,459,43629,086,940,2784,898,2652,596,247131,4811,275,221029,372,595,5406,177,7290968995983304666101299987082459436290869402784898265259624713148112752210293725955406177729
    ...
    18688
    3MB
    258s