Changeset 18672 for trunk/ippTools/share/magictool_definebyquery.sql

Timestamp:

Jul 23, 2008, 10:55:10 AM (18 years ago)

Author:

Paul Price

Message:

Don't list all fields.

File:

• trunk/ippTools/share/magictool_definebyquery.sql (modified) (5 diffs)

trunk/ippTools/share/magictool_definebyquery.sql

@@ -43 +43 @@
 WHERE
     diffSkyfile.fault = 0
+-----    AND warpSkyfile.good_frac >= 0.5
 -- magictool_definebyquery_temp_insert_groupby.sql
 GROUP BY
@@ -54 +55 @@
 -- After this follows magictool_definebyquery_select_part2.sql
 SELECT
-    *
+    exp_id,
+    filter,
+    num_todo,
+    num_done
 FROM (
     -- Number of skycells as a function of exposure
@@ -72 +76 @@
         AND warpRun.state = 'stop'
     -- INSERT HERE any additional restrictions (e.g., exp_id, warpSkyfile.good_frac)
+-----        AND warpSkyfile.good_frac > 0.5
 -- INSERT HERE magictool_definebyquery_select_part2.sql
 -- magictool_definebyquery_select_part2.sql
@@ -92 +97 @@
     num_done = num_todo
     AND magicRun.magic_id IS NULL
-
+;
 
 -- magictool_definebyquery_insert.sql
@@ -102 +107 @@
     CONCAT(tess_id, '.', skycell_id) AS node
 FROM magicBestDiffs
+;