-- most ENS set name input_data have len(input_data)=202 (480k tx), followed by len(input_data)= 266 (9.9k)
-- see whether decoding codes work for non 202 and 266 len characters
SELECT
try_hex_decode_string(regexp_replace(substr(tx_json:input,139), 'e657468.*', 'e657468')) as substr139_regexp,
len(substr139_regexp) as ens_length,
len(input_data) as characters,
tx_hash,
input_data
FROM ethereum.core.fact_transactions
WHERE 1=1
AND origin_function_signature = '0xc47f0027'
AND status = 'SUCCESS'
AND characters !=202
AND characters !=266
ORDER BY characters DESC
LIMIT 1000