Changeset 27839 for branches/simmosaic_branches/ippTools/share/difftool_definewarpstack_part1.sql

Timestamp:

May 3, 2010, 8:45:22 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/simmosaic_branches

Files:

• . (modified) (1 prop)
• ippTools/share/difftool_definewarpstack_part1.sql (modified) (3 diffs)

branches/simmosaic_branches/ippTools/share/difftool_definewarpstack_part1.sql

@@ -5 +5 @@
     warpRun.label,
     warpRun.tess_id,
+    warpRun.data_group,
     COUNT(skycell_id) as skycell_count
 FROM warpRun
@@ -15 +16 @@
     SELECT DISTINCT
         diffRun.*,
+        warp_id,
         exp_id
     FROM diffRun
@@ -24 +26 @@
     JOIN chipRun USING(chip_id)
     WHERE warp1 IS NOT NULL
-) AS diffExp USING(exp_id)
+        AND warpRun.state = 'full'
+    -- warp where hook %s
+) AS diffExp USING(exp_id, warp_id)
 WHERE
-    warpSkyfile.fault = 0
+    warpRun.state = 'full'
+    AND warpSkyfile.fault = 0
     AND warpSkyfile.quality = 0
     -- warp where hook %s