Changeset 27840 for branches/simtest_nebulous_branches/ippTools/share/stacktool_inputskyfile.sql

Timestamp:

May 3, 2010, 8:50:52 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/simtest_nebulous_branches

Files:

• . (modified) (1 prop)
• ippTools/share/stacktool_inputskyfile.sql (modified) (1 diff)

branches/simtest_nebulous_branches/ippTools/share/stacktool_inputskyfile.sql

@@ -1 @@
-SELECT DISTINCT
+SELECT
     warpSkyfile.*,
     rawExp.camera
 FROM stackRun
-JOIN stackInputSkyfile
-    USING(stack_id)
+JOIN stackInputSkyfile USING(stack_id)
+JOIN warpRun USING(warp_id)
 JOIN warpSkyfile
-    ON  stackInputSkyfile.warp_id = warpSkyfile.warp_id
-    AND stackRun.skycell_id       = warpSkyfile.skycell_id
-    AND stackRun.tess_id          = warpSkyfile.tess_id
-JOIN warpRun
-    ON stackInputSkyfile.warp_id = warpRun.warp_id
-JOIN fakeRun
-    USING(fake_id)
-JOIN camRun
-    USING(cam_id)
-JOIN chipRun
-    USING(chip_id)
-JOIN chipProcessedImfile
-    USING(chip_id)
-JOIN rawExp
-    ON chipProcessedImfile.exp_id = rawExp.exp_id
+    ON warpSkyfile.warp_id = warpRun.warp_id
+    AND warpSkyfile.tess_id = stackRun.tess_id
+    AND warpSkyfile.skycell_id = stackRun.skycell_id
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)