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

Timestamp:

Jul 5, 2007, 5:46:11 PM (19 years ago)

Author:

jhoblitt

Message:

remove newExp.imfils

File:

• trunk/ippTools/share/regtool_pendingexp.sql (modified) (2 diffs)

trunk/ippTools/share/regtool_pendingexp.sql

@@ -1 +1 @@
 SELECT DISTINCT * FROM
     (SELECT
-       newExp.*
+       newExp.*,
+       newImfile.tmp_class_id,
+       rawImfile.tmp_class_id as raw_tmp_class_id
     FROM newExp
     JOIN newImfile
@@ -7 +9 @@
     LEFT JOIN rawExp
        USING(exp_id)
+    LEFT JOIN rawImfile
+        ON newImfile.exp_id = rawImfile.exp_id
+        AND newImfile.tmp_class_id = rawImfile.tmp_class_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
+    GROUP BY
+        newExp.exp_id
+    HAVING
+        COUNT(newImfile.tmp_class_id) = COUNT(rawImfile.tmp_class_id)
+    ) as Foo