How could this SQL be optimized?

[feng guo]

This SQL I think should be optimized as consideration of collection,but I still couldn't find it out:
--------------------------------------------------------------------------
SELECT ID,WAYBILL_NO,EXP_TYPE,PKG_QTY,EXPRESS_CONTENT_CODE,EFFECTIVE_TYPE_CODE
FROM T_EXP_OP
WHERE
ORDERID NOT IN(SELECT ORDERID FROM T_EXP_OP WHERE AUX_OP_CODE IN ('NEW','UPDATE','DELETE') AND ((OP_CODE IN (176, 162, 171, 131, 136) AND EXP_TYPE IN ('10', '20', '30')) OR (OP_CODE IN (191, 121) AND EXP_TYPE IN ('10', '20')) OR (OP_CODE IN (181, 111)AND EXP_TYPE = '10'))) ;
--------------------------------------------------------------------------
Someone gives me this optimized result:
--------------------------------------------------------------------------
SELECT ID, WAYBILL_NO, EXP_TYPE, PKG_QTY,EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE
FROM T_EXP_OP
WHERE
AUX_OP_CODENOT IN (‘NEW’, ‘UPDATE’, ‘DELETE’)

AND (OP_CODE NOT IN (176, 162, 171, 131, 136, 191, 121, 181,111)

AND EXP_TYPE NOT IN(‘10’, ‘20’, ‘30’))
--------------------------------------------------------------------------