Changeset 27840 for branches/simtest_nebulous_branches/ippTools/share/difftool_definewarpstack_part1.sql

Timestamp:

May 3, 2010, 8:50:52 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/simtest_nebulous_branches

Files:

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

branches/simtest_nebulous_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
@@ -25 +26 @@
     JOIN chipRun USING(chip_id)
     WHERE warp1 IS NOT NULL
+        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