Changeset 19078 for branches/eam_branch_20080719/ippTools/share/difftool_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/difftool_pendingcleanuprun.sql (modified) (2 diffs)

branches/eam_branch_20080719/ippTools/share/difftool_pendingcleanuprun.sql

@@ +1 @@
+-- does this result in too many entries (one for each diffInputSkyfile?)
+-- all of this is just to get the camera used for the diff run
 SELECT
     diffRun.diff_id,
@@ -4 +6 @@
     diffRun.state
 FROM diffRun
-JOIN rawExp 
-USING (exp_id)
+JOIN diffInputSkyfile
+    USING(diff_id)
+JOIN warpSkyfile
+    ON  diffInputSkyfile.warp_id    = warpSkyfile.warp_id
+    AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
+    AND diffInputSkyfile.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)
 WHERE
     diffRun.state = 'goto_cleaned'