Changeset 20473

Timestamp:

Oct 30, 2008, 11:04:59 AM (18 years ago)

Author:

bills

Message:

stop became full count distinct instances of skycell_id

File:

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

trunk/ippTools/share/magictool_definebyquery_select_part1.sql

@@ -11 +11 @@
         exp_id,
         filter,
-        COUNT(skycell_id) AS num_todo
+        COUNT(DISTINCT skycell_id) AS num_todo
     FROM rawExp
     JOIN chipRun USING(exp_id)
@@ -21 +21 @@
     WHERE
         warpSkyfile.ignored = 0
-        AND warpRun.state = 'stop'
+    AND warpRun.state = 'full'
     -- INSERT HERE any additional restrictions (e.g., exp_id, warpSkyfile.good_frac)
 -- INSERT HERE magictool_definebyquery_select_part2.sql