No Data to Display
AephiaMy mining fleets_earnings
Updated 8 days 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 mining_fleets AS (
SELECT
player_profile
,wallet
,mining_fleets as mining_fleet
FROM SOLANA.SA.MINING_FLEETS
WHERE player_profile = '{{player_profile}}'
)
,last_value AS (
SELECT
*
from $query('6a2519e0-27f9-4633-8fe0-8934f60d6bb2')
)
,mining AS (
SELECT
date
,player_profile
,mining_fleet
,starbase
,asset
,sum(mining_txs) as mining_txs
,sum(ARCO_mined) as ARCO_mined_sum
,sum(BIOMASS_mined) as BIOMASS_mined_sum
,sum(CARBON_mined) as CARBON_mined_sum
,sum(CUORE_mined) as CUORE_mined_sum
,sum(DIAMOND_mined) as DIAMOND_mined_sum
,sum(HYG_mined) as HYG_mined_sum
,sum(FEORE_mined) as FEORE_mined_sum
,sum(LUMANITE_mined) as LUMANITE_mined_sum
,sum(NITRO_mined) as NITRO_mined_sum
,sum(ROCHINOL_mined) as ROCHINOL_mined_sum
Last run: 8 days ago
0
2B
33s