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_USDT_SENT AS (SELECTmt."from" AS FROM_ADDRESS, varbinary_substring(mt.data, 17, 20) AS LAST_USDT_DEST, ac.FROM_ADDRESS IS NOT NULL AS IS_LAST_USDT_DEST_IN_AC, ROW_NUMBER() OVER (PARTITION BY mt."from" ORDER BY mt.BLOCK_NUMBER DESC) AS rnFROM ethereum.transactions mtLEFT JOIN ADDRESS_CANDIDATES acON varbinary_substring(mt.data, 17, 20) = ac.FROM_ADDRESSWHERE mt.to = 0xdac17f958d2ee523a2206206994597c13d831ec7 -- USDTAND varbinary_substring(mt.data, 37, 32) > 0x00AND mt.gas_limit = 90000AND mt.type = 'Legacy'AND mt.BLOCK_NUMBER >= 12965000AND mt."from" IN (SELECT ac.FROM_ADDRESS FROM ADDRESS_CANDIDATES ac))SELECTFROM_ADDRESS, LAST_USDT_DEST, IS_LAST_USDT_DEST_IN_ACFROM LAST_USDT_SENTWHERE rn = 1