Query editor
SELECTOptimismCount.OptimismCount,ArbitrumCount.ArbitrumCount,FantomCount.FantomCount,EthereumCount.EthereumCount,GnosisCount.GnosisCount,PolygonCount.PolygonCount,BnbCount.BnbCount,AvalancheCount.AvalancheCount,BaseCount.BaseCount,ScrollCount.ScrollCount,BlastCount.BlastCount,(OptimismCount.OptimismCount + ArbitrumCount.ArbitrumCount + FantomCount.FantomCount + EthereumCount.EthereumCount + GnosisCount.GnosisCount + PolygonCount.PolygonCount + BnbCount.BnbCount + AvalancheCount.AvalancheCount + BaseCount.BaseCount + ScrollCount + BlastCount.BlastCount) as TotalCountFROM(SELECT COUNT(1) as OptimismCount, 'optimism' as Name FROM optimism.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d ) OptimismCountCROSS JOIN(SELECT COUNT(1) as ArbitrumCount, 'arbitrum' as Name FROM arbitrum.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) ArbitrumCountCROSS JOIN(SELECT COUNT(1) as FantomCount, 'fantom' as Name FROM fantom.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) FantomCountCROSS JOIN(SELECT COUNT(1) as EthereumCount, 'ethereum' as Name FROM ethereum.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) EthereumCountCROSS JOIN(SELECT COUNT(1) as GnosisCount, 'gnosis' as Name FROM gnosis.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) GnosisCountCROSS JOIN(SELECT COUNT(1) as PolygonCount, 'polygon' as Name FROM polygon.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) PolygonCountCROSS JOIN(SELECT COUNT(1) as BnbCount, 'bnb' as Name FROM bnb.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) BnbCountCROSS JOIN(SELECT COUNT(1) as AvalancheCount, 'avalanche_c' as Name FROM avalanche_c.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) AvalancheCountCROSS JOIN(SELECT COUNT(1) as BaseCount, 'base' as Name FROM base.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) BaseCountCROSS JOIN(SELECT COUNT(1) as BlastCount, 'blast' as Name FROM blast.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) BlastCountCROSS JOIN(SELECT COUNT(1) as ScrollCount, 'scroll' as Name FROM scroll.logs WHERE contract_address = 0x26cE6745A633030A6faC5e64e41D21fb6246dc2d) ScrollCount;