sssstatisticLand Contributors - Season - Search
    Updated 2024-11-27
    -- 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
    Season
    Land ID
    Address
    POINTS
    1
    Season: 14#291 0xe1cb7564b0d24d302700f0028eabf1d728bc10c510000
    2
    Season: 14#405 0xca3b2189f5db6bd0ec19ca4d494f6e941bc3720f10000
    3
    Season: 14#405 0xeb2920063e4383c6e46d4a1a5d70fa0f774bba2410000
    4
    Season: 14#291 0x340784cfd0161808ea537e2754f21179c69b50c310000
    5
    Season: 14#405 0xeb5deee8e8276bce3f6c7d270c89db64439c9beb10000
    6
    Season: 14#405 0xf20faee81a28055e0944a94ba81cb97fbe29800a10000
    7
    Season: 14#91 0xe96ba81cfe4c8f3d5efdc3304650ee43ac4d384610000
    8
    Season: 14#405 0xe379f51d31a754d01a440819c384ba5126bbbd9610000
    9
    Season: 14#405 0x28d9682fd14e84129ec22e9e2201e335771da39610000
    10
    Season: 14#405 0x8a3f879a6f0b2d53ad6fd2bbd99e8cf2ed3e696410000
    11
    Season: 14#405 0xeea94d300f91cd5aea476b22b367640a7f0fa81b10000
    12
    Season: 14#291 0xbfe5283b8529511657fac441d9acd098a8deea8710000
    13
    Season: 14#405 0x62ec1636785797e3c312197a108c018448e7273610000
    14
    Season: 14#405 0xc88fc061b5cf8c0152bef4d48b42422ff1ba9b3a10000
    15
    Season: 14#405 0x7841d3173d36b23a1d3ab30e898f21df1da8b75010000
    16
    Season: 14#405 0x790e3620d2e4c920727ae7619806bcda88859f5510000
    17
    Season: 14#333 0x497189977ffb615aebb8940c808799adb8f784cb10000
    18
    Season: 14#37 0x18a7ae7693c3da9219a33f7a8fcdd12398c0f4c510000
    19
    Season: 14#405 0x4b09c6b3a9ca43d108bcb1e17eace8adc3abe1da10000
    20
    Season: 14#405 0xef4f17f9a82bc551ad0c2acb15ac4c26f5cd0bee10000
    ...
    848
    59KB
    48s