Changeset 20605 for branches/pap_branch_20081109/ippTools/share/faketool_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/faketool_completely_processed_exp.sql (modified) (2 diffs)

branches/pap_branch_20081109/ippTools/share/faketool_completely_processed_exp.sql

@@ -13 +13 @@
     epoch
 FROM
-    (SELECT 
+    (SELECT
         fakeRun.*,
         rawImfile.class_id as rawimfile_class_id,
@@ -25 +25 @@
         USING(exp_id)
     JOIN rawImfile
-        USING(exp_id)
+        ON rawImfile.exp_id = rawExp.exp_id
+        AND rawImfile.ignored = 0
     LEFT JOIN fakeProcessedImfile
         ON fakeRun.fake_id = fakeProcessedImfile.fake_id