Index: trunk/ippTools/share/addtool_find_pendingexp.sql
===================================================================
--- trunk/ippTools/share/addtool_find_pendingexp.sql	(revision 25789)
+++ trunk/ippTools/share/addtool_find_pendingexp.sql	(revision 25816)
@@ -1,4 +1,5 @@
 SELECT
     addRun.*,
+    camProcessedExp.path_base as camroot,
     rawExp.exp_tag,
     rawExp.exp_id,
@@ -9,4 +10,6 @@
 FROM addRun
 JOIN camRun
+    USING(cam_id)
+JOIN camProcessedExp
     USING(cam_id)
 JOIN chipRun
@@ -21,4 +24,6 @@
     camRun.state = 'full'
     AND ((addRun.state = 'new' AND addProcessedExp.add_id IS NULL) OR addRun.state = 'update')
+    AND addRun.dvodb IS NOT NULL
+    AND addRun.workdir IS NOT NULL
     AND addMask.label IS NULL