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'

CASE WHEN LENGTH(basename) = 1 THEN '1 CHARACTERS'

WHEN LENGTH(basename) = 2 THEN '2 CHARACTERS'

WHEN LENGTH(basename) = 3 THEN '3 CHARACTERS'

WHEN LENGTH(basename) = 4 THEN '4 CHARACTERS'

WHEN LENGTH(basename) = 5 THEN '5 CHARACTERS'

WHEN LENGTH(basename) = 6 THEN '6 CHARACTERS'

WHEN LENGTH(basename) = 7 THEN '7 CHARACTERS'

WHEN LENGTH(basename) = 8 THEN '8 CHARACTERS'

WHEN LENGTH(basename) = 9 THEN '9 CHARACTERS'

WHEN LENGTH(basename) = 10 THEN '10 CHARACTERS'

WHEN LENGTH(basename) = 11 THEN '11 CHARACTERS'

WHEN LENGTH(basename) = 12 THEN '12 CHARACTERS'

WHEN LENGTH(basename) = 13 THEN '13 CHARACTERS'

WHEN LENGTH(basename) = 14 THEN '14 CHARACTERS'

WHEN LENGTH(basename) = 15 THEN '15 CHARACTERS'

WHEN LENGTH(basename) = 16 THEN '16 CHARACTERS'

WHEN LENGTH(basename) = 17 THEN '17 CHARACTERS'