SELECT
DISTINCT a.to_address
from
optimism.core.fact_transactions as a,
optimism.core.fact_traces as b
WHERE
a.TX_HASH = b.TX_HASH
and substring(a.input_data, 3, 8) != '6a761202'
and substring(b.input, 3, 8) = '23b872dd'
and substring(b.input, 35, 40) = substring(a.to_address, 3)
and a.INPUT_DATA not like concat('%', substring(b.input, 35, 40), '%')
and a.INPUT_DATA not like concat('%', substring(b.input, 99, 40), '%')