Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 15340)
+++ trunk/ippTools/share/Makefile.am	(revision 15348)
@@ -41,4 +41,5 @@
 	magictool_toprocess_tree.sql \
 	magictool_tomask.sql \
+	magictool_toskyfilemask.sql \
 	pztool_find_completed_exp.sql \
 	pztool_pendingimfile.sql \
Index: trunk/ippTools/share/magictool_toskyfilemask.sql
===================================================================
--- trunk/ippTools/share/magictool_toskyfilemask.sql	(revision 15348)
+++ trunk/ippTools/share/magictool_toskyfilemask.sql	(revision 15348)
@@ -0,0 +1,10 @@
+SELECT
+    magicMask.*
+FROM magicRun
+JOIN magicMask
+    USING(magic_id)
+LEFT JOIN magicSkyfileMask
+    USING(magic_id)
+WHERE
+    magicRun.state = 'run'
+    AND magicSkyfileMask.magic_id IS NULL
