Index: /trunk/ippTools/share/Makefile.am
===================================================================
--- /trunk/ippTools/share/Makefile.am	(revision 15828)
+++ /trunk/ippTools/share/Makefile.am	(revision 15829)
@@ -15,4 +15,5 @@
 	dettool_tocorrectimfile.sql \
 	dettool_tocorrectexp.sql \
+	dettool_find_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)
+++ /trunk/ippTools/share/dettool_find_completed_correct_runs.sql	(revision 15829)
@@ -0,0 +1,23 @@
+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