Changeset 28794 for branches/eam_branches/ipp-20100621/ippTools/share/warptool_listrun.sql

Timestamp:

Jul 30, 2010, 9:31:50 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

File:

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

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

@@ -10 +10 @@
     rawExp.ra,
     rawExp.decl,
-    rawExp.exp_time
+    rawExp.exp_time,
+    magicDSRun.state AS dsRun_state,
+    IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id
 FROM warpRun
 JOIN fakeRun
@@ -20 +22 @@
 JOIN rawExp
     ON chipRun.exp_id  = rawExp.exp_id
+LEFT JOIN magicDSRun
+    ON stage = 'warp' AND stage_id = warp_id