Query editor
WITH ADDRESS_CANDIDATES AS (SELECTac.FROM_ADDRESSFROM dune.elric.result_gtx_step_1_ac acWHEREac.FROM_ADDRESS IN (SELECT GAS_RECIPIENT FROM dune.elric.result_gtx_step_2_gas_funding_txns)ANDac.FROM_ADDRESS IN (SELECT TOKEN_RECIPIENT FROM dune.elric.result_gtx_step_2_token_recipients)), LAST_DAI_SENT AS (SELECTtrf."from" AS FROM_ADDRESS, trf.to AS LAST_DAI_DEST, trf.to IN (SELECT ac.FROM_ADDRESS FROM ADDRESS_CANDIDATES ac) AS IS_LAST_DAI_DEST_IN_AC, ROW_NUMBER() OVER (PARTITION BY trf."from" ORDER BY mt.BLOCK_NUMBER DESC) AS rnFROM erc20_ethereum.evt_transfer trfINNER JOIN ethereum.transactions mtON trf.evt_tx_hash = mt.hashWHERE trf.contract_address = 0x6b175474e89094c44da98b954eedeac495271d0f -- DAIAND trf.value > 0AND mt.gas_limit = 90000AND mt.type = 'Legacy'AND mt.BLOCK_NUMBER >= 12965000AND trf."from" IN (SELECT ac.FROM_ADDRESS FROM ADDRESS_CANDIDATES ac))SELECTFROM_ADDRESS, LAST_DAI_DEST, IS_LAST_DAI_DEST_IN_ACFROM LAST_DAI_SENTWHERE rn = 1