flipside

    SAGE mining leaderboard
    AephiaSAGE mining leaderboard
    Updated 4 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 4 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
    		BxYDuNR9AufjcT5DWrUFQgToF77ceESSACG8EbX8DE8r5,632,110,80722,139,346,25525,929,343,58130,412,102,688010,742,399,827117,965,314,9486,312,136,2045,884,393,47503,349,065,1294,508,009,347232,874,222,261826,646,608563211080722139346255259293435813041210268801074239982711796531494863121362045884393475033490651294508009347232874222261826646608
    2
    		9SKdZ9FikTSuhmMXYp17HXbPNAqr5LFoMEMyzZfVVQeV5,428,634,88222,094,483,66925,856,535,89430,266,475,699010,709,235,038117,149,706,4376,259,021,3835,838,757,97603,308,304,7264,493,021,044231,404,176,748826,193,795542863488222094483669258565358943026647569901070923503811714970643762590213835838757976033083047264493021044231404176748826193795
    3
    		DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC23,510,02511,416,103,42549,855,308,43823,285,761,6885,729,499,5517,315,178,12774,572,129,8156,549,870,6763,299,436,02801,836,686,8444,798,260,895188,681,745,512551,948,77523510025114161034254985530843823285761688572949955173151781277457212981565498706763299436028018366868444798260895188681745512551948775
    4
    		5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn05,491,087,23529,269,501,91919,875,097,78708,517,370,70361,541,463,5626,831,174,8294,916,322,6643,546,209,6902,602,506,6041,440,205,936144,030,940,929225,596,054054910872352926950191919875097787085173707036154146356268311748294916322664354620969026025066041440205936144030940929225596054
    5
    		FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB3,269,102,79810,527,193,24223,034,160,89813,584,215,60204,610,828,45158,545,161,3155,980,855,9712,637,240,4860603,312,711311,549,946123,103,621,420607,501,81732691027981052719324223034160898135842156020461082845158545161315598085597126372404860603312711311549946123103621420607501817
    6
    		ARgWiVzPsdTFr5xUus8DpCkK63BsS5xAc54StfFTRvu01,990,345,21526,699,493,04014,214,268,44807,703,800,53352,783,285,4595,349,510,7542,653,438,8063,064,480,6241,187,177,5324,905,991,609120,551,792,020666,650,261019903452152669949304014214268448077038005335278328545953495107542653438806306448062411871775324905991609120551792020666650261
    7
    		4vgQD1xCZ1pZ9R8U27d2kRgJZFmeV1qc8N7ehDHbKSQd01,327,842,7149,964,606,25916,721,562,2511,671,547,30821,583,321,33154,579,046,1952,343,992,6852,663,959,34603,808,232,5670114,664,110,6560132784271499646062591672156225116715473082158332133154579046195234399268526639593460380823256701146641106560
    8
    		EBUYGaEExGu5iwatKdMDAeXV96YDbeHC9n48xR59LTdm04,935,632,60926,828,450,1488,039,471,84904,402,936,71057,631,274,8095,727,806,0321,234,681,6793,878,663,191532,588,136658,371,657113,869,876,820443,312,046049356326092682845014880394718490440293671057631274809572780603212346816793878663191532588136658371657113869876820443312046
    9
    		7e1gmus9ZU22k6inn8VoBKwEQpL3W6wZCtQhLhK6X6KN2,477,031,1291,474,091,36114,375,734,1564,258,397,01201,451,036,00935,684,525,8434,752,700,1611,887,788,05101,040,588,6011,348,888,07868,750,780,401210,910,0812477031129147409136114375734156425839701201451036009356845258434752700161188778805101040588601134888807868750780401210910081
    10
    		Agz8gPriTTuw4U2ZhxYZ64w6bEaBCAtSUUyD48iYkxoS05,897,112,1368,788,033,7219,826,528,704014,953,541,25817,914,522,5041,152,471,42562,741,67878,958,37232,935,363138,436,75058,845,281,911180,056,385058971121368788033721982652870401495354125817914522504115247142562741678789583723293536313843675058845281911180056385
    11
    		AaqHDNcUBWxNcQXcJdH4gQUxd4QmrCjrc8mU2qGhtWJA03,738,825,4189,168,962,81310,510,884,74808,883,254,49218,446,153,8422,334,624,673372,583,741563,437,378538,544,823142,508,39854,699,780,326289,851,514037388254189168962813105108847480888325449218446153842233462467337258374156343737853854482314250839854699780326289851514
    12
    		FGymLRyvMYVEA1eV2FcB7v7e3rcNN1XNE34MNhrSCw6104,118,756,78311,078,227,4187,853,032,23104,848,642,75317,220,779,7693,368,165,5041,087,458,548867,156,668623,755,789113,536,41751,179,511,880194,326,6130411875678311078227418785303223104848642753172207797693368165504108745854886715666862375578911353641751179511880194326613
    13
    		89hQFoWAX3ZBdUnDXvV5GwdjEYBNfNk788Njz3i4BCmD844,248,9305,817,472,51010,114,838,9033,240,614,24901,510,877,88522,564,610,1803,135,535,257975,575,3660366,734,002606,937,88049,177,445,162131,631,170844248930581747251010114838903324061424901510877885225646101803135535257975575366036673400260693788049177445162131631170
    14
    		GbYJXyruJ7CqTtXr8gwZZji3dNabCq83jLk7J7ew6n4S010,060,915,3107,756,605,3744,224,889,6041,117,272,2052,610,393,39316,638,221,940410,036,8790001,804,876,97544,623,211,680212,177,307010060915310775660537442248896041117272205261039339316638221940410036879000180487697544623211680212177307
    15
    		EAk4QhxiX2VdeonXUSS8zsBAgST2tmv2LhkwwSVb7Uqy557,793,683927,387,58111,433,541,3706,787,279,61304,116,634,05014,183,338,3692,466,284,921686,360,4280162,315,2491,704,555,80543,025,491,069203,339,560557793683927387581114335413706787279613041166340501418333836924662849216863604280162315249170455580543025491069203339560
    16
    		4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ1,074,526,2362,654,390,1447,496,917,0272,801,580,66801,856,522,71420,867,656,8721,367,793,4971,035,961,0900518,191,5461,458,367,06941,131,906,863205,185,22010745262362654390144749691702728015806680185652271420867656872136779349710359610900518191546145836706941131906863205185220
    17
    		HeRYysmTv3gxpBrngirUau5UnwJ6ZxULSCU7sCFmLpXf738,830,463377,917,47612,961,248,5244,176,384,92703,783,823,59911,812,365,4952,480,464,3061,456,354,1110565,925,8341,363,818,67539,717,133,410163,513,3857388304633779174761296124852441763849270378382359911812365495248046430614563541110565925834136381867539717133410163513385
    18
    		HeoRu2gu4XhVHbg4BVdMX7S7XXhEDRaPUSSEC1coGrtg1,759,156,3382,617,852,9647,115,284,6403,549,453,29501,087,490,10319,054,634,6472,732,982,947171,773,120082,226,1571,292,092,25339,462,946,464155,315,756175915633826178529647115284640354945329501087490103190546346472732982947171773120082226157129209225339462946464155315756
    19
    		5BECUpf8GdNUJW3WNbDumBv3RXLNbnr7YrMocYUhhYeu01,437,889,0417,173,119,8694,663,075,60301,013,917,37317,600,315,1111,300,099,053832,762,3071,813,733,643434,024,087926,714,85037,195,650,937213,956,073014378890417173119869466307560301013917373176003151111300099053832762307181373364343402408792671485037195650937213956073
    20
    		BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN1,056,853,2712,051,232,0265,714,130,6213,086,974,60401,319,127,57822,149,746,9031,486,152,7123,538,97001,980,6961,078,45836,870,815,839382,720,040105685327120512320265714130621308697460401319127578221497469031486152712353897001980696107845836870815839382720040
    ...
    18765
    3MB
    555s