Index: trunk/ippTools/share/magictool_chipprocessedimfile.sql
===================================================================
--- trunk/ippTools/share/magictool_chipprocessedimfile.sql	(revision 20690)
+++ trunk/ippTools/share/magictool_chipprocessedimfile.sql	(revision 20690)
@@ -0,0 +1,24 @@
+SELECT
+    chip_id,
+    class_id,
+    chipProcessedImfile.uri,
+    chipProcessedImfile.path_base
+FROM magicRun
+JOIN magicInputSkyfile USING(magic_id)
+JOIN diffRun USING(diff_id)
+JOIN diffInputSkyfile
+    ON diffInputSkyfile.diff_id = diffRun.diff_id
+    -- Want input warps only
+    AND diffInputSkyfile.warp_id IS NOT NULL
+    AND diffInputSkyfile.template = 0
+JOIN warpRun USING(warp_id)
+JOIN warpSkyCellMap USING(warp_id,skycell_id)
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN chipProcessedImfile USING(chip_id,class_id)
+WHERE
+    chipRun.state = 'full'
+    AND chipProcessedImfile.fault = 0
+--   AND magicRun.state = 'stop'
+--   AND magicMask.fault = 0
Index: trunk/ippTools/share/magictool_diffskyfile.sql
===================================================================
--- trunk/ippTools/share/magictool_diffskyfile.sql	(revision 20690)
+++ trunk/ippTools/share/magictool_diffskyfile.sql	(revision 20690)
@@ -0,0 +1,13 @@
+SELECT
+    diff_id,
+    diffSkyfile.uri,
+    diffSkyfile.path_base
+FROM magicRun
+JOIN magicInputSkyfile USING(magic_id)
+JOIN diffRun USING(diff_id)
+JOIN diffSkyfile USING(diff_id)
+WHERE
+    diffRun.state = 'full'
+    AND diffSkyfile.fault = 0
+--   AND magicRun.state = 'stop'
+--   AND magicMask.fault = 0
Index: trunk/ippTools/share/magictool_rawimfile.sql
===================================================================
--- trunk/ippTools/share/magictool_rawimfile.sql	(revision 20690)
+++ trunk/ippTools/share/magictool_rawimfile.sql	(revision 20690)
@@ -0,0 +1,24 @@
+SELECT
+    exp_id,
+    class_id,
+    rawImfile.uri
+FROM magicRun
+JOIN magicInputSkyfile USING(magic_id)
+JOIN diffRun USING(diff_id)
+JOIN diffInputSkyfile
+    ON diffInputSkyfile.diff_id = diffRun.diff_id
+    -- Want input warps only
+    AND diffInputSkyfile.warp_id IS NOT NULL
+    AND diffInputSkyfile.template = 0
+JOIN warpSkyfile USING(warp_id,skycell_id)
+JOIN warpRun USING(warp_id)
+JOIN warpSkyCellMap USING(warp_id,skycell_id)
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
+JOIN rawImfile USING(exp_id,class_id)
+WHERE
+    rawImfile.fault = 0
+--   AND magicRun.state = 'stop'
+--   AND magicMask.fault = 0
Index: trunk/ippTools/share/magictool_warpskyfile.sql
===================================================================
--- trunk/ippTools/share/magictool_warpskyfile.sql	(revision 20690)
+++ trunk/ippTools/share/magictool_warpskyfile.sql	(revision 20690)
@@ -0,0 +1,20 @@
+SELECT
+    warp_id,
+    skycell_id,
+    warpSkyfile.uri,
+    warpSkyfile.path_base
+FROM magicRun
+JOIN magicInputSkyfile USING(magic_id)
+JOIN diffRun USING(diff_id)
+JOIN diffInputSkyfile
+    ON diffInputSkyfile.diff_id = diffRun.diff_id
+    -- Want input warps only
+    AND diffInputSkyfile.warp_id IS NOT NULL
+    AND diffInputSkyfile.template = 0
+JOIN warpSkyfile USING(warp_id,skycell_id)
+JOIN warpRun USING(warp_id)
+WHERE
+    warpRun.state = 'full'
+    AND warpSkyfile.fault = 0
+--   AND magicRun.state = 'stop'
+--   AND magicMask.fault = 0