Index: trunk/ippTools/share/warptool_towarped.sql
===================================================================
--- trunk/ippTools/share/warptool_towarped.sql	(revision 17145)
+++ trunk/ippTools/share/warptool_towarped.sql	(revision 18029)
@@ -3,5 +3,6 @@
     warpSkyCellMap.skycell_id,
     warpSkyCellMap.tess_id,
-    warpSkyCellMap.cam_id,
+    warpRun.fake_id,
+    camRun.cam_id,
     rawExp.camera,
     warpRun.workdir
@@ -9,12 +10,14 @@
 JOIN warpSkyCellMap
     USING(warp_id)
-JOIN camProcessedExp
-    ON warpSkyCellMap.cam_id = camProcessedExp.cam_id
+JOIN fakeRun
+    USING(fake_id)
+JOIN camRun
+    USING(cam_id)
 JOIN chipRun
-    ON camProcessedExp.chip_id = chipRun.chip_id
+    USING(chip_id)
 JOIN chipProcessedImfile
-    ON chipRun.chip_id = chipProcessedImfile.chip_id
+    USING(chip_id)
 JOIN rawExp
-    ON chipProcessedImfile.exp_id = rawExp.exp_id
+    ON chipRun.exp_id = rawExp.exp_id
 LEFT JOIN warpSkyfile
     ON warpRun.warp_id = warpSkyfile.warp_id
@@ -25,4 +28,7 @@
 WHERE
     warpRun.state = 'run'
+    AND fakeRun.state = 'stop'
+    AND camRun.state = 'stop'
+    AND chipRun.state = 'stop'
     AND warpSkyfile.warp_id IS NULL
     AND warpSkyfile.skycell_id IS NULL