with raw as (select block_timestamp as t,tx_hash, event_inputs:label as ens_id,event_inputs:name as ens_label, event_inputs:cost/10e17 as mint_cost, length(ens_label) as len

from ethereum.core.fact_event_logs

where event_name = 'NameRegistered' and origin_to_address = '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5' and event_inputs:name is not null),

raw2 as (select * from (select * from raw

where len={{ENS_Series}} )

where regexp_like(ens_label, '^[0-9]*$')),

mint as ( select block_timestamp as t, tx_hash, tokenid from ethereum.core.ez_nft_mints

where nft_address= '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85' and

project_name = 'ens')

select mint.t, raw2.tx_hash, tokenid,ens_label

from mint inner join raw2 on

mint.tx_hash=raw2.tx_hash

limit 1000