Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 12259)
+++ trunk/ippTools/share/Makefile.am	(revision 12261)
@@ -19,4 +19,8 @@
 	regtool_processedexp.sql \
 	regtool_processedimfile.sql \
-	warptool_tooverlap.sql
-
+	warptool_exp.sql \
+	warptool_imfile.sql \
+	warptool_scmap.sql \
+	warptool_tooverlap.sql \
+	warptool_towarped.sql \
+	warptool_warped.sql
Index: trunk/ippTools/share/warptool_exp.sql
===================================================================
--- trunk/ippTools/share/warptool_exp.sql	(revision 12261)
+++ trunk/ippTools/share/warptool_exp.sql	(revision 12261)
@@ -0,0 +1,10 @@
+SELECT
+    camProcessedExp.*
+FROM warpRun
+JOIN warpInputExp
+    USING(warp_id)
+JOIN camProcessedExp
+    ON warpInputExp.cam_id = camProcessedExp.cam_id
+WHERE
+    warpRun.state = 'run'
+    AND camProcessedExp.fault = 0
Index: trunk/ippTools/share/warptool_imfile.sql
===================================================================
--- trunk/ippTools/share/warptool_imfile.sql	(revision 12261)
+++ trunk/ippTools/share/warptool_imfile.sql	(revision 12261)
@@ -0,0 +1,15 @@
+SELECT
+    rawImfile.*,
+    warpInputExp.cam_id
+FROM warpRun
+JOIN warpInputExp
+    USING(warp_id)
+JOIN camProcessedExp
+    ON warpInputExp.cam_id = camProcessedExp.cam_id
+JOIN chipProcessedExp
+    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN rawImfile -- is there any reason not to refer back to rawimfiles?
+    ON chipProcessedExp.exp_tag = rawImfile.exp_tag
+WHERE
+    warpRun.state = 'run'
+
Index: trunk/ippTools/share/warptool_scmap.sql
===================================================================
--- trunk/ippTools/share/warptool_scmap.sql	(revision 12261)
+++ trunk/ippTools/share/warptool_scmap.sql	(revision 12261)
@@ -0,0 +1,14 @@
+SELECT
+    warpSkyCellMap.*,
+    chipProcessedImfile.uri
+FROM warpRun
+JOIN warpSkyCellMap
+    USING(warp_id)
+JOIN camProcessedExp
+    ON warpSkyCellMap.cam_id = camProcessedExp.cam_id
+JOIN chipProcessedImfile
+    ON camProcessedExp.chip_id = chipProcessedImfile.chip_id
+    AND warpSkyCellMap.class_id = chipProcessedImfile.class_id
+WHERE
+    warpRun.state = 'run'
+
Index: trunk/ippTools/share/warptool_towarped.sql
===================================================================
--- trunk/ippTools/share/warptool_towarped.sql	(revision 12261)
+++ trunk/ippTools/share/warptool_towarped.sql	(revision 12261)
@@ -0,0 +1,23 @@
+SELECT
+    warpSkyCellMap.*,
+    rawExp.camera,
+    warpRun.workdir
+FROM warpRun
+JOIN warpSkyCellMap
+    USING(warp_id)
+JOIN camProcessedExp
+    ON warpSkyCellMap.cam_id = camProcessedExp.cam_id
+JOIN chipProcessedExp
+    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN rawExp
+    ON chipProcessedExp.exp_tag = rawExp.exp_tag
+LEFT JOIN warpSkyfile
+    ON warpRun.warp_id = warpSkyfile.warp_id
+    AND warpSkyCellMap.skycell_id = warpSkyfile.skycell_id
+    AND warpSkyCellMap.tess_id = warpSkyfile.tess_id
+WHERE
+    warpRun.state = 'run'
+    AND warpSkyfile.warp_id IS NULL
+    AND warpSkyfile.skycell_id IS NULL
+    AND warpSkyfile.tess_id IS NULL
+
Index: trunk/ippTools/share/warptool_warped.sql
===================================================================
--- trunk/ippTools/share/warptool_warped.sql	(revision 12261)
+++ trunk/ippTools/share/warptool_warped.sql	(revision 12261)
@@ -0,0 +1,7 @@
+SELECT
+    warpSkyfile.*
+FROM warpRun
+JOIN warpSkyfile
+    USING(warp_id)
+WHERE
+    warpRun.state = 'run'