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