Changeset 33638 for branches/eam_branches/ipp-20111122/ippTools/share/pztool_pendingimfile.sql

Timestamp:

Mar 30, 2012, 2:49:37 PM (14 years ago)

Author:

eugene

Message:

merge changes from trunk

File:

• branches/eam_branches/ipp-20111122/ippTools/share/pztool_pendingimfile.sql (modified) (2 diffs)

branches/eam_branches/ipp-20111122/ippTools/share/pztool_pendingimfile.sql

@@ -1 +1 @@
 SELECT *
 FROM (
-    SELECT
+    SELECT * FROM 
+    (SELECT
         summitImfile.*,
         summitExp.dateobs
@@ -19 +20 @@
         AND pzDownloadImfile.class IS NULL
         AND pzDownloadImfile.class_id IS NULL
+        AND summitImfile.exp_name NOT LIKE '%a'
+    ORDER BY dateobs) AS partA
+UNION
+    SELECT * FROM 
+    (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'
+    ORDER BY dateobs) AS partB
 ) as Foo