Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 14038)
+++ trunk/ippTools/share/Makefile.am	(revision 14043)
@@ -14,4 +14,5 @@
 	dettool_find_completed_runs.sql \
 	dettool_raw.sql \
+    dettool_toprocessedimfile.sql \
 	difftool_inputskyfile.sql \
 	difftool_skyfile.sql \
Index: trunk/ippTools/share/dettool_toprocessedimfile.sql
===================================================================
--- trunk/ippTools/share/dettool_toprocessedimfile.sql	(revision 14043)
+++ trunk/ippTools/share/dettool_toprocessedimfile.sql	(revision 14043)
@@ -0,0 +1,23 @@
+SELECT
+    detRun.det_id,
+    detRun.det_type,
+    detRun.workdir,
+    detRun.reduction,
+    rawImfile.*
+FROM detRun
+JOIN detInputExp
+    USING(det_id, iteration)
+JOIN rawExp
+    ON detInputExp.exp_id = rawExp.exp_id
+JOIN rawImfile
+    ON detInputExp.exp_id = rawImfile.exp_id
+LEFT JOIN detProcessedImfile
+    ON detInputExp.det_id = detProcessedImfile.det_id
+    AND rawImfile.exp_id = detProcessedImfile.exp_id
+    AND rawImfile.class_id = detProcessedImfile.class_id
+WHERE
+    detRun.state = 'run'
+    AND detRun.mode = 'master'
+    AND detProcessedImfile.det_id IS NULL
+    AND detProcessedImfile.exp_id IS NULL
+    AND detProcessedImfile.class_id IS NULL