Index: trunk/ippTools/share/camtool_find_pendingexp.sql
===================================================================
--- trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 12259)
+++ trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 14018)
@@ -3,5 +3,5 @@
 -- "cleaner" to use the same query for both cases 
 SELECT
-    camPendingExp.*,
+    camRun.*,
     rawExp.exp_tag,
     rawExp.exp_id,
@@ -9,14 +9,18 @@
     rawExp.telescope,
     rawExp.filelevel
-FROM camPendingExp
-JOIN chipProcessedExp
+FROM camRun
+JOIN chipRun
+    USING(chip_id)
+JOIN chipProcessedImfile
     USING(chip_id)
 JOIN rawExp
-    ON chipProcessedExp.exp_tag = rawExp.exp_tag
+    ON chipProcessedImfile.exp_tag = rawExp.exp_tag
 LEFT JOIN camProcessedExp
-    ON camPendingExp.cam_id = camProcessedExp.cam_id
+    ON camRun.cam_id = camProcessedExp.cam_id
 LEFT JOIN camMask
-    ON camPendingExp.label = camMask.label
+    ON camRun.label = camMask.label
 WHERE
-    camProcessedExp.cam_id IS NULL
+    chipRun.state = 'stop'
+    AND camRun.state = 'run'
     AND camMask.label IS NULL
+    AND camProcessedExp.cam_id IS NULL