PLAYER_PROFILE | WALLET | MINING_FLEET | |
---|---|---|---|
1 | HckvThzaqE2dGMgL7QMZpvijzNEqXvCwc1LuRbUVaynu | FYTsQyRbTSYJpDB5jc6eZ8eexeDbT53SiQQReVwEbZ4s | 4HppwmmW32BFF5BxzCwcv8tRHSCGE9FRPTLwrfkGBrA6 |
2 | Dp16VzKVBCC6mrmCw2kCBQqKyys9BMW7GCVkvVcWcMDK | HMhdC7oTUeZw6Vu77N2QgYd2JpYrZUGH2qpEh25MHpPL | 3eZpBdw5iLY4CffgodSMB9MKvqys3oVbPunc5hN1DVjX |
3 | 4QDFnMLvnUexEEvu3C3aGrFoY4nhjET9YvFHoLXVmZC2 | G7rCtW3n8LMNvA7i6y4Lmknc14xK5TQWNdz7y5zHDi4s | DkSxQp56Xpnzig6TwLTKrjEP3R4Vqrbzd2sn2TjDPEYx |
4 | Hwhs5RU7SLUpeJPZwiYh9mbtPo1VRauJTJhKz2fb6yBh | GrLHtGvVkyxCreFKFM4S4ZmHapLLSygMHqUtZmgL7rxH | CaCAM6UiC14dPhyha3vDAYKeTr1EJ2cvDwYsf1ZmDYxi |
5 | FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB | 8fvJhm5p7QQFLRofFHeT1bjNDa8FppZZwLkb6MR257Cp | Gk7deM7EFPunfsZWDK5WtR2JicpZPF9CwEWK3FkWE3WZ |
6 | EUQeqr35qZHURrhpobZyApQ2t67aq2C3THv7ZB6TjCoM | 6FpG4MeQQSKtWuBSgrytkP5N6ucSC6zEg53MnAZf4s3t | 9WAmZdTMdkNSW69UWPTcPpcDVfz28JLcM1yLDeHgDoa2 |
7 | E3fTz863unZTvBP8qs168kP5jdqcMiwdU6gxLJxQMj3P | 4rbaxwc3NfEpqZXETGaNo3obaAsqzNziicLVNSffT2aV | 64dF6y18HKtCghBk1ouDv6nFd7TtCViLtr1bsShZurxL |
8 | DEkj6TfW88WyrirEByqFTsoXfUfAcEnRsriQY7NEegAn | 2p7zX5VA4QfsBkhxkFujhe99RenBhdRS1ocu5mzNJtwG | 2SLpMhjxNmaeTeUrTQjdzDMAmKdE7BtRRwc548N8RwGr |
9 | 3Z5MwAbpw9cX8g1iXLD8iAyo4pYyX9FipzhKdSVepuv7 | 9zGseuC3VELAsyGrH4UX6Ho4bc9DHjT3tno8kNjAdqhc | 2CzRpypamXKTKGBTegQdGyZzFSojfqBcbqAP5pVrMhNn |
10 | 8zH76X5gHQGtYWVuyrqV55wEjeyXnB6wwTeNvXxSkkBg | 8DvdfCwuBgWe5n35wuZch6RSYeixQWWAEbBXPokACDZF | 684FjjARDUXc6h8mGG3qrsJTka6fR2qLiCFggorhXQyo |
11 | E6EU9kmsFS1JHzY4AqXeQDMRAFjcgPAk4T6TBPYnHGZj | Ar43BrdPMfxmiQvk5v18KZr2uAD1jEtQQ7AGFxqhcbdG | 57mbKH2JBXodXnoDJFuEV1fQwpSzAfk7iw21HBZZE4AY |
12 | HUmgEebQnh7CDVByo4Vz85JUHXw4ashNcjGmfe3tPzmm | 9Am7uMJdMysZ9vfp4Jq51ZG9k3EWWhnYuT5f21343N87 | GYUkMFLxZCXVSg6fzyK6Z2oQC5FJt16t35eErJtpnHYu |
13 | AJ2snfS7NfLDJtiBfvG9Kodi51X17rvYx4t6H4MoSTyd | XiqZzgdK3Q44PyCVVZEaDgzwonroEvsEGMCpdyxHLKq | GUwrBvsNbTHZD1ADxQVAMLCfc25aPLFcXvB8qq47qtud |
14 | HHT12Pj8gEZQa7wkfKJscFctWHLki2E84X6w9o1BDa7t | HiNLuzCtrQ3L3fpAGDVvmveirUr9NrfeSBVpk6q1wu6i | HeyeyAhtaD8gv7PTLHmCq84sdrReeYRUVS5x2Lr4HZmf |
15 | 9RHZYBrhHr2GnwBHdjtMnzySDvQpUCLyM9ASrh5Du6mx | 5j4h2pSocNRNFDe8x8vSGXw4GqcyRPosS2UTom7rYzXq | G76NamEvABf8BNHQKrSA5fDJfFTGTCzHYFptEfCTqFj8 |
16 | 8WBtJ19Nu5QxB9zvL5wh9GM3jKdSKHt533AHzTGx6v48 | AFFxj6pKBYwQqvi9T578WV2WsJduybmJBqQ78qqb629 | DPXaT2Fbcq3nARSeRj4q2pzRXgfhSyJ6VuXVpKhSdB1e |
17 | 6uhS13txSQsVYJgPiUdk3HW5unoGhf4ZQW1UFDDX6LzE | Dv3dWayp4aSLjHq73THenXVFRFShXNCt8wc2xPumPw8Z | DgK2euyRXASE5eyNMbZhkaZfitQdXst1UVzAbHHRg42c |
18 | 4izccJWvLaJ1zccuz7ZCdwKGN9E9EpMej4kLAgkZd13B | BzE7THXaYQNbywwk1zhEeUfhxZ3iVc2fvU7wkD6mRdRc | C1h3GrauDAUMn4VBda8Eu2xTkhts7qz7oEkJPFSActxj |
19 | 6c9tMmEWRzzC7b9jnKT4VQT8sycxQE7PXyBiGTNG1VLS | 4Romg1Cf7fY1rUnRiBEUZ3iFcq2DXbRVnvqdrT4JFsf3 | Cc956khPYGWgBTjXjggQmsGdk6uPkse4subDG5wJcqfQ |
20 | e31MkxbQAmMTq1tGfXSWWJhUHdt7ip6fRNVUK8Jf22e | BgHVxDMmQz2hH4LzDuDbnz5Rw22m3PDgkjjiviPVfdEP | EpzcmY9YeA7vZYKP8jhLVH5m8wDWLbWYYHs1vNx1HHeN |
AephiaRQ - Mining Fleets
Updated 4 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 4 hours ago
...
7074
987KB
2s