PLAYER_PROFILE | WALLET | MINING_FLEET | |
---|---|---|---|
1 | EaBZtysGxckNWqwKu1ZzcrxfTac8eE6X4AsD3KbPcmdi | AvgWRsp3hytqvZHTzjWvaSXiRh7fYop3fYeYYJKX2EyL | BS5Q3aaYzcSJumfKfRK7aA78SuUseAMEAa29hJkB84Rk |
2 | Grviw9XfGfEkW2AnvMKMSCzsyQU1SZ62wRRrokMdYqpw | 3VV6aT9orL2c1Y4dMvCCirg9qfKC5Uvei8SkHNWXRJ4d | Dtic8eMM2jRuE4VXGQkMfdMyX1cVZ2rzrJVTJYQV1SUF |
3 | 7VGJ7akzxKiN842oPZwpzjNTT7cNhVdJmzsvNgzWtqM1 | 54Yukg7hXhWh8qjh7Mkgtt69PdPKrGDJ3LV1cv9Tdy6v | 63QETA6YjDyXGGk79nhNt5HzUCc3uHiMBQkX1CP9vhSd |
4 | BUDbY4rt6nKE57mP91nHH3fejNb6R4zrnAnfw9m9Si82 | DyLTNBKrsNzp1HEFdPKT92bSiGbkT9qErxfwcTcRtME6 | BLsdFCq5QnT7AJ7TfTALuZ2gDr5sGELDJNcWVCGMyqpc |
5 | Eyf2QJ8yTCu3ZXBz2V3x1J4xQ8twekMgGHChH4g6qA8 | EBZpvy3cLZktkTNxEEdN6xLNY6YtZ7TFQvYChzBdU1Cu | GSwtqhaF2UmhGp8nj823VxbAJazhAjWG57E8CcWua9Ny |
6 | 4ndfZQPLGwJAWBk4aqJdaQGJ8tF9Bg2QKcUs64BsUYWT | hhq2P3TbFBFS7aAKAmnCmRFFcfH4wU6SXVpk4gD2zQJ | HbC7Ew7nhDDTwaDTANaK4qvNAbvJujDNmYpoLCXDQyJd |
7 | FSphdDmBZY15RcfaESsLr99cnQhkHVzdKiV1m5wkdwSc | 8Ah4gVgGh1FANbwfNUgRWZqGsViXbTwFCa8Nd28eJVyo | C2DF3ZTkM1b4cuM4b3RvmZhvNeB9kZprBfg5eJZrTvui |
8 | 3LAt8egSdxoR8ydnboC6rtBi5DqNGxwqvW1J7YWztQJT | 7hZLgnzBfywsmpiYWecKFHNXqvkyhxtQY5vtPsXE9dZc | FgB2qVQ7D9UzVJ8i7hwbcrmTi44UVoU43D1v7tLZZcjd |
9 | 8nCEkbxQ3UYAXWLuFCbYpkiGWkP9pwfDYVGuaJ4NcemT | 6UAZHmbYBKrLTrDK1w8MjihQMaG2HMJN87qudkiNi3uK | BegumnfBJsoD161z5MGk3KhmkWJJzBFYNf2zyhw6kvbY |
10 | FURXQ3hywk4yAJfNCiVQmPeEi29HDAR7Bznw3Rj4ogdr | DFckhQ95raoyrWEKjgmo6Fi6q2k6B5PBdtSsVsQzi447 | 5CLmboG6KxdDeuy96zuQYwCTXwUgM7FpDgtnzE2H83HS |
11 | BjPPHzmpH4wyjLZkV9FcGC4BwPYNi1NHDnSDQs5QztMB | 2mSSPS2k8Zo2aoT7QdNvWRQJMnJQSE3h4ekxR5CUBhqb | 3XtqPF3EUNadHi92AUcBctG1oD4auqGrW3LKsTAjynZQ |
12 | GhMpDXZ9bTJtsyCehMCWQBmaaDGcmJsPM3RbQ6zy8L4C | HTFtsQMhTm9k87GZ6Z5gZqcUkoGPZmbNUsAMRbpr6vj2 | VZY3U9fxhaQPBmvm1vFgZb7HRQpEvQUzkF5A5s83AQj |
13 | FFMNzBgG3rM7KEna5ZNRh7bRUB9dXhcyRS3dczpVzqCV | 3tWVQLggwqGNnoUzBuoFj8w8JatuRBMGH86UDbxz6tNL | B8J26yx78u34C2dV6eYG5A3SJcaLN75mWDRtiGrs8Rqz |
14 | ARiydpFTRRhrhhyGMDLwydwqikUAVa5oXD8sawYAkEmc | 4qyXWSgP9kuMU6NuoPpBhjzm3CvQgZruXWMQrQPv7dE3 | tm5CCw6U6hUD4urWNUd1JVoJLwGUJxCF2P7FYZYrLxK |
15 | Ey1pir4MPEJyDDWzP2h9NrrTTUHf1Tw14Fb9NQzP7YEe | FQ4rzpGAApsi64zDiqSWor8J1yk6oFimRrNzyFXe11gs | EhBSmacr44ZVkCicffGq3uKtS5yo5vT8Fs7D9gg4Lxnb |
16 | G8Kv3sNc7Eq3UeEF4oB17XuYUQSZNPEsQ39NSZhdFoFF | 25Eza4YjNAtiPXD4dNpQg4uvrmyeRxX8TCXAf75nHg3Y | 2t3MTamzeQMrL1GfcBF8AFUKHpg2sVr4JxAqm7vhDWei |
17 | erMQ2AnCm5oFSJLDaNMRBX6C4eauuLMUJrE4NBKXqX1 | 8RwzRvX2Cd1c7u4vX6fWjYByQu6bvPK7qaiJ9aL4vUcc | 5FFoJUFtaZVEeJDpdUyJC4KsMVZ5D3U9PSN1AgpGGxJi |
18 | BYuv7VdfcVgyskjcGgtZfaNfgjtMVregTJHwiPEe6bo3 | 3vC7whN2uKsHeSpL8Mwyw9c6mu5DVNWuS1VAWnii6REd | 4tfamC8NdLmGb9agfGTHhUpbdK7qCPpFTKMo8BNMnZx2 |
19 | BU1ajZM7kQkxqL5yZKZFun86YjLzUGHHXFghbQmoJfjo | Gex9MigVEXuzduZVUTM7LkPnSpBCz4S2AJ6LL7T5FWeQ | 5QqJriNNPiApcw65GWG2RaAgEaDLiXdbd3rKTKroPew |
20 | CFxeBKAybsKbaRKexAcvwXYLfRCkGz4Lu83M4M2swBEi | HSpXKofLEXcm7dgtM9iyT3GUqo9pi9oGuQnUjhQVFTcg | 5sxSRPuxD3LnrGXWZeaERix11JL4veq38JmnjGo64nwc |
AephiaRQ - Mining Fleets
Updated 11 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
⌄
/*
SELECT
instruction:accounts[0] as wallet
,instruction:accounts[1] as player_profile
,instruction:accounts[3] as mining_fleet
FROM solana.core.fact_events
WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
AND instruction:accounts[4] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
AND instruction:accounts[18] = 'MineMBxARiRdMh7s1wdStSK4Ns3YfnLjBfvF5ZCnzuw'
AND succeeded = 'true'
AND block_timestamp > current_date-30 AND block_timestamp < current_date
GROUP BY 1,2,3
*/
--/*
SELECT
player_profile
,wallet
,mining_fleets as mining_fleet
FROM SOLANA.SA.MINING_FLEETS
GROUP BY 1,2,3
--*/
Last run: about 11 hours ago
...
7049
983KB
3s