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

Timestamp:

Feb 21, 2008, 6:09:46 PM (18 years ago)

Author:

jhoblitt

Message:

replumb pz* steps

File:

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

trunk/ippTools/share/pztool_pendingimfile.sql

@@ -4 +4 @@
         summitImfile.*,
         summitExp.dateobs
-    FROM pzPendingImfile
-    JOIN summitImfile
+    FROM summitImfile
+    JOIN pzDownloadExp
+        USING(exp_name, camera, telescope)
+    JOIN pzDownloadImfile
         USING(exp_name, camera, telescope, class, class_id)
     JOIN summitExp
         USING(exp_name, camera, telescope)
+    WHERE 
+        pzDownloadExp.state = 'run'
     ORDER BY
         summitExp.dateobs