Changeset 19078 for branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanuprun.sql

Timestamp:

Aug 14, 2008, 3:28:57 PM (18 years ago)

Author:

eugene

Message:

various fixes to the get command-line options for cleanup stages correct

File:

• branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanuprun.sql (modified) (2 diffs)

branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanuprun.sql

@@ +1 @@
+-- results in too many output files
+-- is the camera needed for this?
+-- is the camera unique for this?
 SELECT
     stackRun.stack_id,
@@ -4 +7 @@
     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)
+     USING (exp_id)
 WHERE
     stackRun.state = 'goto_cleaned'