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

Timestamp:

Feb 22, 2008, 5:01:12 PM (18 years ago)

Author:

jhoblitt

Message:

fix pzDownloadImfile join

File:

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

trunk/ippTools/share/pztool_pendingimfile.sql

@@ -7 +7 @@
     JOIN pzDownloadExp
         USING(exp_name, camera, telescope)
-    JOIN pzDownloadImfile
+    LEFT JOIN pzDownloadImfile
         USING(exp_name, camera, telescope, class, class_id)
     JOIN summitExp
@@ -13 +13 @@
     WHERE 
         pzDownloadExp.state = 'run'
+        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
     ORDER BY
         summitExp.dateobs