sssstatisticActivity Points - Rice of the Golden Fish
    Updated 2024-11-27
    With timeline as (
    SELECT
    to_timestamp(value['start']) AS start_time,
    to_timestamp(value['end']) AS end_time,
    value['season'] AS season
    from
    table(
    flatten(
    PARSE_JSON(
    '[
    {"start":"2024-06-04 00:00:00", "end":"2024-06-10 23:59:59.9", "season": 1},
    {"start":"2024-06-11 00:00:00", "end":"2024-06-17 23:59:59.9", "season": 2},
    {"start":"2024-06-18 00:00:00", "end":"2024-06-24 23:59:59.9", "season": 3},
    {"start":"2024-07-15 08:00:00", "end":"2024-07-22 08:59:59.9", "season": 4},
    {"start":"2024-09-15 00:00:00", "end":"2024-09-29 00:00:00.0", "season": 5}
    ]'
    )
    )
    ) f
    ),
    land AS (
    select
    decoded_log ['account'] AS address,
    decoded_log ['landId'] AS landId,
    block_number,
    block_timestamp
    from
    blast.core.ez_decoded_event_logs ln
    where
    contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
    and event_name = 'NewAccount'
    and exists (
    select 1
    from timeline tl
    where tl.start_time <= ln.block_timestamp
    and tl.end_time >= ln.block_timestamp
    Last run: 3 months ago
    ADDRESS
    POINTS
    Register Time
    1
    0x0000000b396c232107d7a71ef1687287b4c4aa111853352024-09-15 09:20:55.000
    2
    0xc7dcf2f21a9765b11a8edfc91fd531de6373dbd41098152024-09-15 18:08:53.000
    3
    0x07a83dbd5930ec4d96a28e78302cbad2625252981071322024-09-21 15:33:37.000
    4
    0xea6a3b3f6e3a48d71e19e327eeca7bd64ad7cefe979902024-09-17 17:50:45.000
    5
    0x5ef2af14dfb17497d364e3c077c322de2edb0e01667002024-09-21 05:30:13.000
    6
    0x57668e9fd9719afe6bb2a523c38ac4173a2c37b1484502024-09-21 20:09:47.000
    7
    0xa5364da98dd7d321e3405d96d856493185382a29471152024-09-18 05:13:53.000
    8
    0x7c88d87b99247320603be49f3ba7ff6ed26492bd434952024-09-22 07:20:31.000
    9
    0xa1de8ea6651fac7c361bc341bc5943dc6efa82eb425852024-09-22 06:33:23.000
    10
    0x9dbc1fd9f8fbc9286ba813f3d9f52cc44a804bd4315702024-09-25 03:07:39.000
    11
    0x90a863c734b2abb706b129ad6239782b0227310b315352024-09-25 02:21:21.000
    12
    0xeab2dec688f6e55143f26e2f589cec0e03ac836e313502024-09-23 19:56:05.000
    13
    0x68f92b5b37441bc8fa8aa1ce34a1a398dff4f0e9308202024-09-22 09:40:33.000
    14
    0x00938f3810c7c773fcdf523d6a5c45613130e7de307302024-09-22 10:01:59.000
    15
    0xf94da0c2452c87cdcec8dc2392b38fd8b5fd55ac305702024-09-25 04:16:31.000
    16
    0x36ab3eefa36512af5820680442b5de49ade9414e305402024-09-25 04:24:27.000
    17
    0xae3f0cd860165f3e12a156ab60a4581ea3195b29295852024-09-24 04:00:31.000
    18
    0x9cfbd56860bbb8f1752a2a9010e32abc3631cb05294802024-09-23 05:23:57.000
    19
    0x65c6f19931b8d3587ac9853da870b68671d865ac227302024-09-25 03:51:45.000
    20
    0x6a118fd39bd9d02cca21f36592eb89ea65436f87225852024-09-25 04:06:03.000
    ...
    457
    35KB
    19s