Query editor
WITH msgs AS (SELECT m.projectFROM layerzero.messages mINNER JOIN dune.canaryprotocol.result_transaction_list_validated_by_lz_canary_dvn cON m.tx_hash_source = CAST(c.tx_hash AS varchar)AND ((c.chain = 'bnb' AND m.source_chain_key = 'bsc')OR (c.chain = 'berachain' AND m.source_chain_key = 'bera')OR (c.chain = 'avalanche_c' AND m.source_chain_key = 'avalanche')OR (c.chain = 'hyperevm' AND m.source_chain_key = 'hyperliquid')OR c.chain = m.source_chain_key)WHERE c.block_date < DATE '2026-07-09'AND m.state = 'Success'UNION ALLSELECT m.projectFROM layerzero.messages mWHERE m._updated_at >= DATE '2026-07-09'AND m.state = 'Success'UNION ALLSELECT m.projectFROM layerzero.messages mINNER JOIN dune.canaryprotocol.result_transaction_list_include_fee_paide_to_wbtc_canary_dvn cON m.tx_hash_source = CAST(c.tx_hash AS varchar)AND ((c.chain = 'bnb' AND m.source_chain_key = 'bsc')OR (c.chain = 'berachain' AND m.source_chain_key = 'bera')OR (c.chain = 'avalanche_c' AND m.source_chain_key = 'avalanche')OR c.chain = m.source_chain_key)WHERE c.block_date < DATE '2026-07-09'AND m.project = 'wBTC'AND m.state = 'Success')SELECT project, COUNT(*) AS messagesFROM msgsWHERE project IS NOT NULL AND LOWER(project) <> 'unknown'GROUP BY 1ORDER BY messages DESCLIMIT 25