Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 15695)
+++ trunk/ippTools/share/Makefile.am	(revision 15755)
@@ -41,4 +41,5 @@
 	flatcorr_completely_processed_chiprun.sql \
 	flatcorr_find_completed_floatcorruns.sql \
+	flatcorr_find_processedimfiles.sql \
 	magictool_toprocess_inputs.sql \
 	magictool_toprocess_tree.sql \
Index: trunk/ippTools/share/flatcorr_find_processedimfiles.sql
===================================================================
--- trunk/ippTools/share/flatcorr_find_processedimfiles.sql	(revision 15755)
+++ trunk/ippTools/share/flatcorr_find_processedimfiles.sql	(revision 15755)
@@ -0,0 +1,14 @@
+SELECT
+    corr_id,
+    chipProcessedImfile.*
+FROM flatcorrRun
+JOIN flatcorrExp
+    USING(corr_id)
+JOIN chipRun
+    USING(chip_id)
+JOIN chipProcessedImfile
+    USING(chip_id)
+WHERE
+    flatcorrRun.state = 'run'
+    AND chipRun.state = 'stop'
+