flipside

    Land Activity Points - Season
    sssstatisticLand Activity Points - Season
    Updated 2025-04-15
    -- forked from Land Contributors - Season - Search @ https://flipsidecrypto.xyz/studio/queries/ac09fa29-ca15-49ff-b481-c8cc2fc5f324

    -- 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,
    Last run: 14 days agoAuto-refreshes every 1 hour
    Season
    Land ID
    POINTS
    1
    		Season: 14#405 245395
    2
    		Season: 14#291 199088
    3
    		Season: 14#91 92226
    4
    		Season: 14#37 85896
    5
    		Season: 14#333 57139
    6
    		Season: 14#339 45450
    7
    		Season: 14#165 38288
    8
    		Season: 14#108 29609
    9
    		Season: 14#406 23657
    10
    		Season: 14#548 21800
    11
    		Season: 14#512 20014
    12
    		Season: 14#308 16409
    13
    		Season: 14#156 9948
    14
    		Season: 14#257 9197
    15
    		Season: 14#340 3767
    16
    		Season: 14#531 3568
    17
    		Season: 14#198 2206
    18
    		Season: 14#154 1944
    19
    		Season: 14#252 1900
    20
    		Season: 14#241 1778
    ...
    208
    5KB
    1s