Changeset 20608 for trunk/ippTools/share/faketool_completely_processed_exp.sql

Timestamp:

Nov 9, 2008, 1:51:39 PM (18 years ago)

Author:

Paul Price

Message:

Change to run a subset of a camera seems to work, based on a simtest and a manual run through with one of two rawImfiles with ignored = 1. Merging pap_branch_20081109; no conflicts.

File:

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

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