Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 12262)
+++ trunk/ippTools/share/Makefile.am	(revision 12263)
@@ -22,4 +22,7 @@
 	regtool_processedexp.sql \
 	regtool_processedimfile.sql \
+	stacktool_inputskyfile.sql \
+	stacktool_sumskyfile.sql \
+	stacktool_tosum.sql \
 	warptool_exp.sql \
 	warptool_imfile.sql \
Index: trunk/ippTools/share/stacktool_inputskyfile.sql
===================================================================
--- trunk/ippTools/share/stacktool_inputskyfile.sql	(revision 12263)
+++ trunk/ippTools/share/stacktool_inputskyfile.sql	(revision 12263)
@@ -0,0 +1,16 @@
+SELECT
+    warpSkyfile.*,
+    rawExp.camera
+FROM stackRun
+JOIN stackInputSkyfile
+    USING(stack_id)
+JOIN warpSkyfile
+    ON  stackInputSkyfile.warp_id = warpSkyfile.warp_id
+    AND stackRun.skycell_id       = warpSkyfile.skycell_id
+    AND stackRun.tess_id          = warpSkyfile.tess_id
+JOIN warpInputExp
+    ON stackInputSkyfile.warp_id = warpInputExp.warp_id
+JOIN rawExp
+    ON warpInputExp.exp_tag = rawExp.exp_tag
+WHERE
+    stackRun.state = 'run'
Index: trunk/ippTools/share/stacktool_sumskyfile.sql
===================================================================
--- trunk/ippTools/share/stacktool_sumskyfile.sql	(revision 12263)
+++ trunk/ippTools/share/stacktool_sumskyfile.sql	(revision 12263)
@@ -0,0 +1,7 @@
+SELECT
+    stackSumSkyfile.*
+FROM stackRun
+JOIN stackSumSkyfile
+    USING(stack_id)
+WHERE
+    stackRun.state = 'run'
Index: trunk/ippTools/share/stacktool_tosum.sql
===================================================================
--- trunk/ippTools/share/stacktool_tosum.sql	(revision 12263)
+++ trunk/ippTools/share/stacktool_tosum.sql	(revision 12263)
@@ -0,0 +1,9 @@
+SELECT
+    stackRun.stack_id,
+    stackRun.workdir
+FROM stackRun
+LEFT JOIN stackSumSkyfile
+    USING(stack_id)
+WHERE
+    stackRun.state = 'run'
+    AND stackSumSkyfile.stack_id IS NULL