Index: trunk/ippTools/share/pztool_find_completed_exp.sql
===================================================================
--- trunk/ippTools/share/pztool_find_completed_exp.sql	(revision 16527)
+++ trunk/ippTools/share/pztool_find_completed_exp.sql	(revision 16588)
@@ -1,31 +1,34 @@
 SELECT DISTINCT
-    exp_name, -- return should match pzDoneExp
+    exp_name, -- return should match pzDownloadExp
     camera,
-    telescope
+    telescope,
+    state
 FROM (
     SELECT
-        pzDoneImfile.*,
+        pzDownloadImfile.*,
+        pzDownloadExp.state,
         summitExp.imfiles
-    FROM pzDoneExp
+    FROM pzDownloadExp
     JOIN summitExp
         USING(exp_name, camera, telescope)
-    LEFT JOIN pzDoneImfile
+    LEFT JOIN pzDownloadImfile
         USING(exp_name, camera, telescope)
     LEFT JOIN newExp
-        ON pzDoneExp.exp_name = newExp.tmp_exp_name
-        AND pzDoneExp.camera = newExp.tmp_camera
-        AND pzDoneExp.telescope = newExp.tmp_telescope
+        ON pzDownloadExp.exp_name = newExp.tmp_exp_name
+        AND pzDownloadExp.camera = newExp.tmp_camera
+        AND pzDownloadExp.telescope = newExp.tmp_telescope
     WHERE
-        newExp.tmp_exp_name IS NULL
+        pzDownloadExp.state = 'run'
+        AND newExp.tmp_exp_name IS NULL
         AND newExp.tmp_camera IS NULL
         AND newExp.tmp_telescope IS NULL
     GROUP BY
-        pzDoneExp.exp_name,
-        pzDoneExp.camera,
-        pzDoneExp.telescope
-    -- it doesn't matter which field in pzDoneImfile we count as we've already
-    -- done a group by
+        pzDownloadExp.exp_name,
+        pzDownloadExp.camera,
+        pzDownloadExp.telescope
+    -- it doesn't matter which field in pzDownloadImfile we count as we've
+    -- already Download a group by
     HAVING
-        COUNT(pzDoneImfile.exp_name) = summitExp.imfiles
-        AND SUM(pzDoneImfile.fault) = 0
+        COUNT(pzDownloadImfile.exp_name) = summitExp.imfiles
+        AND SUM(pzDownloadImfile.fault) = 0
     ) as Foo
Index: trunk/ippTools/share/pztool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/pztool_pendingimfile.sql	(revision 16527)
+++ 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
Index: trunk/ippTools/share/pztool_revertcopied.sql
===================================================================
--- trunk/ippTools/share/pztool_revertcopied.sql	(revision 16527)
+++ trunk/ippTools/share/pztool_revertcopied.sql	(revision 16588)
@@ -1,3 +1,3 @@
-DELETE FROM pzDoneImfile
+DELETE FROM pzDownloadImfile
 WHERE
     fault != 0