Changeset 18923 for branches/eam_branch_20080719/ippTools/share/magictool_tomask.sql

Timestamp:

Aug 5, 2008, 2:07:07 PM (18 years ago)

Author:

eugene

Message:

updates from HEAD

File:

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

branches/eam_branch_20080719/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'