Index: trunk/ippTools/share/pztool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/pztool_pendingimfile.sql	(revision 15821)
+++ trunk/ippTools/share/pztool_pendingimfile.sql	(revision 16588)
@@ -4,9 +4,13 @@
         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