Changeset 19598 for trunk/ippTools/share/stacktool_tosum.sql

Timestamp:

Sep 18, 2008, 9:32:59 AM (18 years ago)

Author:

Paul Price

Message:

Don't need camera out any more.

File:

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

trunk/ippTools/share/stacktool_tosum.sql

@@ -5 +5 @@
     stackRun.workdir,
     stackRun.label,
-    stackRun.state,
-    rawExp.camera
+    stackRun.state
 FROM stackRun
 JOIN stackInputSkyfile
     USING(stack_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 warpRun.warp_id = warpSkyfile.warp_id
-JOIN fakeRun
-    USING(fake_id)
-JOIN camRun
-    USING(cam_id)
-JOIN chipRun
-    USING(chip_id)
-JOIN rawExp
-    USING(exp_id)
 LEFT JOIN stackSumSkyfile
     USING(stack_id)
@@ -30 +15 @@
         AND stackSumSkyfile.stack_id IS NULL)
     OR
-    (stackRun.state = 'update' 
+    (stackRun.state = 'update'
         AND stackSumSkyfile.data_state = 'cleaned'))