DATE | PLAYER_PROFILE | CARGO_FLEET | STARBASES | |
|---|---|---|---|---|
1 | 2025-05-22 00:00:00.000 | 6eAt2sBYAZRZCYNXpLXWNZ4hEFua92Dx9Jpc7CA2KeVb | AKqG4SSSBsrGJpoU3bP6Qk7UVS8ULBE1gi5hn9HHJQnj | MRZ_30, MRZ_26 |
2 | 2025-05-12 00:00:00.000 | BxYDuNR9AufjcT5DWrUFQgToF77ceESSACG8EbX8DE8r | AMwrDaiJgTdWV5gvaZ6LWSWbE17mfXdbtmT8Dxvgu22x | MRZ_23, MRZ_27, MRZ_21 |
3 | 2025-05-24 00:00:00.000 | A8DcLWJjtmUiTwUrNoBNfaaEiV2bX8iJFY66Kr7JiGYC | E8a1YsgafTW4vRuG2dVJ81LVfb4KUeMq2c4RyfdzHGEy | MRZ_22, MRZ_21 |
4 | 2025-05-31 00:00:00.000 | 4T7fXZzWZ6aQxuojAwoh86t1rFwr83PTEahMmZG3ke6L | CgkxofNCzgzosG6HsnZ4QqFHb2Qr1uLtdRkQk5teNt3h | UST_3, UST_1 |
5 | 2025-06-03 00:00:00.000 | ANSB7Ta4Wvn9AzYdFbnwctPrjwfFuVQJyws61r8LQZ1H | AeEBcBgnmSBkZv5XpKi1Y43R83CFiYjwQt5Sk1WJpZZo | UST_3, UST_1 |
6 | 2025-05-25 00:00:00.000 | CJez484FqfxeLN3dJ1UxiknBerm8DzXjSjCr98tZr53p | 8nnJe4z9jsrnwwPGUNi9FrWXjWXkmRBUvjyP4ZTosa5A | MRZ_20, MRZ_30 |
7 | 2025-06-03 00:00:00.000 | GbYJXyruJ7CqTtXr8gwZZji3dNabCq83jLk7J7ew6n4S | BLeWWiCJt3YJyJ3Ad2hSwqRQsbRGhh9PdnMKcU8Dtwsj | MRZ_8, MRZ_9 |
8 | 2025-06-06 00:00:00.000 | CFxeBKAybsKbaRKexAcvwXYLfRCkGz4Lu83M4M2swBEi | 9pvC9GVdb9V5ANxkMSzWVjeiGnDKnaUmiapmv1Zoc9yr | MRZ_5, MRZ_6, MRZ_7 |
9 | 2025-05-29 00:00:00.000 | BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN | hJfkdGBrfWKKJ1Uhsm5cSRudU2TFB2spz85j7m8imbe | MRZ_22, MRZ_21 |
10 | 2025-06-06 00:00:00.000 | HpL9K7he9m9fHaesQaJCo1U91XANpc5oQY2RmaeYkxrM | 3NoLjN5Hzvqsvv5x25cKRyhGAc364ncUAnjfZeBmUZMN | UST_1, MRZ_28 |
11 | 2025-06-08 00:00:00.000 | J15QmmpZDrZP6VP9TzVse6japs1UM1PL1VRJsDKsfSPq | 9xNQatXzvPwX1U1achGnKCkY9YB5VA8jN45tdhkL7G7r | MRZ_1, MUD_1 |
12 | 2025-06-04 00:00:00.000 | HZ8E1pDCoZ24LbY6njkFv5Ey2PhTRVkFqvJVo53mhe1s | 2Uvb7NoV66pGL42Ehbons4JvAToniQtsE8GJUkT7Vbh4 | MUD_1, MRZ_12, MUD_3 |
13 | 2025-06-01 00:00:00.000 | BiqviBoxwC6HSZYrBrDiDw8CmTdhnXayRjJn8mRm2ugY | 9sCHup2NStoa7DRcoXY5yfyqoMqu6aQmuJmgQhkjoHdg | MRZ_7, MRZ_6 |
14 | 2025-06-03 00:00:00.000 | DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC | 33h3SdgCnFdotEDY1AAxfDeKcBUwnFvV2m5DeyozWZUt | MRZ_9, MRZ_6 |
15 | 2025-06-10 00:00:00.000 | 2BwBfNjaxxanE53YjGhyynuDG3AsmgoNVD92xrHoiLLc | 9xf3WDPRFuorh4h6qFs5XD74yJBeqSeAAJiGxPRhtRR9 | MRZ_14, MRZ_19, MRZ_20 |
16 | 2025-05-16 00:00:00.000 | E6EU9kmsFS1JHzY4AqXeQDMRAFjcgPAk4T6TBPYnHGZj | 9bY7tmVtoJJNx86YCZczsN84q9gjKzB1tcAdd9CxqhAr | MRZ_5, MRZ_12 |
17 | 2025-05-22 00:00:00.000 | A9TqUYqC6mQpkndm7Qnvx3LYeVDbVjy8maRaF3DMPDFV | 7yDxPt8AgPAsqsjkqsKY8Wfzb3mRomNLsrwi98QVEd5W | MRZ_20, MRZ_25 |
18 | 2025-05-27 00:00:00.000 | 2BwBfNjaxxanE53YjGhyynuDG3AsmgoNVD92xrHoiLLc | 6QBf7jVGfd1pc1ZK9YTDRy3fdCXFM4e3LQYpi8DAQrhP | MRZ_25, MRZ_20 |
19 | 2025-06-03 00:00:00.000 | 8nzbA1iQdx6BnJK2bLF7SEYQ4gAJe5YXU298hmXC6d34 | rbQLwXkmeGnS5TmpHzdtXGcB4eVLEXXnEfbATvpmZZu | MRZ_18, MRZ_20, MRZ_36, MRZ_24 |
20 | 2025-05-22 00:00:00.000 | H1J9N8Sr6zdmKa5EvF4HW8tHHz45KeLVAB1gd9JUv2wj | 6EJhSkGKvtMFrZQhdnzJ6GMX3XKzAt9tqSzGR9PPihoj | MRZ_5, MUD_1, MRZ_7 |
AephiaRQ - Cargo fleets | starbases results
Updated 17 hours ago
999
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::string as player_profile
,scanning_fleets::string as scanning_fleet
FROM SOLANA.SA.SCANNING_FLEETS
GROUP BY 1,2
)
,mining_fleets AS (
SELECT
player_profile::string as player_profile
,wallet::string as wallet
,mining_fleets::string as mining_fleet
FROM SOLANA.SA.MINING_FLEETS
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)
AND instruction:accounts[2] = 'PiLotBQoUBUvKxMrrQbuR3qDhqgwLJctWsXj3uR7fGs'
AND instruction:accounts[9] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
AND cargo_fleet != ALL (SELECT mining_fleet FROM mining_fleets)
Last run: about 17 hours ago
...
14899
2MB
41s