i_danBase Names: Total Names and User Addresses
Updated 2024-12-31
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
›
⌄
With names AS (
SELECT
tx_hash AS tx
, origin_from_address AS add
, split_part(
split_part(
split_part(CAST(decoded_log AS VARCHAR), '.base.eth', 1)
, 'name":"', 2)
, '","node', 1
) AS BaseName
FROM base.core.ez_decoded_event_logs
WHERE 1=1
AND contract_address = lower('0xc6d566a56a1aff6508b41f6c90ff131615583bcd')
AND event_name = 'NameChanged'
)
SELECT
COUNT(DISTINCT add) AS Total_addresses
, count(DISTINCT basename) AS Name_count
FROM names
WHERE basename <> ''
--GROUP BY 1
--ORDER BY 2 DESC
--LIMIT 10000
QueryRunArchived: QueryRun has been archived