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)), TOKEN_RECEIVED AS (SELECTtrf.to, trf.evt_tx_hash, trf.evt_block_number, trf.VALUE, trf.contract_addressFROM erc20_ethereum.evt_transfer trfWHERE trf.to IN (SELECT FROM_ADDRESS FROM ADDRESS_CANDIDATES)AND trf.evt_block_number >= 12965000)SELECTtrf.to AS TOKEN_RECIPIENT, COUNT(mt.hash) = COUNT(CASE WHEN mt.TYPE = 'Legacy' AND mt.gas_limit = 90000 THEN mt.hash ELSE NULL END) AS IS_SOLELY_RECEIVING_INSCOPE_TXNSFROM TOKEN_RECEIVED trfINNER JOIN ethereum.transactions mtON trf.evt_tx_hash = mt.hashAND trf.evt_block_number = mt.block_numberWHERE mt.BLOCK_NUMBER >= 12965000-- de-dustAND trf.VALUE <> 0AND ((trf.contract_address = 0xdac17f958d2ee523a2206206994597c13d831ec7-- >= 1 USDTAND trf.VALUE >= POWER(10, 6))OR(trf.contract_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48-- >= 1 USDCAND trf.VALUE >= POWER(10, 6))OR(trf.contract_address = 0x6b175474e89094c44da98b954eedeac495271d0f-- >= 1 DAIAND trf.VALUE >= POWER(10, 18)))GROUP BY 1-- )-- SELECT-- TOKEN_RECIPIENT-- , IS_SOLELY_RECEIVING_INSCOPE_TXNS-- FROM RECEIVE_TOKEN_STAT