Query editor
with possible_sandwiches_frontrun_info as(selectdistinct contract_address as tokens_involved,possible_sandwiches.frontrun_tx_hash as frontrun_tx_hash,tx_to as pool_idfrom query_2423263 as possible_sandwichesinner join query_2423248 as swaps on possible_sandwiches.frontrun_tx_hash = swaps.tx_hashwheren_swaps_in is not nulland n_swaps_in = n_swaps_outand n_swaps_in <= 3)select * from possible_sandwiches_frontrun_info