Index: trunk/ippTools/share/flatcorr_pending.sql
===================================================================
--- trunk/ippTools/share/flatcorr_pending.sql	(revision 15685)
+++ trunk/ippTools/share/flatcorr_pending.sql	(revision 15685)
@@ -0,0 +1,23 @@
+SELECT 
+    *
+FROM
+flatcorrRun
+JOIN floatcorrExp
+    USING(corr_id)
+JOIN chipRun
+    USING(chip_id)
+JOIN rawImfile
+    USING(exp_id)
+LEFT JOIN chipProcessedImfile
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
+    AND rawImfile.exp_id = chipProcessedImfile.exp_id
+    AND rawImfile.class_id = chipProcessedImfile.class_id
+WHERE
+    flatcorrRun.state = 'run'
+    AND chipRun.state = 'stop'
+    AND (chipProcessedImfile.fault = 0 || chipProcessedImfile.fault IS NULL)
+GROUP BY
+    chipRun.chip_id,
+    chipRun.exp_id
+HAVING COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
+