Changeset 28980 for branches/eam_branches/ipp-20100621/ippTools/share/magicdstool_torevert_chip.sql

Timestamp:

Aug 19, 2010, 6:50:13 PM (16 years ago)

Author:

eugene

Message:

updates from trunk

File:

• branches/eam_branches/ipp-20100621/ippTools/share/magicdstool_torevert_chip.sql (modified) (2 diffs)

branches/eam_branches/ipp-20100621/ippTools/share/magicdstool_torevert_chip.sql

@@ -2 +2 @@
     magic_ds_id,
     magicDSRun.state,
-    exp_id,
+    rawExp.exp_id,
     re_place,
     camera,
@@ -19 +19 @@
     JOIN camProcessedExp using(cam_id)
     JOIN chipRun ON (stage_id = chipRun.chip_id)
-    -- JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
-    JOIN chipProcessedImfile USING(chip_id, exp_id)
-    JOIN rawExp using(exp_id)
+    JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
+    JOIN rawExp ON chipRun.exp_id = rawExp.exp_id
 WHERE magicDSRun.stage = 'chip'
     AND ((magicDSRun.state = 'new' AND magicDSFile.fault > 0)