Index: trunk/ippTools/share/magictool_find_unmagiced.sql
===================================================================
--- trunk/ippTools/share/magictool_find_unmagiced.sql	(revision 15484)
+++ trunk/ippTools/share/magictool_find_unmagiced.sql	(revision 15499)
@@ -8,5 +8,6 @@
         warpSkyfile.fault as f1,
         diffSkyfile.fault as f2,
-        warpSkyCellMap.skycell_id as s1,
+        warpSkyCellMap.skycell_id as wscm_s,
+        warpSkyfile.skycell_id as wsf_s,
         diffInputSkyfile.skycell_id as s2
     FROM warpRun
@@ -26,6 +27,4 @@
     LEFT JOIN magicInputSkyfile
         USING(diff_id)
-    LEFT JOIN magicRun
-        USING (magic_id)
     WHERE
         warpRun.state = 'stop'
@@ -42,5 +41,6 @@
     --    warpRun.warp_id, warpSkyCellMap.skycell_id, warpSkyCellMap.tess_id
     HAVING
-        COUNT(warpSkyCellMap.skycell_id) = COUNT(diffInputSkyfile.skycell_id)
+        COUNT(warpSkyCellMap.skycell_id) = COUNT(warpSkyfile.skycell_id)
+        AND COUNT(warpSkyCellMap.skycell_id) = COUNT(diffInputSkyfile.skycell_id)
         AND SUM(warpSkyfile.fault) = 0
         AND SUM(diffSkyfile.fault) = 0