Index: trunk/ippTools/share/magictool_find_unmagiced.sql
===================================================================
--- trunk/ippTools/share/magictool_find_unmagiced.sql	(revision 15465)
+++ trunk/ippTools/share/magictool_find_unmagiced.sql	(revision 15465)
@@ -0,0 +1,24 @@
+SELECT
+    *
+FROM warpRun
+-- find all of the skycells that came out of a single exposures
+JOIN warpSkyCellMap
+    USING(warp_id)
+-- find out which skycells have been diff'd
+LEFT JOIN diffInputSkyfile
+    USING(skycell_id, tess_id)
+JOIN diffRun
+    USING(diff_id)
+-- find out which diff'd skycells have been added to a magic run
+LEFT JOIN magicInputSkyfile
+    USING(diff_id)
+JOIN magicRun
+    USING (magic_id)
+WHERE
+    diffRun.state = 'stop'
+    AND warpRun.state = 'stop'
+    AND diffInputSkyfile.template = 0
+    AND diffInputSkyfile.kind = 'warped'
+    AND diffInputSkyfile.skycell_id IS NOT NULL
+    AND diffInputSkyfile.tess_id IS NOT NULL
+    AND magicInputSkyfile.diff_id IS NULL