PLAYER_PROFILE | WALLET | MINING_FLEET | |
---|---|---|---|
1 | e31MkxbQAmMTq1tGfXSWWJhUHdt7ip6fRNVUK8Jf22e | BgHVxDMmQz2hH4LzDuDbnz5Rw22m3PDgkjjiviPVfdEP | CmcubJp9T5BXq4VtjmXfVQP6Lf3PMzfQCcSGzpoXKmbM |
2 | 24X1q1KJYWGAEP731SjvsyywcF9uZ2Mzji34dEKDW7js | FKaARjtHg75T2bwLt9BhWCyGHn4yXXsEhCYuqAH9i8ra | C3XqB6WAR73k8ZCo4v8jKZHbXz5LuSKYTR3HJRzqB48s |
3 | 2b5Pet8C47QqPWfvF8i5neWD4fyqPtEaXXxEuEe3ZJnD | EDYJBBTojUGMqjWBDH4v7uPq1wdDKDRimqGmEtzUY1Z7 | E1XdhhQK1SgXDcyXjkM1prMZ9jtfaLDZCss2R5xwz8fK |
4 | 4QDFnMLvnUexEEvu3C3aGrFoY4nhjET9YvFHoLXVmZC2 | G7rCtW3n8LMNvA7i6y4Lmknc14xK5TQWNdz7y5zHDi4s | GENjp5GLdHMGaBcRvenpKAwx5TtWt3MsWAVeerTUSwqC |
5 | 9ZnzsJ8v6JhyVnz9jj3sEu8Lr2GCVHP3tRGT4una9T58 | E1CWDXQbfkMzgQQmc1MTcWSc49nyo9E1dmeEN8efKXfW | BaMxnFzkNvpQMCtFxmSa3MK3JavmkMQvMAqZmYT5ukyj |
6 | DiZCPvyR24fZGW9L1Jzo88XS3cxWsL6tZmAokWVyAZKy | xCr8mg1Z3VsMhQHD4w7TYHzak5XPjCDrVY4uYWHK4FD | AQv6Q7aZ76ay7tziNr1mvQhzPrgpsyL5EB3BDre9AxqC |
7 | B5o3m5XVgHpmUrxq6hiJcdMNsRVM6Ebc4KRUBtUuNSeX | EoUhKwTHvSjMhd8Fk1tRQ16ETDBrdEUQJ7gExGwqJ98a | AdQvpvNPWCP6xvnea3F1gJPqmcvnwuY1ZaTMj9FXBjJA |
8 | rrUpUPT6GdfKgriygP7TGAvzDGwYAXQDbHnVbcuc9E8 | 8rbs3roSS4xg9KGQGbPrsYN8Kz74hoM4tUJAVxQ3EobA | 7EUw4EAukHTXrhcSRxG6Lv2Hjfu3Ci3NW6kHbMaJf6nL |
9 | BZDVqTmPuLJraYNPTw8Tx61UiGzprEhYgmT6bAj7E1AG | 7RJKkNpi7Dggf7ij7N2eoV6vT5NBd3rV599xK57y7ifw | Hs6nids6GghFsBgdHnUAA81eQFXtnTkrMTWB29jeaZN4 |
10 | Aq8VaMA4UsGDgeMSwcNDD9pDMjMwR2ygwr3S9kpPQFKm | 7uvuw3gcErxG9WZiPCjnZfz7dy25SVEdcVHgVjehWKJt | 5KDrMGzGuKNMTwbUjAVeuRyytK8tijAkhedhuKG8b1ba |
11 | 5ivpiNc4TbJnG7fo89efcNQvJR3MhYT7jdBkaE3hwLR9 | 96WvjosxgopZajLrnz1BzCTzTwA8HavWrpvR7Ker3w5B | 3gvvbmzxCopxfT2A8dQkuAN2CuRR4Kgck9GxxKPEDanD |
12 | DaPrnPeUgN6qLt3hTVKoZQRomDzbzimcaMR5VmNNCVz8 | 6p9JKsgHVso3KcWf9Ffi1GrJLeBkmRz7dFfuNMqymhUx | 6B1tpKz9LYeTbXCEvn9af7UxX8WrER3EYsUCRTJPgAyn |
13 | BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN | 7edjdvKdivY18HpYkSic2mMcvwqeGw2ni19GYXhyi3nn | 3Gqy517211pwpkLyn8w7Sk6ePNug6wc5vkThoYRbpuHZ |
14 | BtojjTREzhFCmcST6KCwEbyPgiJftU1MyAexcZNLLLEK | 7UM3ysfhNHd3XhaXGDz2URxMEtJ9Gn27hmCiVcM5k3e2 | 53tSs9F5hYHTfaf44irALxATB9NHzNftu9EiQ9Y4YejH |
15 | 4YvxUTmDGxFh66tVGC3g2rw2E3JM6dNX6KPMSx7W7FQs | 8duL4GMGK5xC8aQaogkTPfBDmTyWZogGiXrkqxEiErxm | 2p511exRFm5aZas3J2GEKMjRLHLUuEA6u584CzdUmb6V |
16 | 937WbqJhxcM8W4omx9yn4x6XSAAik8y7N5RJsmobAJS9 | 3Pw2yXimrjxkGGQ9SMiz8UNr4LMq4H81nNvEqUvMXPbp | Cptc7A4pg1b2L4fXVk5cWgntCt9QwowwZPxwDdQABU1Q |
17 | 7e1gmus9ZU22k6inn8VoBKwEQpL3W6wZCtQhLhK6X6KN | ESrRf8M6G5gV5xAEHmEeUPBffzXXxU4fb9Hq5iY4ZNC9 | 48hVTPL24hcLNQcMh9QdPnSkFBbobMv5wTZHUwcw1kfr |
18 | BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN | 7edjdvKdivY18HpYkSic2mMcvwqeGw2ni19GYXhyi3nn | 8z6A1QAPeegq2qduRZYfDMNufD6gVSBPkgvKMJ3fHBRV |
19 | Gpmyt2SWFxrJSSbLi1qYC93yFuovnDzSX6eSWcBCyysR | 8hBFAWkSu8rXNHTUNUkgtB99UUYTQ2qqgGCHnmdqtoHV | ERKhXz8PkD8e1AYjSiwKn6pWMohkhLwFxSjFXRWsgraf |
20 | FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB | ECTCD149xHpZSHqG767kSEEKpdLUPKYtDz8XfiwGCFNk | GZf9MMSJa8LGDoJVGwM5LFK5poAA1eSikksQjvErC4id |
AephiaRQ - Mining Fleets
Updated 16 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 16 hours ago
...
7276
1015KB
2s