AephiaRQ - Cargo Fleets
Updated 1 hour 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)