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