Changeset 20072 for trunk/ippTools/share/stacktool_sumskyfile.sql

Timestamp:

Oct 12, 2008, 12:29:11 PM (18 years ago)

Author:

bills

Message:

Move getting the camera to a sub query. Using joins resulted in
duplicate entries in the output (one for each input to the stack)

File:

• trunk/ippTools/share/stacktool_sumskyfile.sql (modified) (1 diff)

trunk/ippTools/share/stacktool_sumskyfile.sql

@@ -2 +2 @@
     stackSumSkyfile.*,
     stackRun.state,
-    rawExp.camera
+    (SELECT rawExp.camera FROM 
+        stackInputSkyfile 
+        JOIN warpRun USING(warp_id)
+        JOIN fakeRun ON warpRun.fake_id = fakeRun.fake_id
+        JOIN camRun ON camRun.cam_id = fakeRun.cam_id
+        JOIN chipRun ON camRun.chip_id  = chipRun.chip_id
+        JOIN rawExp ON chipRun.exp_id  = rawExp.exp_id
+        where stack_id = stackRun.stack_id limit 1
+    ) as camera
 FROM stackRun
 JOIN stackSumSkyfile
-    USING(stack_id)
-JOIN stackInputSkyfile
-    USING(stack_id)
-JOIN warpRun
-    USING(warp_id)
-JOIN fakeRun
-    ON warpRun.fake_id = fakeRun.fake_id
-JOIN camRun
-    ON camRun.cam_id   = fakeRun.cam_id
-JOIN chipRun
-    ON camRun.chip_id  = chipRun.chip_id
-JOIN rawExp
-    ON chipRun.exp_id  = rawExp.exp_id
+USING(stack_id)