PLAYER_PROFILE | CARGO_FLEET | |
|---|---|---|
1 | GhMpDXZ9bTJtsyCehMCWQBmaaDGcmJsPM3RbQ6zy8L4C | 7naq4Fqisq5mZ8iBxHuWoVVdPEdZdpomMqa2WxNkNjeg |
2 | 5XAqrjvqjSMATZWoaSp33927vK4KyFpqZB8p4x6XArKX | qrYFNcsWeLDsnKnJvH21A9FopbaTezmtd55LxnrWGxN |
3 | H1J9N8Sr6zdmKa5EvF4HW8tHHz45KeLVAB1gd9JUv2wj | GvGCDngfktJ5PMLHBdLrAZcd6g3D8aRZwLfZh4eRRWtp |
4 | A2ywvBAS1iwwFaJtmzXxMSGHPF1PGHRurNFtuSvL4EuS | 8BUSqEBdShCxKQidoiNWpGtJqEjxVtv97ofvDetEff43 |
5 | HeRYysmTv3gxpBrngirUau5UnwJ6ZxULSCU7sCFmLpXf | 5F7kNSceBD9XHVKJw9Q3fKB6Qam4ScS48ztAt9vfLS1X |
6 | 8csyTjRYyEW1jySCG1hY8VXeMFaogtBX7CmffZLxTEhf | D68rApBeeAA7ze5WnToxPcG6duvmFySSaVyYq7NkA3bn |
7 | AJ2snfS7NfLDJtiBfvG9Kodi51X17rvYx4t6H4MoSTyd | Fc8Qb1kEFnnfvB3v5WPDo4vkANzpGB6qm8SyquAQMrm1 |
8 | FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB | 7Aj9nRRQEzREUar6HgWbPKipQxvWEpRpjW4yTfBcbSbP |
9 | DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC | 4cPrBRvahu8fWp1kKKxi15CprfjqEYzXLqL5FcP7zGLb |
10 | BwQZ3Sa1FcoWkvFaGhe6dcPFN3RFcwNEcEyWePVVBraK | 46FUbtCsVDYqsj2J16fD4CMQV9GY1Q8hHq1TdrRUSs4s |
11 | 8nCEkbxQ3UYAXWLuFCbYpkiGWkP9pwfDYVGuaJ4NcemT | W9Y53wgdn3vyWyFXjRpdnshnFRANBusbK4VMABcx4dc |
12 | 4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ | CbMmSeCFTeLBq5K2dn9dPerd4crTLDpgg1E5FDM2BpgD |
13 | HDNahLDLjwT3V2JKEYWhAyRRwVnz2hemuucv4Vnw6DLh | Fb2tDTwhd3c75UWoiiy3jVosZqA5aP3sGzYXut45EqC2 |
14 | FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB | Hq15pcnnvWQspQmikEryLoPc1eUAQLPBiXvHJifJUWLN |
15 | 5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn | GHaNUUq2nnEyb5Bp9eQK7gud5tbjczHeLp1ZTepthRfi |
16 | 5VXp4uCSTowJ72qZPKdHktUhqZDWG4rAMJYvmtuvs3X2 | Fqk6MG1dQKTyfF5tJsKXGosoBFNLVDPQYaAFYHcGsseW |
17 | 5RtTP651dADSzV3PyfpVu8qjxRDGerRQdVQR5MZzjr84 | Aa7pMb1sqHxGXGghCu3zWF2h4HU7LgXTe1Za1zrSUWxH |
18 | FATwbD2bwhrAedrLxdihCrsnYTg4GFMBRBqZ9RxxivdC | CJNuxpf8AKGFuz8W1Dm1aDqSzkpWifSakyg2eSnhELso |
19 | 5RtTP651dADSzV3PyfpVu8qjxRDGerRQdVQR5MZzjr84 | 3SBNZBitsQnterhpiiQq76BXw4pomNpobo7uQmwMyhb4 |
20 | 68AbkXu8H48GiEb2fqnLFef9oGD8yrqUiCum9sDDEPBs | WZ9saAo7NDTWaPQwQjTxz4Und8hkvW85gmsCoQbvfo4 |
AephiaRQ - Cargo Fleets
Updated 52 minutes 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
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH scanning_fleets AS (
SELECT
player_profile
,scanning_fleet
FROM $query('3a8ebe5d-26a2-455a-a891-95f51d6728e5')
GROUP BY 1,2
)
,mining_fleets AS (
SELECT
player_profile
,wallet
,mining_fleet
FROM $query('c8db2715-8e54-400b-b37b-37057390cd40')
GROUP BY 1,2,3
)
,cargo_fleets AS (
SELECT
instruction:accounts[7]::string as player_profile
,instruction:accounts[0]::string as cargo_fleet
FROM mining_fleets mf,
solana.core.fact_events
WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
AND instruction:accounts[7] IN (mf.player_profile)
Last run: about 1 hour ago
...
699
65KB
48s