Changeset 15483

Timestamp:

Nov 6, 2007, 2:49:58 PM (19 years ago)

Author:

jhoblitt

Message:

final tweaks

File:

• trunk/ippTools/share/magictool_find_unmagiced.sql (modified) (2 diffs)

trunk/ippTools/share/magictool_find_unmagiced.sql

@@ +1 @@
+-- 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 +25 @@
     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)