Changeset 29417 for trunk/ippTools/share/stacktool_tosum.sql

Timestamp:

Oct 14, 2010, 2:24:09 PM (16 years ago)

Author:

bills

Message:

add priority ordering to pending stacks

File:

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

trunk/ippTools/share/stacktool_tosum.sql

@@ -7 +7 @@
     stackRun.label,
     stackRun.state,
-    stackSumSkyfile.path_base
+    stackSumSkyfile.path_base,
+    IFNULL(Label.priority, 10000) AS priority
 FROM stackRun
 JOIN stackInputSkyfile USING(stack_id)
 JOIN warpRun USING(warp_id)
 LEFT JOIN stackSumSkyfile USING(stack_id)
+LEFT JOIN Label ON Label.label = stackRun.label
 WHERE
     ((stackRun.state = 'new' AND stackSumSkyfile.stack_id IS NULL)
     OR (stackRun.state = 'update' AND stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0))
+    AND (Label.active OR Label.active IS NULL)
     -- WHERE hook %s
 GROUP BY stack_id