Index: trunk/ippTools/share/magictool_toprocess_tree.sql
===================================================================
--- trunk/ippTools/share/magictool_toprocess_tree.sql	(revision 18781)
+++ trunk/ippTools/share/magictool_toprocess_tree.sql	(revision 18782)
@@ -1,4 +1,7 @@
 SELECT
     magicTree.*,
+    exp_id,
+    camera,
+    magicRun.workdir,
     -- convert magic_id into a boolean value (1 or 0)
     -- note that the type stays a 64 bit int
@@ -6,6 +9,6 @@
     magicNodeResult.fault IS TRUE as bad
 FROM magicTree
-JOIN magicRun
-    USING(magic_id)
+JOIN magicRun USING(magic_id)
+JOIN rawExp USING(exp_id)
 LEFT JOIN magicNodeResult
     ON magicTree.magic_id = magicNodeResult.magic_id
