Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 16669)
+++ trunk/ippTools/share/Makefile.am	(revision 16687)
@@ -64,8 +64,9 @@
 	regtool_revertprocessedexp.sql \
 	regtool_revertprocessedimfile.sql \
+	stacktool_find_complete_warps.sql \
 	stacktool_inputskyfile.sql \
+	stacktool_revertsumskyfile.sql \
 	stacktool_sumskyfile.sql \
 	stacktool_tosum.sql \
-	stacktool_revertsumskyfile.sql \
 	warptool_exp.sql \
 	warptool_imfile.sql \
Index: trunk/ippTools/share/stacktool_find_complete_warps.sql
===================================================================
--- trunk/ippTools/share/stacktool_find_complete_warps.sql	(revision 16687)
+++ trunk/ippTools/share/stacktool_find_complete_warps.sql	(revision 16687)
@@ -0,0 +1,20 @@
+    SELECT
+        warp_id,
+        warpSkyfile.skycell_id,
+        warpSkyfile.tess_id
+    FROM warpRun
+    JOIN warpInputExp
+        USING(warp_id)
+    JOIN warpSkyfile 
+        USING(warp_id)
+    JOIN camRun
+        USING(cam_id)
+    JOIN chipRun
+        USING(chip_id)
+    JOIN rawExp
+        USING(exp_id)
+    WHERE
+        warpRun.state = 'stop'
+    GROUP BY
+        warp_id
+