Changeset 30809

Timestamp:

Mar 5, 2011, 7:20:30 PM (15 years ago)

Author:

bills

Message:

respect Label status at raw stage

File:

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

trunk/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)
+