with megawar_times as (

select

decoded_log['seasonId'] AS season,

to_timestamp(decoded_log['endTime']) + interval '1 hour' AS start_time,

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

from blast.core.ez_decoded_event_logs

where

contract_address in (

'0xc48f6213a1a4d3ead79db812c2b91817980532c3'

)

and event_name in (

'NewSeasonStarted'

)

),

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'

UNION

ALL

SELECT

decoded_log ['account'] AS address,

decoded_log ['toLandId'] AS landId,

block_number,

block_timestamp

from