Index: trunk/ippTools/share/dettool_revertresidexp.sql
===================================================================
--- trunk/ippTools/share/dettool_revertresidexp.sql	(revision 14268)
+++ trunk/ippTools/share/dettool_revertresidexp.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detResidExp
+USING detResidExp, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detResidExp.det_id = detRun.det_id