Index: trunk/ippTools/share/magictool_find_unmagiced.sql
===================================================================
--- trunk/ippTools/share/magictool_find_unmagiced.sql	(revision 15478)
+++ trunk/ippTools/share/magictool_find_unmagiced.sql	(revision 15483)
@@ -1,7 +1,8 @@
+-- find warp_id that have had all of their skycell's differenced but have not
+-- yet been magic'd
 SELECT DISTINCT
-    warpSkyCellMap.*,
-    diffInputSkyfile.*
+    warpRun.warp_id
 FROM warpRun
--- find all of the skycells that came out of a single exposures
+-- find all of the skycells that came out of a single exposure
 JOIN warpSkyCellMap
     USING(warp_id)
@@ -24,9 +25,9 @@
     AND (diffRun.state = 'stop' || diffRun.state IS NULL)
     AND (warpSkyfile.fault = 0 || warpSkyfile.fault IS NULL)
-    AND (diffInputSkyfile.template = 0 || diffInputSkyfile.template IS NULL)
+    AND (diffInputSkyfile.template = 1 || diffInputSkyfile.template IS NULL)
     AND (diffInputSkyfile.kind = 'warped' || diffInputSkyfile.kind IS NULL)
     AND (diffSkyfile.fault = 0 || diffSkyfile.fault IS NULL)
     AND magicInputSkyfile.diff_id IS NULL
 GROUP BY
-    warpRun.warp_id
+    warpRun.warp_id, warpSkyCellMap.skycell_id, diffInputSkyfile.skycell_id
 HAVING COUNT(warpSkyCellMap.skycell_id) = COUNT(diffInputSkyfile.skycell_id)