Sbhn_NPglorious-black
Updated 2025-04-25
9
1
2
3
4
5
6
7
8
›
⌄
select count(DISTINCT REGEXP_SUBSTR(f.value, 'Creating new domain ([^ ]+)', 1, 1, 'e', 1)) AS domain_name,
count(DISTINCT signers[0]) as claimers,
FROM eclipse.core.fact_transactions t
join eclipse.core.fact_events using (tx_id,block_timestamp)
join LATERAL FLATTEN(input => log_messages) f
where f.value iLIKE '%Program log: Creating new domain%'
and program_id = 'TLDHkysf5pCnKsVA4gXpNvmy7psXLPEu4LAdDJthT9S'
QueryRunArchived: QueryRun has been archived