Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 18520)
+++ trunk/ippTools/share/Makefile.am	(revision 18523)
@@ -65,4 +65,5 @@
 	magictool_find_complete_warpruns.sql \
 	magictool_inputskyfile.sql \
+	magictool_totree.sql \
 	magictool_tomask.sql \
 	magictool_toprocess_inputs.sql \
Index: trunk/ippTools/share/magictool_totree.sql
===================================================================
--- trunk/ippTools/share/magictool_totree.sql	(revision 18523)
+++ trunk/ippTools/share/magictool_totree.sql	(revision 18523)
@@ -0,0 +1,9 @@
+SELECT
+    magic_id
+FROM magicRun
+LEFT JOIN magicTree
+    USING(magic_id)
+WHERE
+    magicRun.state = 'run'
+    AND magicTree.node IS NULL
+    AND magicRun.fault = 0