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'

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 = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'

AND event_name = '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 blast.core.ez_decoded_event_logs el

WHERE contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'

AND event_name = 'TeleportToLand'

),

tables AS (

SELECT

decoded_log['tableId'] AS tableId,

MAX(decoded_log['host']) AS host,

MAX(decoded_log['player']) AS player,