Query editor
with potential_nft_contracts as (selectcreated_time,contract_address,created_tx_hash,contract_project,contract_name,created_tx_from,created_block_number,blockchain,token_standardfrom contracts.contract_mappingwhereblockchain in ('optimism', 'ethereum', 'zora', 'base')-- and token_standard in ('erc721', 'erc1155') -- this still not exhausiveand not is_self_destruct)-- further verfity if a contract is nft if in nft transfers,nfts as (selectc.*from potential_nft_contracts as cjoin nft.transfers as ton c.contract_address = t.contract_addressand c.blockchain = t.blockchainand t.blockchain in ('optimism', 'ethereum', 'zora', 'base')group by 1, 2, 3, 4, 5, 6, 7, 8, 9)selectnt.blockchain,nt.created_tx_from as contract_creator_address,coalesce(nt.contract_project, (array_join((transform((split(lower( coalesce(ce.namespace, cb.namespace, cz.namespace) ),' ')), x -> concat(upper(substr(x,1,1)),substr(x,2,length(x))))),' ','')), ens.name) as creator_label,nt.contract_address as nft_contract_address,coalesce(nft.name, nft.symbol, nt.contract_name, ce.name, cb.name, cz.name) as collection_name,nt.token_standard,nt.created_block_number as block_number,nt.created_time as contract_created_at,nt.created_tx_hash as contract_created_tx_hashfrom nfts as ntleft join ethereum.contracts as ceon ce.address = nt.contract_addressand nt.blockchain = 'ethereum'left join base.contracts as cbon cb.address = nt.contract_addressand nt.blockchain = 'base'left join zora.contracts as czon cz.address = nt.contract_addressand nt.blockchain = 'zora'left join tokens.nft as nfton nft.contract_address = nt.contract_addressand nft.blockchain = nt.blockchainand nft.contract_address = nt.contract_addressleft join labels.ens as enson nt.blockchain = 'ethereum'and ens.address = nt.created_tx_fromgroup by 1, 2, 3, 4, 5, 6, 7, 8, 9