Query editor
with collections as (SELECT evt_block_time, name, defaultAdmin, newContract, 'zora' as blockchainFROM zora_zora.ZoraCreator1155_evt_SetupNewContractUNION ALLSELECT evt_block_time, name, defaultAdmin, newContract, 'base' as blockchainFROM zora_base.ZoraCreator1155FactoryImpl_evt_SetupNewContractUNION ALLSELECT evt_block_time, name, defaultAdmin, newContract, 'optimism' as blockchainFROM zora_optimism.ZoraCreator1155FactoryImpl_evt_SetupNewContractUNION ALLSELECT evt_block_time, name, defaultAdmin, newContract, 'arbitrum' as blockchainFROM zora_arbitrum.ZoraCreator1155Factory_evt_SetupNewContractUNION ALLSELECT evt_block_time, name, defaultAdmin, newContract, 'blast' as blockchainFROM zora_blast.ZoraCreator1155FactoryImpl_evt_SetupNewContract),mints_filtered as (select t1.*from nft.mints t1left join collections t2 ont1.nft_contract_address = t2.newContractand t1.blockchain = t2.blockchainwhere block_time > timestamp'2024-01-01'-- and (-- nft_contract_address in (select distinct nft_contract_address from nft.trades)-- or t2.newContract is not null-- )),top_10_projects as (SELECT projectFROM mints_filteredGROUP BY projectORDER BY count(*) DESCLIMIT 5),mints_wide as (selectt1.*,casewhen t2.newContract is not null then 'zora'when p.project is not null then t1.projectelse 'other'end as mint_source,concat(t1.blockchain,'-',casewhen t2.newContract is not null then 'zora'when p.project is not null then t1.projectelse 'other'end) as blockchain_and_mint_sourcefrom mints_filtered t1left join collections t2 ont1.nft_contract_address = t2.newContractand t1.blockchain = t2.blockchainleft join top_10_projects p ont1.project = p.project)select