sssstatisticBoss Hunting - Contributors
    Updated 5 hours ago
    select
    CONCAT('#', decoded_log ['bossId']) AS "Boss ID",
    origin_from_address AS "Address",
    decoded_log ['damage'] / pow(10, 18) AS "Damage",
    CASE
    event_name
    WHEN 'AttackBoss' THEN 'Helper'
    ELSE 'Summoner'
    END AS "Role",
    block_timestamp
    from
    blast.core.ez_decoded_event_logs
    where
    contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
    and event_name in ('AttackBoss', 'SummonBoss')
    ORDER BY
    decoded_log ['bossId'] DESC,
    "Role" DESC,
    block_timestamp
    Last run: about 5 hours agoAuto-refreshes every 12 hours
    Boss ID
    Address
    Damage
    Role
    BLOCK_TIMESTAMP
    1
    #54270x4dfbf3a3c29e2d305741275bb2791e6c97537c1fSummoner2025-02-20 16:00:27.000
    2
    #54270x4dfbf3a3c29e2d305741275bb2791e6c97537c1f8.89Helper2025-02-20 16:00:27.000
    3
    #54260x1cef9a4235d50b328bde393b071f42d23346bc94Summoner2025-02-20 16:00:29.000
    4
    #54260x1cef9a4235d50b328bde393b071f42d23346bc9460.3402Helper2025-02-20 16:00:29.000
    5
    #54250x0c09ac4751e358b20d95ba5345c13dd81fe41765Summoner2025-02-20 16:00:19.000
    6
    #54250x0c09ac4751e358b20d95ba5345c13dd81fe417659.8679Helper2025-02-20 16:00:19.000
    7
    #54240xa312f4f23043ac9cfb8ec0ef242f6124667fdc47Summoner2025-02-20 12:00:41.000
    8
    #54240xa312f4f23043ac9cfb8ec0ef242f6124667fdc4741.415Helper2025-02-20 12:00:41.000
    9
    #54240x7841d3173d36b23a1d3ab30e898f21df1da8b7502011.9172Helper2025-02-20 12:01:37.000
    10
    #54240xe41bed39419c6d68dcf754c5d24dbedec61ab5021335.48Helper2025-02-20 12:02:25.000
    11
    #54240x497189977ffb615aebb8940c808799adb8f784cb3285.9417Helper2025-02-20 12:05:07.000
    12
    #54230x4934edd37f4225ac8c5d137d2aae99deb29310abSummoner2025-02-20 12:00:29.000
    13
    #54230x4934edd37f4225ac8c5d137d2aae99deb29310ab9.2456Helper2025-02-20 12:00:29.000
    14
    #54230x348b7b78ece1d0671c645359e8e2838f1f1c1a352242.7685Helper2025-02-20 12:02:07.000
    15
    #54230xc635db5aa3904989bd7bab27f5303c7149fdbcf31927.1196Helper2025-02-20 12:02:37.000
    16
    #54220xee8588de5d34b2df412d581f043d5860458dd0dcSummoner2025-02-20 12:00:33.000
    17
    #54220xee8588de5d34b2df412d581f043d5860458dd0dc118.7144Helper2025-02-20 12:00:33.000
    18
    #54210x2532fd5b27801e9504a8fa84197e6de1074f6365Summoner2025-02-20 08:00:35.000
    19
    #54210x2532fd5b27801e9504a8fa84197e6de1074f636530.3012Helper2025-02-20 08:00:35.000
    20
    #54210x28d9682fd14e84129ec22e9e2201e335771da3963006.4256Helper2025-02-20 08:06:43.000
    ...
    47543
    4MB
    39s