Query editor
SELECTo.OptimismCount,a.ArbitrumCount,f.FantomCount,e.EthereumCount,g.GnosisCount,p.PolygonCount,b.BnbCount,av.AvalancheCount,bs.BaseCount,sc.ScrollCount,bl.BlastCount,(o.OptimismCount+ a.ArbitrumCount+ f.FantomCount+ e.EthereumCount+ g.GnosisCount+ p.PolygonCount+ b.BnbCount+ av.AvalancheCount+ bs.BaseCount+ sc.ScrollCount+ bl.BlastCount) AS TotalCountFROM-- Optimism(SELECT COUNT(1) AS OptimismCountFROM optimism.logsWHERE contract_address IN (0xbf07a0df119ca234634588fbdb5625594e2a5bca,0xA8202f888B9B2Dfa5CeB2204865018133F6F179a,0x26cE6745A633030A6faC5e64e41D21fb6246dc2d)) oCROSS JOIN-- Arbitrum(SELECT COUNT(1) AS ArbitrumCountFROM arbitrum.logsWHERE contract_address IN (0xbf07a0df119ca234634588fbdb5625594e2a5bca,0xA8202f888B9B2Dfa5CeB2204865018133F6F179a,0x26cE6745A633030A6faC5e64e41D21fb6246dc2d)) aCROSS JOIN-- Fantom(SELECT COUNT(1) AS FantomCountFROM fantom.logsWHERE contract_address IN (0xbf07a0df119ca234634588fbdb5625594e2a5bca,0xA8202f888B9B2Dfa5CeB2204865018133F6F179a,0x26cE6745A633030A6faC5e64e41D21fb6246dc2d)) fCROSS JOIN-- Ethereum(SELECT COUNT(1) AS EthereumCountFROM ethereum.logsWHERE contract_address IN (