OUT_TINKER_TIER | TOTAL_OUT_AMOUNT | TOTAL_IN_AMOUNT | RATE | MOON_BURNT | GEAR_BURNT | |
|---|---|---|---|---|---|---|
1 | 1 | 263 | 207 | 78.707224 | 0.526 | 2.63 |
2 | 2 | 58 | 37 | 63.793103 | 5.8 | 29 |
3 | 3 | 486 | 185 | 38.065844 | 486 | 2430 |
4 | 4 | 339 | 69 | 20.353982 | 2034 | 10170 |
csp88gTime traveling luck using $GEAR
Updated 2025-04-30
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 data AS (select TX_HASH, BLOCK_TIMESTAMP, SIGNER_ID, ARGS, LOGS
/*WITH data AS (select **/
from near.core.fact_actions_events_function_call
where RECEIVER_ID = 'aa-harvest-moon.near'
/*where RECEIVER_ID = 'aa-harvest-moon-relics.near'*/
AND SIGNER_ID = '{{Your_wallet_address}}'
/*AND BLOCK_TIMESTAMP > DATEADD(day,-7,GETDATE())*/
AND BLOCK_TIMESTAMP::date >= '2024-08-26'
AND RECEIPT_SUCCEEDED = 'true'
/*AND LOGS[0] LIKE '%Account updated space tinkers lineup%'*/
/*AND ARGS:msg = 'staking relic'*/
/*AND ARGS:receiver_id != 'aa-harvest-moon.near'*/
/*AND ARGS:msg != 'forge gear'
AND ARGS:account_id != 'market.tradeport.near'
AND ARGS:account_id != 'simple.market.mintbase1.near'
AND ARGS:account_id != 'marketplace.paras.near'*/
/*limit 100*/
),
rate_table as(
SELECT /*LOGS,*/
/*LOGS[4] as sent_tinkers,*/
BLOCK_TIMESTAMP,
CAST(
reverse(
substring(
reverse(LOGS [4]),
1,
charindex(' ', reverse(LOGS [4])) -1
)
)as INT) as out_tinker_TIER,
/*substring(LOGS [4],charindex('removed', LOGS [4])+8,charindex('count', LOGS [4], charindex('removed', LOGS [4])+8)-1) as out_tinker_amount,*/
CAST(
substring(LOGS [4],
charindex('removed ', LOGS [4]) + 8,
charindex('space ', LOGS [4]) - (charindex('removed', LOGS [4]) + 9)
Last run: about 2 months agoAuto-refreshes every 24 hours
4
124B
196s