PLAYER_PROFILE | CARGO_FLEET | |
|---|---|---|
1 | J4nGsHVEJ4ZEcmaEb1BJ1ChRDtS93L4ChCfwbnK4dgnj | GENTH8KZHimJx7nLjbmxRemTCowx8y4VaW2peLthxhRS |
2 | DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC | 3T4ei66Jsys9Bajw5R7NXNJPKYjEsf4G7dTayC5qSfjA |
3 | 5agg9QLkhFaDDoEkGRM5eiGxzfWYhNEZ9phJMd6cFow1 | 6yfR6ZNUxFKMMhnaXAo5B92NFTTXDTD4kZohUpCf4kp |
4 | EgXehCkKi4NLWgiCFaVRzh7Hw4rUqaqkW3UUus8coJxb | Cq6DwALtiGpW6dXpprnXywg5AA2hTBSs7jXDCFUQR11K |
5 | HZyKb9hLQjm7YEpM1oP3xQC2snaQims3N5yWz2p7CRHn | 3gxP1hqv9yD1ux7vQBuSjxgVYEdToSxRZ2zaGvL5Wnoj |
6 | BU1ajZM7kQkxqL5yZKZFun86YjLzUGHHXFghbQmoJfjo | Hb4C1WuknyJFezHDcyPrRsfyy9MQt7Z6HKRATFb38iad |
7 | 4iverYQrVrxA4umYzoDYH2Jvojvm9u2cZFSa8eWMVqYm | G471HDKMLf55MVkRpgXoBmDnu3apJb8Fmpp1wn9LF5i |
8 | BPzn5AnR8yNZrQyHs4p182MgiD2PnLrfbyD9KeLw3t7D | 6QXpHPH9o7HK8z1QieVkKoVcz9ttLYaVKy1T1FuYWTgt |
9 | 5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn | 2p868NfJrZSDXmTg7F9PfzTS3yfUs1jJPZh7T4rp8sMM |
10 | 364preq8pHWjMBF5hZv48JEtDXjaP3C7JbUCoudYogVr | B68vTJnyYZEcW3SQXGjZwQwcrDALZCdREGEUCWUArYas |
11 | 93qXpd5i5etD6kH2b7PjKYnJVb5gX3JXXg7WXPhKyDz5 | 33L77CLXGmbrDPkXYkMNheit4Xv8nZgPAwz1cwvVe6Y3 |
12 | 5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn | 6pWLMVmKqLoS6JzQmNQjCwfCJ7hU5rPmTNrwqy7hhwy1 |
13 | DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC | 5pQT1NqcqwQgUitWcJTZXEQtHyaod7CfZNZbf9pC78mF |
14 | FTZpQHfqWkk9W9uvP9VXu9EDJYezbWJdYqpcKJ9iYtpF | DxZMB5Q9oahioLrqqhJZkdGrafBW6yxxTXSSpE7L5gBG |
15 | 36BgqkNhasemZkRGz18f2yDhwoRtHM16nB2wzexGm6xn | E8YrVWX2YtU8pvq1SZPDNXbSUSvdnN1ucyxwYe6qXVs5 |
16 | 329DyXiW66V5EAEF6FNmrrZKnMrMuVEaUV788Hjgbzdq | Hp9Fcpmujg6W94mQHzmRQwdsMt9L8rhswaT6UabBnfic |
17 | HGQb6qsBFyDG1gCkufNV5iUtWRfLB8ypF1Z9KsMuYAig | 8DGpmPyhqe9C6rrjmyRQNd47iYUxfRcCDLoq1zb6jM3M |
18 | 8gZyzhBj1ya6gW1UmYRDxi5bTfpn5aDfXK8dtGbJf9SE | 9GyXXK6iMYPkCC6Jczs5agZWbL5enU3E8LoVTC2nn7jQ |
19 | 5D8cphS3FRWEQYSnYd6HBPxCYyuRjKu98tTZJJfWP6Vn | 6kZKQrFFjfsS7GLpzfT8SHQhPq7g58d5nU6GkyE9kGik |
20 | FuTa9petsdv1bSEAZbBuuNozkT3C3gPtyCSdXbWNk31b | Azqb1JzA3Jvti9jDjwapgkoZUTovmCpFjFYaakCUgf3V |
AephiaRQ - Cargo Fleets
Updated 22 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
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 22 hours ago
...
799
75KB
7s