with tx_id_with_ID as (

select

*,

event_inputs:id as id,

row_number() over (partition by id order by block_timestamp desc) as rownumber

from

ethereum.events_emitted

where event_name = 'NameRegistered'

and id is not null

qualify rownumber = 1

),

tx_id_with_name as (

select

*,

event_inputs:name as name

from

ethereum.events_emitted

where event_name = 'NameRegistered'

and name is not null

),

id_with_name as (

select

id,

name,

case

when name is not null then name

else id end

as corrected_name

from

tx_id_with_ID

left join tx_id_with_name on tx_id_with_ID.tx_id = tx_id_with_name.tx_id

),

nft_sales as (