Changeset 18781

Timestamp:

Jul 30, 2008, 10:39:37 AM (18 years ago)

Author:

Paul Price

Message:

Need additional values out for script.

File:

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

trunk/ippTools/share/magictool_tomask.sql

@@ -1 +1 @@
 SELECT
     magic_id,
+    exp_id,
+    camera,
+    magicRun.workdir,
     uri
 FROM magicRun
-JOIN magicTree
-    USING(magic_id)
-LEFT JOIN magicNodeResult
-    USING(magic_id, node)
+JOIN rawExp USING(exp_id)
+JOIN magicTree USING(magic_id)
+LEFT JOIN magicNodeResult USING(magic_id, node)
 WHERE
     magicRun.state = 'run'