DATE | PLAYER_PROFILE | CARGO_FLEET | STARBASES | |
|---|---|---|---|---|
1 | 2025-05-12 00:00:00.000 | DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC | BD5aNu6r96YB5C8adC66xnoaTem3dB85r7ZDN2EhuYkT | MRZ_5, MRZ_12 |
2 | 2025-05-02 00:00:00.000 | 6E1wErtuiw7hQJgkPRqStvEzWUmP5XmKMPss8G5UN3uc | H6JxtLksSC5WxuQz3U4MBEVGaNdS1scpLgej9eSHf7PS | ONI_4 |
3 | 2025-05-15 00:00:00.000 | 8nzbA1iQdx6BnJK2bLF7SEYQ4gAJe5YXU298hmXC6d34 | rbQLwXkmeGnS5TmpHzdtXGcB4eVLEXXnEfbATvpmZZu | ONI_1, MRZ_26, MRZ_36, MRZ_25, MRZ_20, ONI_2 |
4 | 2025-05-18 00:00:00.000 | 5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn | CzhNUmkCwvnXQ3f6WtKdeohcX6cT4RhFjTMta32WsJXk | MRZ_20, MRZ_19 |
5 | 2025-05-10 00:00:00.000 | JDw4XDhTtPowdPhxVZ9DF1o9inqYMfLJ1xUsRzjjpw7 | 5CWqU8GL8kor9UTZzoXiMB5aiEFvnbSgiyxahjXU2Gyz | MRZ_35 |
6 | 2025-05-03 00:00:00.000 | 5F5HhVyzz7brdBadLU1XDfg5HwdFxNUD8WeViKjZruoz | 7CdFmneTBesHGbMhyvxXmgdnvDykKgAntp8PY7JLBabD | MRZ_2, MRZ_5, MRZ_7, MRZ_1 |
7 | 2025-05-17 00:00:00.000 | DEkj6TfW88WyrirEByqFTsoXfUfAcEnRsriQY7NEegAn | 7bwP7Y9uEEEzuH6t1uxDEbE1dKPbAQnj8Qy96Vg7JJox | MRZ_19, MRZ_20, MRZ_14, MRZ_18 |
8 | 2025-05-05 00:00:00.000 | ARgWiVzPsdTFr5xUus8DpCkK63BsS5xAc54StfFTRvu | HYVAof2756zH7WBZCSsQmZHvVYEyLffS97k4GR9VVHtM | ONI_3, MRZ_25 |
9 | 2025-05-23 00:00:00.000 | GW28A2tCCd2Z976wLxYSEtEpRcay5EgscyuXLN5fBMEe | HHhJwBwMEyqe9gBnUtCaYbNWUPkRJ8vUenxcWE6gNmmw | MUD_4, MUD_1 |
10 | 2025-05-21 00:00:00.000 | 6E1wErtuiw7hQJgkPRqStvEzWUmP5XmKMPss8G5UN3uc | Csz4cKnyGv15jNYvuiYDASCXTFBnfaNM45qCom7fwS2s | MRZ_20, ONI_4 |
11 | 2025-05-10 00:00:00.000 | 5BECUpf8GdNUJW3WNbDumBv3RXLNbnr7YrMocYUhhYeu | 4PF7tQyA6DMpRY4FvhyuEBxpmWhdbcX4Z24Vr2rEvDKx | MRZ_20, MRZ_14 |
12 | 2025-05-11 00:00:00.000 | 5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn | r6jqNQ2iBNVuk4fAJ6XNhuNytbg34zcwHZgccxo68sz | MRZ_24, MRZ_13 |
13 | 2025-04-29 00:00:00.000 | GC2ZgovudKc7Tt92i3Z8jwgFQ9BDXAiffjJFcbaaftD6 | 2U2StYkt1XBDVeVtfvQN64R9GxgXatrAdB4W9jj7o9i6 | MRZ_22, MRZ_35 |
14 | 2025-05-20 00:00:00.000 | BVUUhbHXTwKA8YbZBRixiG3jYm1QDKPZKnJGL8F5Zb1W | 5NsXrhvCidrMQnTrjfYg2gUfksFJsvnKz4JYs4cFo3Vi | MRZ_18, MRZ_20 |
15 | 2025-05-18 00:00:00.000 | DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC | 33h3SdgCnFdotEDY1AAxfDeKcBUwnFvV2m5DeyozWZUt | MRZ_12, MRZ_5 |
16 | 2025-05-01 00:00:00.000 | 5VXp4uCSTowJ72qZPKdHktUhqZDWG4rAMJYvmtuvs3X2 | Fqk6MG1dQKTyfF5tJsKXGosoBFNLVDPQYaAFYHcGsseW | MRZ_5, MRZ_6 |
17 | 2025-05-04 00:00:00.000 | DArppBrbaULrHLyBKCWxw3cCCndQoAtdt2vZzYvpDVV4 | 3LbuLd3et3oyGFijTi1TmEeLAqVdS32PFfciDAfM9NNE | MRZ_9, MRZ_5 |
18 | 2025-05-13 00:00:00.000 | 93qXpd5i5etD6kH2b7PjKYnJVb5gX3JXXg7WXPhKyDz5 | 3K8CNpXSwL7N2CRF4xaJKY7P3iSmzFveB4Vz7QWjku1g | MRZ_14, MRZ_20 |
19 | 2025-05-22 00:00:00.000 | Aq8VaMA4UsGDgeMSwcNDD9pDMjMwR2ygwr3S9kpPQFKm | HZdJ4L3RNbnczoKuw3Ch2yQ7bdyppd3YLwoKFAZt6qop | MRZ_6, MRZ_12 |
20 | 2025-05-08 00:00:00.000 | FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB | CGKXRixfDk46YrnkNKuKx4ncaJygSXfjekSKJP9vbcVP | MRZ_23, MRZ_22 |
AephiaRQ - Cargo fleets | starbases results
Updated 16 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 16 hours ago
...
13359
2MB
11s