with tot as (SELECT BLOCK_TIMESTAMP ,NFT_TO_ADDRESS as address, (SELECT BLOCK_TIMESTAMP

from base.nft.ez_nft_transfers

where NFT_ADDRESS = '0xcfc5f93f38237fc9efef93e70db7d63e94b22407'

and TOKENID = '1')as first

from base.nft.ez_nft_transfers

where NFT_ADDRESS = '0xcfc5f93f38237fc9efef93e70db7d63e94b22407')

select

ENS_DOMAIN,address,BLOCK_TIMESTAMP,

case when TIMEDIFF(minutes, FIRST, BLOCK_TIMESTAMP) <= 60 then 1

when TIMEDIFF(minutes, FIRST, BLOCK_TIMESTAMP) BETWEEN 60.01 AND 1440 then 2

else null end as type

from tot t left join ethereum.ens.ez_ens_domains e on t.address=e.OWNER

order by 2