Query editor
with mevblocker as (select distinctfrom_hex(CAST(json_extract(transactions, '$[0].hash') AS VARCHAR)) as user_txfrom mevblocker.raw_bundleswhere date_trunc('day', from_unixtime("timestamp" / 1000.0)) > now() - interval '7' daygroup by 1)selectt.tx_hash as hash,t.block_time,t.block_number,t."user",'1inch Website: Default' as frontend,'1inch Fusion' as metaaggregator,solver,trade_pair,trade_usd, -- user side from fusion trade totalcase when mempool.hash is not null then 'public mempool' else 'private mempool' end as mempool, -- add latercase when (mb.user_tx is not null and f.tx_hash is not null) then 'Flashbots Protect & MEV Blocker'when (f.tx_hash is not null and mb.user_tx is null) then 'Flashbots Protect'when (mb.user_tx is not null and f.tx_hash is null) then 'MEV Blocker'else null end as ofa,coalesce(l.builder_label, 'Other Builders') as builder -- likely if appears it's cuz schedule time issuefrom dune.flashbots.result_1inch_fusion_txs_7d tleft join query_3023136 as f on f.tx_hash = t.tx_hash-- dune.flashbots.result_protect_landed_txs_templeft join mevblocker mb on mb.user_tx = t.tx_hashleft join query_3145549 mempool on cast(t.tx_hash as varchar) = mempool.hash-- dune.flashbots.result_mempool_7d_distinctleft join query_3184477 l on l.blocknumber = t.block_number-- dune.flashbots.result_block_number_with_builder_labels