Query editor
withcontroller_add as (SELECTtx_hash,topic1FROMethereum.logsWHEREcontract_address = 0x57f1887a8BF19b14fC0dF6Fd9B2acc9Af147eA85AND topic0 = 0x0a8bb31534c0ed46f380cb867bd5c803a189ced9a764e30b3a4991a9901d7474),controller_remove as (SELECTtx_hash,topic1FROMethereum.logsWHEREcontract_address = 0x57f1887a8BF19b14fC0dF6Fd9B2acc9Af147eA85AND topic0 = 0x33d83959be2573f5453b12eb9d43b3499bc57d96bd2f067ba44803c859e81113)SELECTca.topic1FROMcontroller_add caLEFT JOIN controller_remove cr ON ca.topic1 = cr.topic1WHEREcr.topic1 IS NULL