Changeset 33034 for trunk/ippTools/share/staticskytool_todo.sql

Timestamp:

Dec 28, 2011, 1:20:06 PM (14 years ago)

Author:

bills

Message:

order pending runs by priority desc

File:

• trunk/ippTools/share/staticskytool_todo.sql (modified) (1 diff)

trunk/ippTools/share/staticskytool_todo.sql

@@ -6 +6 @@
     staticskyRun.state,
     stackRun.tess_id,
-    stackRun.skycell_id
+    stackRun.skycell_id,
+    IFNULL(Label.priority, 10000) AS priority
 FROM staticskyRun
 JOIN staticskyInput USING (sky_id)
 JOIN stackRun USING (stack_id)
 LEFT JOIN staticskyResult USING(sky_id)
+LEFT JOIN Label ON staticskyRun.label = Label.label
 WHERE
    (staticskyRun.state = 'new' AND staticskyResult.sky_id IS NULL)
+   AND (Label.active OR Label.active IS NULL)
+
     -- WHERE hook %s
 GROUP BY sky_id
 HAVING SUM(IF(stackRun.state = 'full', 1, 0)) = COUNT(staticskyInput.sky_id)
+ORDER BY priority DESC, sky_id