Index: /trunk/ippTools/share/addtool_find_cam_id.sql
===================================================================
--- /trunk/ippTools/share/addtool_find_cam_id.sql	(revision 29406)
+++ /trunk/ippTools/share/addtool_find_cam_id.sql	(revision 29407)
@@ -2,4 +2,6 @@
     camRun.*
 FROM camRun
+JOIN camProcessedExp
+    USING(cam_id)
 JOIN chipRun
     USING(chip_id)
@@ -10,5 +12,5 @@
            FROM addRun
            JOIN camRun USING(cam_id)
-           JOIN chipRun USING(chip_id)
+	   JOIN chipRun USING(chip_id)
           ) as foo
      ON exp_id = added_exp_id
@@ -17,4 +19,5 @@
 WHERE
     camRun.state = 'full'
+    AND camProcessedExp.quality = 0
     AND added_exp_id IS NULL
     -- addtool adds checks on exposure being added to the dvodb previously
Index: /trunk/ippTools/share/addtool_find_cam_id_dvo.sql
===================================================================
--- /trunk/ippTools/share/addtool_find_cam_id_dvo.sql	(revision 29406)
+++ /trunk/ippTools/share/addtool_find_cam_id_dvo.sql	(revision 29407)
@@ -1,6 +1,7 @@
 SELECT camRun.* FROM camRun
+JOIN camProcessedExp USING(cam_id)
 JOIN chipRun USING(chip_id)
 JOIN rawExp USING(exp_id)
-WHERE camRun.state = 'full'
+WHERE camRun.state = 'full' and camProcessedExp.quality = 0
     AND exp_id NOT IN (SELECT exp_id
        FROM addRun