Index: trunk/ippTools/share/warptool_scmap.sql
===================================================================
--- trunk/ippTools/share/warptool_scmap.sql	(revision 16024)
+++ trunk/ippTools/share/warptool_scmap.sql	(revision 18029)
@@ -7,10 +7,18 @@
 JOIN warpSkyCellMap
     USING(warp_id)
+JOIN fakeRun
+    USING(fake_id)
+JOIN camRun
+    USING(cam_id)
 JOIN camProcessedExp
-    ON warpSkyCellMap.cam_id = camProcessedExp.cam_id
+    USING(cam_id)
+JOIN chipRun
+    USING(chip_id)
 JOIN chipProcessedImfile
-    ON camProcessedExp.chip_id = chipProcessedImfile.chip_id
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
     AND warpSkyCellMap.class_id = chipProcessedImfile.class_id
--- move this as an option into the code
--- WHERE
+WHERE
 --    warpRun.state = 'run'
+    fakeRun.state = 'stop'
+    AND camRun.state = 'stop'
+    AND chipRun.state = 'stop'