Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 42387)
+++ trunk/ippTools/share/Makefile.am	(revision 42480)
@@ -523,4 +523,6 @@
 	fftool_definebyquery.sql \
 	fftool_definebyquery_select_warps.sql \
+	fftool_defineforstacks.sql \
+	fftool_defineforstacks_select_warps.sql \
 	fftool_result.sql \
 	fftool_revert.sql \
Index: trunk/ippTools/share/fftool_defineforstacks.sql
===================================================================
--- trunk/ippTools/share/fftool_defineforstacks.sql	(revision 42480)
+++ trunk/ippTools/share/fftool_defineforstacks.sql	(revision 42480)
@@ -0,0 +1,14 @@
+SELECT
+    skycalRun.skycal_id,
+    skycalResult.path_base,
+    skycalRun.data_group,
+    stackRun.tess_id,
+    stackRun.skycell_id,
+    stackRun.filter
+FROM skycalRun
+    JOIN skycalResult USING(skycal_id)
+    JOIN stackRun USING(stack_id)
+    JOIN skycell USING(tess_id, skycell_id)
+    -- join hook %s
+WHERE 
+    skycalRun.state = 'full' AND skycalResult.quality = 0
Index: trunk/ippTools/share/fftool_defineforstacks_select_warps.sql
===================================================================
--- trunk/ippTools/share/fftool_defineforstacks_select_warps.sql	(revision 42480)
+++ trunk/ippTools/share/fftool_defineforstacks_select_warps.sql	(revision 42480)
@@ -0,0 +1,5 @@
+SELECT warp_id
+FROM stackInputSkyfile
+     JOIN stackRun USING (stack_id)
+     JOIN skycalRun USING (stack_id)
+WHERE skycal_id = '%d'