Changeset 20743

Timestamp:

Nov 13, 2008, 4:33:06 PM (17 years ago)

Author:

Paul Price

Message:

Fixing to correspond to fixed query.

File:

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

trunk/ippTools/share/magictool_definebyquery.sql

@@ -62 +62 @@
     num_todo,
     num_done,
-    magic_id
+    MAX(magic_id) AS best_magic_id
 FROM (
     -- Number of skycells as a function of exposure
@@ -96 +96 @@
     ) AS magicDiffNums USING(exp_id)
 LEFT JOIN magicRun USING(exp_id)
+;
+
 WHERE
-    magicRun.magic_id IS NULL
+    magic_id IS NULL
 ;