No Data to Display
AephiaMy scanning fleets_earnings
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 AS (
SELECT
date
,player_profile
,scanning_fleet
,sdu_found
,food_burned
,fuel_burned
,scanning_txs
,successful_scans
,sdu_max
,possible_sdu
,sdu_missing_out
---
,sol_payed
,sum(food_burned) OVER (partition by date, player_profile) as food_burned_pp
,sum(fuel_burned) OVER (partition by date, player_profile) as fuel_burned_pp
,sum(sol_payed) OVER (partition by date, player_profile) as sol_payed_pp
from $query('c7d84fbe-8ecd-47da-9564-dce10ed11179')
WHERE player_profile = '{{player_profile}}'
--group by 1,2,3,4,5,6,ALL
)
,last_value AS (
SELECT
*
from $query('6a2519e0-27f9-4633-8fe0-8934f60d6bb2')
)
,average AS (
SELECT
date
,player_profile
,scanning_fleet
Last run: about 16 hours ago
0
2B
2s