Changeset 33415 for branches/meh_branches/ppstack_test/ippTools/share/pztool_pendingimfile.sql

Timestamp:

Mar 5, 2012, 5:19:48 PM (14 years ago)

Author:

mhuber

Message:

merging latest r33407 trunk changes to meh_branches/ppstack_test

Location:

branches/meh_branches/ppstack_test

Files:

• . (modified) (1 prop)
• ippTools/share/pztool_pendingimfile.sql (modified) (1 diff)

branches/meh_branches/ppstack_test/ippTools/share/pztool_pendingimfile.sql

@@ -19 +19 @@
         AND pzDownloadImfile.class IS NULL
         AND pzDownloadImfile.class_id IS NULL
+        AND summitImfile.exp_name NOT LIKE '%a'
+UNION
+    SELECT
+        summitImfile.*,
+        summitExp.dateobs
+    FROM summitImfile
+    JOIN pzDownloadExp
+        USING(summit_id)
+    LEFT JOIN pzDownloadImfile
+        USING(summit_id, class, class_id)
+    JOIN summitExp
+        USING(summit_id)
+    WHERE 
+        pzDownloadExp.state = 'run'
+        AND pzDownloadImfile.summit_id IS NULL
+        AND pzDownloadImfile.exp_name IS NULL
+        AND pzDownloadImfile.camera IS NULL
+        AND pzDownloadImfile.telescope IS NULL
+        AND pzDownloadImfile.class IS NULL
+        AND pzDownloadImfile.class_id IS NULL
+        AND summitImfile.exp_name LIKE '%a'
 ) as Foo