Changeset 33366 for trunk/ippTools/share/pztool_pendingimfile.sql

Timestamp:

Feb 24, 2012, 12:05:48 PM (14 years ago)

Author:

watersc1

Message:

Order what we choose to download to get science before stare observations

File:

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

trunk/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