Changeset 17573

Timestamp:

May 7, 2008, 5:28:40 PM (18 years ago)

Author:

jhoblitt

Message:

optimization

File:

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

trunk/ippTools/share/regtool_pendingimfile.sql

@@ -1 @@
-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
+SELECT DISTINCT
+    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