Changeset 14024 for trunk/ippTools/share/regtool_pendingexp.sql

Timestamp:

Jul 5, 2007, 3:21:25 PM (19 years ago)

Author:

jhoblitt

Message:

merge regtool_find_unprocessed_exp.sql & regtool_pendingexp.sql

File:

• trunk/ippTools/share/regtool_pendingexp.sql (modified) (1 diff)

trunk/ippTools/share/regtool_pendingexp.sql

@@ -1 @@
-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