Index: /trunk/ippTools/share/Makefile.am
===================================================================
--- /trunk/ippTools/share/Makefile.am	(revision 15824)
+++ /trunk/ippTools/share/Makefile.am	(revision 15825)
@@ -13,4 +13,5 @@
 	detselect_search.sql \
 	detselect_select.sql \
+	dettool_correct_pendingimfiles.sql \
 	dettool_find_completed_runs.sql \
 	dettool_normalizedstat.sql \
Index: /trunk/ippTools/share/dettool_correct_pendingimfiles.sql
===================================================================
--- /trunk/ippTools/share/dettool_correct_pendingimfiles.sql	(revision 15825)
+++ /trunk/ippTools/share/dettool_correct_pendingimfiles.sql	(revision 15825)
@@ -0,0 +1,31 @@
+SELECT
+    det1.*,
+    imfile.class_id,
+    imfile.uri,
+    imfile.bg,
+    imfile.bg_stdev,
+    imfile.bg_mean_stdev,
+    imfile.user_1,
+    imfile.user_2,
+    imfile.user_3,
+    imfile.user_4,
+    imfile.user_5,
+    imfile.path_base,
+    imfile.fault
+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'
+    AND detRegisteredImfile.det_id IS NULL
+    AND detRegisteredImfile.iteration IS NULL
+    AND detRegisteredImfile.class_id IS NULL