Index: trunk/ippTools/share/magictool_tomask.sql
===================================================================
--- trunk/ippTools/share/magictool_tomask.sql	(revision 18573)
+++ trunk/ippTools/share/magictool_tomask.sql	(revision 18781)
@@ -1,10 +1,12 @@
 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'