Index: /trunk/ippTools/share/magictool_toprocess.sql
===================================================================
--- /trunk/ippTools/share/magictool_toprocess.sql	(revision 15270)
+++ /trunk/ippTools/share/magictool_toprocess.sql	(revision 15271)
@@ -1,8 +1,13 @@
 SELECT
-    magicTree.*
+    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
 FROM magicTree
+JOIN magicRun
+    USING(magic_id)
 LEFT JOIN magicNodeResult
     ON magicTree.magic_id = magicNodeResult.magic_id
-    AND magicTree.dep = magicNodeResult.node
+    AND magicTree.node = magicNodeResult.node
 WHERE
-    magicNodeResult.node IS NULL
+    magicRun.state = 'run'