Index: trunk/ippTools/share/regtool_pendingexp.sql
===================================================================
--- trunk/ippTools/share/regtool_pendingexp.sql	(revision 14023)
+++ trunk/ippTools/share/regtool_pendingexp.sql	(revision 14024)
@@ -1,15 +1,14 @@
-SELECT
-    newExp.*
-FROM newExp
-JOIN newImfile
-    USING(exp_id)
-LEFT JOIN rawExp
-    USING(exp_id)
-WHERE
-    newExp.state = 'run'
-    AND rawExp.exp_id IS NULL
-    AND newExp.imfiles =
-    (SELECT COUNT(exp_id) FROM rawImfile
-        WHERE
-            rawImfile.exp_id = newExp.exp_id
-            AND rawImfile.fault = 0)
+SELECT DISTINCT * FROM
+    (SELECT
+       newExp.*
+    FROM newExp
+    JOIN newImfile
+       USING(exp_id)
+    LEFT JOIN rawExp
+       USING(exp_id)
+    WHERE
+        newExp.state = 'run'
+        AND rawExp.exp_id IS NULL
+        AND newExp.imfiles =
+        (SELECT COUNT(exp_id) FROM rawImfile
+            WHERE rawImfile.exp_id = newExp.exp_id)) as Foo