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

Timestamp:

Mar 24, 2011, 2:09:53 PM (15 years ago)

Author:

watersc1

Message:

implementation of summit_id index in summit{Exp,Imfile},pzDownload{Exp,Imfile},newExp tables.

File:

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

trunk/ippTools/share/pztool_pendingimfile.sql

@@ -6 +6 @@
     FROM summitImfile
     JOIN pzDownloadExp
-        USING(exp_name, camera, telescope)
+        USING(summit_id)
     LEFT JOIN pzDownloadImfile
-        USING(exp_name, camera, telescope, class, class_id)
+        USING(summit_id, class, class_id)
     JOIN summitExp
-        USING(exp_name, camera, telescope)
+        USING(summit_id)
     WHERE 
         pzDownloadExp.state = 'run'
+        AND pzDownloadImfile.summit_id IS NULL
         AND pzDownloadImfile.exp_name IS NULL
         AND pzDownloadImfile.camera IS NULL