Changeset 31793

Timestamp:

Jun 29, 2011, 11:47:44 AM (15 years ago)

Author:

Serge CHASTEL

Message:

LAP stacks

File:

• branches/sc_branches/ippMonitorLap/def/lapExposures.d (modified) (1 diff)

branches/sc_branches/ippMonitorLap/def/lapExposures.d

@@ -1 @@
-TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) JOIN chipRun AS chipRun1 USING(chip_id) JOIN camRun AS camRun1 ON camRun1.chip_id=chipRun1.chip_id JOIN fakeRun AS fakeRun1 ON fakeRun1.cam_id=camRun1.cam_id JOIN warpRun AS warpRun1 ON warpRun1.fake_id=fakeRun1.fake_id JOIN chipRun AS chipRun2 ON chipRun2.chip_id=lapExp.pair_id JOIN camRun AS camRun2 ON camRun2.chip_id=chipRun2.chip_id JOIN fakeRun AS fakeRun2 ON fakeRun2.cam_id=camRun2.cam_id JOIN warpRun AS warpRun2 ON warpRun2.fake_id=fakeRun2.fake_id JOIN diffInputSkyfile ON diffInputSkyfile.warp1=warpRun1.warp_id AND diffInputSkyfile.warp2=warpRun2.warp_id JOIN diffRun USING(diff_id)
+TABLE lapRun LEFT JOIN lapExp USING(lap_id) LEFT JOIN rawExp USING(exp_id,filter) LEFT JOIN chipRun AS chipRun1 USING(chip_id) LEFT JOIN camRun AS camRun1 ON camRun1.chip_id=chipRun1.chip_id LEFT JOIN fakeRun AS fakeRun1 ON fakeRun1.cam_id=camRun1.cam_id LEFT JOIN warpRun AS warpRun1 ON warpRun1.fake_id=fakeRun1.fake_id LEFT JOIN chipRun AS chipRun2 ON chipRun2.chip_id=lapExp.pair_id LEFT JOIN camRun AS camRun2 ON camRun2.chip_id=chipRun2.chip_id LEFT JOIN fakeRun AS fakeRun2 ON fakeRun2.cam_id=camRun2.cam_id LEFT JOIN warpRun AS warpRun2 ON warpRun2.fake_id=fakeRun2.fake_id LEFT JOIN diffInputSkyfile ON diffInputSkyfile.warp1=warpRun1.warp_id AND diffInputSkyfile.warp2=warpRun2.warp_id LEFT JOIN diffRun USING(diff_id)
 TITLE LAP Exposures
 FILE  lapExposures.php