Changeset 28627 for trunk/ippTools/share/warptool_warped.sql

Timestamp:

Jul 7, 2010, 3:13:55 PM (16 years ago)

Author:

bills

Message:

list magicDSRun state and magic_ds_id in -listrun and -warped

File:

• trunk/ippTools/share/warptool_warped.sql (modified) (2 diffs)

trunk/ippTools/share/warptool_warped.sql

@@ -12 +12 @@
     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 warpSkyfile
@@ -26 +28 @@
 JOIN rawExp
     ON chipRun.exp_id  = rawExp.exp_id
+LEFT JOIN magicDSRun
+    ON stage = 'warp' AND stage_id = warp_id