Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 15829)
+++ trunk/ippTools/share/Makefile.am	(revision 15830)
@@ -15,5 +15,5 @@
 	dettool_tocorrectimfile.sql \
 	dettool_tocorrectexp.sql \
-	dettool_find_completed_correct_runs.sql
+	dettool_stop_completed_correct_runs.sql \
 	dettool_find_completed_runs.sql \
 	dettool_normalizedstat.sql \
Index: trunk/ippTools/share/dettool_find_completed_correct_runs.sql
===================================================================
--- trunk/ippTools/share/dettool_find_completed_correct_runs.sql	(revision 15829)
+++ 	(revision )
@@ -1,23 +1,0 @@
-SELECT
-    det1.det_id,
-    imfile.class_id,
-    detRegisteredImfile.class_id
-FROM detRun AS det1
-INNER JOIN detRun as det2
-    ON det1.parent = det2.det_id 
-JOIN detNormalizedImfile as imfile
-    ON det2.det_id = imfile.det_id
-    AND det2.iteration = imfile.iteration
-LEFT JOIN detRegisteredImfile
-    ON det1.det_id = detRegisteredImfile.det_id
-    AND det1.iteration = detRegisteredImfile.iteration
-    AND imfile.class_id = detRegisteredImfile.class_id
-WHERE 
-    det1.state = 'run'
-    AND det1.mode = 'correction'
-    AND det2.state = 'stop'
-GROUP BY
-    det1.det_id
-HAVING
-    COUNT(imfile.class_id) = COUNT(detRegisteredImfile.class_id)
-    AND SUM(imfile.fault) = 0
Index: trunk/ippTools/share/dettool_stop_completed_correct_runs.sql
===================================================================
--- trunk/ippTools/share/dettool_stop_completed_correct_runs.sql	(revision 15830)
+++ trunk/ippTools/share/dettool_stop_completed_correct_runs.sql	(revision 15830)
@@ -0,0 +1,28 @@
+UPDATE detRun
+SET state = 'stop'
+WHERE det_id = (SELECT det_id FROM
+    (SELECT
+        det1.det_id,
+        imfile.class_id,
+        detRegisteredImfile.class_id as reg_class_id
+    FROM detRun AS det1
+    INNER JOIN detRun as det2
+        ON det1.parent = det2.det_id 
+    JOIN detNormalizedImfile as imfile
+        ON det2.det_id = imfile.det_id
+        AND det2.iteration = imfile.iteration
+    LEFT JOIN detRegisteredImfile
+        ON det1.det_id = detRegisteredImfile.det_id
+        AND det1.iteration = detRegisteredImfile.iteration
+        AND imfile.class_id = detRegisteredImfile.class_id
+    WHERE 
+        det1.state = 'run'
+        AND det1.mode = 'correction'
+        AND det2.state = 'stop'
+    GROUP BY
+        det1.det_id
+    HAVING
+        COUNT(imfile.class_id) = COUNT(reg_class_id)
+        AND SUM(imfile.fault) = 0
+    ) as Foo
+)