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'

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 decoded_log['seasonId'] = 4

),

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

contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'

and event_name = 'NewAccount'