sssstatisticLand Contributors - Season - filter
    Updated 2024-11-27
    -- 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
    Season
    Land ID
    Address
    POINTS
    1
    Season: 14#1650x1f9c2b1b479318394bfec26190a0661d7362d1ff2828
    2
    Season: 14#1650xff38a4f9b565bd97100f3bd365f682411df08a732680
    3
    Season: 14#1650xabb0dd7ab5b8dacd689f918a690088a55f3549542584
    4
    Season: 14#1650x763f6023a07588e7d1add8ec48e04bb453f7d8a72584
    5
    Season: 14#1650xeef005d7033f58fd92b99556373263249b6de48b2548
    6
    Season: 14#1650x2ac6145a568bfdcc04dd4cbc7c56a14b8f10e1641788
    7
    Season: 14#1650x28eb368411c54c3fa2ec32c35d3bd7b0b83901e41527
    8
    Season: 14#1650xc9c11dda6a034af5bfbd8c86adac0a331299e52b1520
    9
    Season: 14#1650xbcb6f6ab48c265a956f2579e0cb22e851ca1b9d81448
    10
    Season: 14#1650x8d90e6394575e657beaca4b8b1c8877437b272761352
    11
    Season: 14#1650xf5b35db9a515c9899c7b237e835554c101da38021352
    12
    Season: 14#1650x2f68209d6d9b16d9540db1deac4ae93dad8d5a8e1130
    13
    Season: 14#1650x2a7efeba59e8c798ffb337aab4b3621638b4bcc71040
    14
    Season: 14#1650x757956d348c91aa3188e69c377c845127089de401010
    15
    Season: 14#1650xde46478e734fc53a78a7f09b942c845843d7cd711010
    16
    Season: 14#1650x34e5764e4c7e76913dfa13ae3271ca1b8bd13352549
    17
    Season: 14#1650xbe60b2c8f899f7954491dfa354095288dbace2e6399
    18
    Season: 14#1650xfacb231bd59057b17414a91bf28407f4dcd79f48385
    19
    Season: 14#1650x10ce37c48940392578e6f0e4aec0c7663208da60370
    20
    Season: 14#1650x949ff2b890874f36fed2fba85cf8b9de534d75e4368
    48
    3KB
    23s