Season | Land ID | Address | POINTS | |
---|---|---|---|---|
1 | Season: 14 | #165 | 0x1f9c2b1b479318394bfec26190a0661d7362d1ff | 2828 |
2 | Season: 14 | #165 | 0xff38a4f9b565bd97100f3bd365f682411df08a73 | 2680 |
3 | Season: 14 | #165 | 0xabb0dd7ab5b8dacd689f918a690088a55f354954 | 2584 |
4 | Season: 14 | #165 | 0x763f6023a07588e7d1add8ec48e04bb453f7d8a7 | 2584 |
5 | Season: 14 | #165 | 0xeef005d7033f58fd92b99556373263249b6de48b | 2548 |
6 | Season: 14 | #165 | 0x2ac6145a568bfdcc04dd4cbc7c56a14b8f10e164 | 1788 |
7 | Season: 14 | #165 | 0x28eb368411c54c3fa2ec32c35d3bd7b0b83901e4 | 1527 |
8 | Season: 14 | #165 | 0xc9c11dda6a034af5bfbd8c86adac0a331299e52b | 1520 |
9 | Season: 14 | #165 | 0xbcb6f6ab48c265a956f2579e0cb22e851ca1b9d8 | 1448 |
10 | Season: 14 | #165 | 0x8d90e6394575e657beaca4b8b1c8877437b27276 | 1352 |
11 | Season: 14 | #165 | 0xf5b35db9a515c9899c7b237e835554c101da3802 | 1352 |
12 | Season: 14 | #165 | 0x2f68209d6d9b16d9540db1deac4ae93dad8d5a8e | 1130 |
13 | Season: 14 | #165 | 0x2a7efeba59e8c798ffb337aab4b3621638b4bcc7 | 1040 |
14 | Season: 14 | #165 | 0x757956d348c91aa3188e69c377c845127089de40 | 1010 |
15 | Season: 14 | #165 | 0xde46478e734fc53a78a7f09b942c845843d7cd71 | 1010 |
16 | Season: 14 | #165 | 0x34e5764e4c7e76913dfa13ae3271ca1b8bd13352 | 549 |
17 | Season: 14 | #165 | 0xbe60b2c8f899f7954491dfa354095288dbace2e6 | 399 |
18 | Season: 14 | #165 | 0xfacb231bd59057b17414a91bf28407f4dcd79f48 | 385 |
19 | Season: 14 | #165 | 0x10ce37c48940392578e6f0e4aec0c7663208da60 | 370 |
20 | Season: 14 | #165 | 0x949ff2b890874f36fed2fba85cf8b9de534d75e4 | 368 |
sssstatisticLand Contributors - Season - filter
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
›
⌄
-- forked from Land Contributors - Season - Search @ https://flipsidecrypto.xyz/edit/queries/ac09fa29-ca15-49ff-b481-c8cc2fc5f324
-- land war season time
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'] = 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'
WHEN decoded_log['seasonId'] = 16
THEN to_timestamp(decoded_log['endTime']) + interval '5 day' + interval '11 hour'
Last run: 3 months ago
48
3KB
23s