Changeset 30812 for branches/eam_branches/ipp-20110213/ippTools/share/magicdstool_todestreak_raw.sql

Timestamp:

Mar 6, 2011, 2:34:55 PM (15 years ago)

Author:

eugene

Message:

updates from trunk

File:

• branches/eam_branches/ipp-20110213/ippTools/share/magicdstool_todestreak_raw.sql (modified) (2 diffs)

branches/eam_branches/ipp-20110213/ippTools/share/magicdstool_todestreak_raw.sql

@@ -24 +24 @@
     re_place,
     remove,
-    10000 AS priority
+    IFNULL(Label.priority, 10000) AS priority
 FROM magicDSRun
 JOIN magicMask USING (magic_id)
@@ -35 +35 @@
     ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
     AND magicDSFile.component = rawImfile.class_id
+LEFT JOIN Label ON magicDSRun.label = Label.label
 WHERE
     magicDSRun.state = 'new'
     AND magicDSRun.stage = 'raw'
     AND magicDSFile.component IS NULL
+    AND (Label.active OR Label.active IS NULL)
+