sssstatisticLand Contributors - Search User
    Updated 2024-06-14
    -- 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'
    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'
    UNION
    ALL
    QueryRunArchived: QueryRun has been archived