Changeset 35119

Timestamp:

Feb 7, 2013, 1:41:37 PM (13 years ago)

Author:

bills

Message:

Reverse the last change. Do not require a camRun.

File:

• trunk/ippTools/share/bgtool_definechip.sql (modified) (1 diff)

trunk/ippTools/share/bgtool_definechip.sql

@@ -3 +3 @@
 FROM chipRun
 JOIN rawExp USING(exp_id)
-JOIN camRun USING(chip_id)
-JOIN camProcessedExp USING(cam_id)
 LEFT JOIN chipBackgroundRun USING(chip_id)
 WHERE chipRun.state = 'full'
-AND camRun.state = 'full'
-AND camProcessedExp.quality = 0