Season | Land ID | Address | POINTS | |
---|---|---|---|---|
1 | Season: 14 | #291 | 0xe1cb7564b0d24d302700f0028eabf1d728bc10c5 | 10000 |
2 | Season: 14 | #405 | 0xca3b2189f5db6bd0ec19ca4d494f6e941bc3720f | 10000 |
3 | Season: 14 | #405 | 0xeb2920063e4383c6e46d4a1a5d70fa0f774bba24 | 10000 |
4 | Season: 14 | #291 | 0x340784cfd0161808ea537e2754f21179c69b50c3 | 10000 |
5 | Season: 14 | #405 | 0xeb5deee8e8276bce3f6c7d270c89db64439c9beb | 10000 |
6 | Season: 14 | #405 | 0xf20faee81a28055e0944a94ba81cb97fbe29800a | 10000 |
7 | Season: 14 | #91 | 0xe96ba81cfe4c8f3d5efdc3304650ee43ac4d3846 | 10000 |
8 | Season: 14 | #405 | 0xe379f51d31a754d01a440819c384ba5126bbbd96 | 10000 |
9 | Season: 14 | #405 | 0x28d9682fd14e84129ec22e9e2201e335771da396 | 10000 |
10 | Season: 14 | #405 | 0x8a3f879a6f0b2d53ad6fd2bbd99e8cf2ed3e6964 | 10000 |
11 | Season: 14 | #405 | 0xeea94d300f91cd5aea476b22b367640a7f0fa81b | 10000 |
12 | Season: 14 | #291 | 0xbfe5283b8529511657fac441d9acd098a8deea87 | 10000 |
13 | Season: 14 | #405 | 0x62ec1636785797e3c312197a108c018448e72736 | 10000 |
14 | Season: 14 | #405 | 0xc88fc061b5cf8c0152bef4d48b42422ff1ba9b3a | 10000 |
15 | Season: 14 | #405 | 0x7841d3173d36b23a1d3ab30e898f21df1da8b750 | 10000 |
16 | Season: 14 | #405 | 0x790e3620d2e4c920727ae7619806bcda88859f55 | 10000 |
17 | Season: 14 | #333 | 0x497189977ffb615aebb8940c808799adb8f784cb | 10000 |
18 | Season: 14 | #37 | 0x18a7ae7693c3da9219a33f7a8fcdd12398c0f4c5 | 10000 |
19 | Season: 14 | #405 | 0x4b09c6b3a9ca43d108bcb1e17eace8adc3abe1da | 10000 |
20 | Season: 14 | #405 | 0xef4f17f9a82bc551ad0c2acb15ac4c26f5cd0bee | 10000 |
sssstatisticLand Contributors - Season - Search
Updated 2024-11-27
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
›
⌄
⌄
-- land war season time
/**
WHEN decoded_log['seasonId'] = 3
THEN to_timestamp(decoded_log['endTime']) + interval '8 day' - interval '1 hour'
WHEN decoded_log['seasonId'] = 4
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '10 hour'
WHEN decoded_log['seasonId'] = 5
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '10 hour'
WHEN decoded_log['seasonId'] = 6
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '10 hour'
WHEN decoded_log['seasonId'] = 7
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '10 hour'
WHEN decoded_log['seasonId'] = 8
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '10 hour'
WHEN decoded_log['seasonId'] = 9
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '11 hour'
WHEN decoded_log['seasonId'] = 10
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '11 hour'
WHEN decoded_log['seasonId'] = 11
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '11 hour'
WHEN decoded_log['seasonId'] = 12
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '11 hour'
WHEN decoded_log['seasonId'] = 13
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '11 hour'
WHEN decoded_log['seasonId'] = 14
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '11 hour'
WHEN decoded_log['seasonId'] = 15
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '11 hour'
**/
with megawar_times as (
select
decoded_log['seasonId'] AS season,
to_timestamp(decoded_log['endTime']) + interval '1 hour' AS start_time,
CASE
WHEN decoded_log['seasonId'] = 16
Last run: 3 months ago
...
848
59KB
48s