No Data to Display
AephiaMy scanning_earnings
Updated 3 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 scanning AS (
SELECT
date
,player_profile
,round(sum(sdu_found)) as sdu_found_pp
,round(sum(sdu_max)) as sdu_max_pp
,round(sum(food_burned)) as food_burned_pp
,round(sum(fuel_burned)) as fuel_burned_pp
,round(sum(scanning_txs)) as scanning_txs_pp
,round(sum(successful_scans)) as successful_scans_pp
,round(sum(sdu_missing_out)) as sdu_missing_out_pp
,round(sum(sol_payed),4) as sol_payed_pp
from $query('c7d84fbe-8ecd-47da-9564-dce10ed11179')
WHERE player_profile = '{{player_profile}}'
group by 1,2
)
,last_value AS (
SELECT
*
from $query('6a2519e0-27f9-4633-8fe0-8934f60d6bb2')
)
,sdu_calculations AS (
SELECT
x.date
,sdu_found_pp
,sdu_max_pp
,sdu_missing_out_pp
,sdu_price
,atlas_price
Last run: 3 days ago
0
2B
3s