Query editor
WITH ADDRESS_CANDIDATES AS (SELECTFROM_ADDRESSFROM dune.elric.result_gtx_step_1_ac)-- gas funding-- Gas funding should be normal transfer, legacy typeSELECTGAS_RECIPIENTFROM (SELECTmt.to AS GAS_RECIPIENT, ROW_NUMBER() OVER (PARTITION BY mt.to ORDER BY mt.block_number ASC) AS rnFROM ethereum.transactions mtWHERE mt.block_number >= 12965000AND mt.to IN (SELECT FROM_ADDRESS FROM ADDRESS_CANDIDATES) -- connector received ETHAND mt."from" IN (SELECT FROM_ADDRESS FROM ADDRESS_CANDIDATES) -- gas funder should also fit connector heuristicsAND mt.type = 'Legacy'AND mt.gas_limit = 21000AND mt.value <> 0)WHERE rn = 1-- Gas can also be supplied via 1inch fusion swapUNIONSELECTtrace.to AS GAS_RECIPIENTFROM ethereum.traces traceINNER JOIN ethereum.logs logON trace.tx_hash = log.tx_hashAND trace.block_number = log.block_number-- Order FilledAND log.topic0 = 0xb9ed0243fdf00f0545c63a0af8850c090d86bb46682baec4bf3c496814fe4f02WHERE trace.block_number >= 12965000 -- post LondonAND trace.to IN (SELECT FROM_ADDRESS FROM ADDRESS_CANDIDATES)-- -- ETH from 1inch settlement to TRUE ETH addressAND trace."from" = 0x08b067ad41e45babe5bbb52fc2fe7f692f628b06AND trace.VALUE <> 0-- Gas can also be supplied via 1inch Agg when order wasn't takenUNIONSELECTtrace.to AS GAS_RECIPIENTFROM ethereum.traces traceWHERE trace.to IN (SELECT FROM_ADDRESS FROM ADDRESS_CANDIDATES)AND trace.block_number >= 12965000AND trace.VALUE <> 0AND trace."from" IN (0x1111111254fb6c44bAC0beD2854e76F90643097d -- V4, 0x1111111254eeb25477b68fb85ed929f73a960582 -- V5, 0x111111125421ca6dc452d289314280a0f8842a65 -- V6)