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'

ELSE to_timestamp(decoded_log ['endTime']) + interval '5 day' - interval '1 hour'

END AS end_time

from

blast.core.ez_decoded_event_logs

where

contract_address in (

'0xc48f6213a1a4d3ead79db812c2b91817980532c3'

)

and event_name in ('NewSeasonStarted')

and (

{{Season}} = 0

or decoded_log ['seasonId'] = {{Season}} + 2

)

),

land AS (

select

decoded_log ['account'] AS address,

decoded_log ['landId'] AS landId,

block_number,

block_timestamp

from

blast.core.ez_decoded_event_logs

where