Index: trunk/ippTools/share/regtool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/regtool_pendingimfile.sql	(revision 12086)
+++ trunk/ippTools/share/regtool_pendingimfile.sql	(revision 14023)
@@ -1,11 +1,18 @@
-SELECT
-   newImfile.*,
-   newExp.workdir
-FROM newImfile
-LEFT JOIN newExp
-    USING(exp_tag)
-LEFT JOIN rawExp
-    USING(exp_tag)
-WHERE
-    newExp.exp_tag is NOT NULL
-    AND rawExp.exp_tag IS NULL
+SELECT DISTINCT * FROM
+    (SELECT
+        newExp.exp_id,
+        newExp.tmp_exp_name,
+        newExp.tmp_camera,
+        newExp.tmp_telescope,
+        newExp.workdir,
+        newImfile.tmp_class_id,
+        newImfile.uri
+    FROM newImfile
+    JOIN newExp
+        USING(exp_id)
+    LEFT JOIN rawImfile
+        ON newExp.exp_id = rawImfile.exp_id
+        AND newImfile.tmp_class_id = rawImfile.tmp_class_id
+    WHERE
+        newExp.state = 'run'
+        AND rawImfile.tmp_class_id IS NULL) as Foo