Index: /trunk/ippTools/share/Makefile.am
===================================================================
--- /trunk/ippTools/share/Makefile.am	(revision 15271)
+++ /trunk/ippTools/share/Makefile.am	(revision 15272)
@@ -38,5 +38,6 @@
 	difftool_todiffskyfile.sql \
 	difftool_revertdiffskyfile.sql \
-	magictool_toprocess.sql \
+	magictool_toprocess_inputs.sql \
+	magictool_toprocess_tree.sql \
 	pztool_find_completed_exp.sql \
 	pztool_pendingimfile.sql \
Index: /trunk/ippTools/share/magictool_toprocess.sql
===================================================================
--- /trunk/ippTools/share/magictool_toprocess.sql	(revision 15271)
+++ /trunk/ippTools/share/magictool_toprocess.sql	(revision 15272)
@@ -3,5 +3,25 @@
     -- convert magic_id into a boolean value (1 or 0)
     -- note that the type stays a 64 bit int
-    magicNodeResult.magic_id IS TRUE as done
+    magicNodeResult.magic_id IS TRUE as done,
+    diffSkyfile.uri
+FROM magicTree
+JOIN magicRun
+    USING(magic_id)
+JOIN magicInputSkyfile
+    USING(magic_id, node)
+LEFT JOIN diffSkyfile
+    using(diff_id)
+LEFT JOIN magicNodeResult
+    ON magicTree.magic_id = magicNodeResult.magic_id
+    AND magicTree.node = magicNodeResult.node
+WHERE
+    magicRun.state = 'run'
+UNION
+SELECT
+    magicTree.*,
+    -- convert magic_id into a boolean value (1 or 0)
+    -- note that the type stays a 64 bit int
+    magicNodeResult.magic_id IS TRUE as done,
+    magicNodeResult.uri
 FROM magicTree
 JOIN magicRun
Index: /trunk/ippTools/share/magictool_toprocess_inputs.sql
===================================================================
--- /trunk/ippTools/share/magictool_toprocess_inputs.sql	(revision 15272)
+++ /trunk/ippTools/share/magictool_toprocess_inputs.sql	(revision 15272)
@@ -0,0 +1,18 @@
+SELECT
+    magicTree.*,
+    -- convert magic_id into a boolean value (1 or 0)
+    -- note that the type stays a 64 bit int
+    magicNodeResult.magic_id IS TRUE as done,
+    diffSkyfile.uri
+FROM magicTree
+JOIN magicRun
+    USING(magic_id)
+JOIN magicInputSkyfile
+    USING(magic_id, node)
+LEFT JOIN diffSkyfile
+    using(diff_id)
+LEFT JOIN magicNodeResult
+    ON magicTree.magic_id = magicNodeResult.magic_id
+    AND magicTree.node = magicNodeResult.node
+WHERE
+    magicRun.state = 'run'
Index: /trunk/ippTools/share/magictool_toprocess_tree.sql
===================================================================
--- /trunk/ippTools/share/magictool_toprocess_tree.sql	(revision 15272)
+++ /trunk/ippTools/share/magictool_toprocess_tree.sql	(revision 15272)
@@ -0,0 +1,14 @@
+SELECT
+    magicTree.*,
+    -- convert magic_id into a boolean value (1 or 0)
+    -- note that the type stays a 64 bit int
+    magicNodeResult.magic_id IS TRUE as done,
+    magicNodeResult.uri
+FROM magicTree
+JOIN magicRun
+    USING(magic_id)
+LEFT JOIN magicNodeResult
+    ON magicTree.magic_id = magicNodeResult.magic_id
+    AND magicTree.node = magicNodeResult.node
+WHERE
+    magicRun.state = 'run'