Changeset 29515 for branches/eam_branches/ipp-20100823/ippTools/share/addtool_find_cam_id.sql

Timestamp:

Oct 21, 2010, 2:45:13 PM (16 years ago)

Author:

eugene

Message:

merge changes from trunk

File:

• branches/eam_branches/ipp-20100823/ippTools/share/addtool_find_cam_id.sql (modified) (3 diffs)

branches/eam_branches/ipp-20100823/ippTools/share/addtool_find_cam_id.sql

@@ -2 +2 @@
     camRun.*
 FROM camRun
+JOIN camProcessedExp
+    USING(cam_id)
 JOIN chipRun
     USING(chip_id)
@@ -10 +12 @@
            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 +19 @@
 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