Hessishblip top 10 2
Updated 2025-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with names as (SELECT REGEXP_SUBSTR(VALUE, 'Creating new domain ([^ ]+)', 1, 1, 'e', 1) AS domain_name,
tx_id as tx, signers[0] as addy
FROM
eclipse.core.fact_transactions,
LATERAL FLATTEN(input => LOG_MESSAGES)
WHERE
VALUE LIKE '%Creating new domain%'),
blibs as (select BLOCK_TIMESTAMP,
SIGNERS[0] as sender , domain_name as sn_name,
INSTRUCTION:accounts[4] as receiver,
tx_id
from eclipse.core.fact_events_inner
left join names on sender=addy
where --tx_id = '319Q8t66kuVwb9hCdwtYgWNCFLEJMDJg3BTgAVpxvzmpuqyokdPGUdf8hvpG7AFnyapFog9YVXj3FazmVR5F8X2X' and
PROGRAM_ID = 'CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d'
and INSTRUCTION_PROGRAM_ID = 'rdr1DeFWkwG6nQfammDLTzRT6uW32t7yEHWCmcr49Df'),
all_data as (select BLOCK_TIMESTAMP, sender, sn_name,
case when sn_name is null then sender else sn_name end as sender_name,
receiver, domain_name as rec_name,
case when rec_name is null then receiver else rec_name
end as receiver_name, tx_id
from blibs
left join names on receiver=addy)
select DISTINCT sender_name, count(DISTINCT tx_id) as "Sent Blips 📨"
from all_data
group by all
order by 2 desc limit 10
QueryRunArchived: QueryRun has been archived