Changeset 20605 for branches/pap_branch_20081109/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

Nov 9, 2008, 12:09:21 PM (18 years ago)

Author:

Paul Price

Message:

Allowing chips (class_id) to be ignored in all stages following registration

File:

• branches/pap_branch_20081109/ippTools/share/chiptool_completely_processed_exp.sql (modified) (2 diffs)

branches/pap_branch_20081109/ippTools/share/chiptool_completely_processed_exp.sql

@@ -13 +13 @@
     end_stage
 FROM
-    (SELECT 
+    (SELECT
         chipRun.*,
         rawImfile.class_id as rawimfile_class_id,
@@ -19 +19 @@
     FROM chipRun
     JOIN rawImfile
-        USING(exp_id)
+        ON chipRun.exp_id = rawImfile.exp_id
+        AND rawImfile.ignored = 0
     LEFT JOIN chipProcessedImfile
         ON chipRun.chip_id = chipProcessedImfile.chip_id