No Data to Display
AephiaMy crafting assets_earnings
Updated 6 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 starbase_player AS (
SELECT
player_profile
,starbase_player
FROM $query('62a2c594-afe5-4164-9a14-81fb22953bdc')
WHERE player_profile = '{{player_profile}}'
)
,crafting AS (
SELECT
*
from $query('f3de628e-8c94-4b12-b4ba-d9a55c0a224f')
WHERE player_profile = '{{player_profile}}'
)
,last_value AS (
SELECT
*
FROM $query('6a2519e0-27f9-4633-8fe0-8934f60d6bb2')
)
,revenue AS (
SELECT
c.date as date
,player_profile
,starbase
,asset
,round(case when asset = 'Aerogel' then crafted * AGEL_price * atlas_price
when asset = 'Ammunition' then crafted * AMMO_price * atlas_price
Last run: 6 days ago
0
2B
10s