Index: trunk/ippTools/share/magictool_inputs.sql
===================================================================
--- trunk/ippTools/share/magictool_inputs.sql	(revision 18561)
+++ trunk/ippTools/share/magictool_inputs.sql	(revision 18573)
@@ -3,11 +3,12 @@
 -- Single skycells
 SELECT
+    magicRun.magic_id,
+    magicRun.state,
     magicInputSkyfile.node,
-    magicRun.state,
     diffSkyfile.uri,
     diffSkyfile.fault
 FROM magicInputSkyfile
 JOIN diffSkyfile
-    using(diff_id)
+    USING(diff_id)
 JOIN magicRun
     USING(magic_id)
@@ -15,6 +16,7 @@
 -- Merged skycells
 SELECT
+    magicRun.magic_id,
+    magicRun.state,
     magicTree.node,
-    magicRun.state,
     magicNodeResult.uri,
     magicNodeResult.fault
Index: trunk/ippTools/share/magictool_tomask.sql
===================================================================
--- trunk/ippTools/share/magictool_tomask.sql	(revision 18561)
+++ trunk/ippTools/share/magictool_tomask.sql	(revision 18573)
@@ -10,4 +10,5 @@
     magicRun.state = 'run'
     AND magicNodeResult.node = 'root'
+    AND magicNodeResult.fault = 0
 GROUP BY
     magic_id
Index: trunk/ippTools/share/magictool_toprocess_tree.sql
===================================================================
--- trunk/ippTools/share/magictool_toprocess_tree.sql	(revision 18561)
+++ trunk/ippTools/share/magictool_toprocess_tree.sql	(revision 18573)
@@ -3,5 +3,6 @@
     -- 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,
+    magicNodeResult.fault IS TRUE as bad
 FROM magicTree
 JOIN magicRun