Changeset 20976 for trunk/ippTools/share/difftool_inputskyfile.sql

Timestamp:

Dec 13, 2008, 11:48:02 AM (17 years ago)

Author:

bills

Message:

tweaks for stack vesrus stack diffs (where exp_id is NULL)

File:

• trunk/ippTools/share/difftool_inputskyfile.sql (modified) (4 diffs)

trunk/ippTools/share/difftool_inputskyfile.sql

@@ -47 +47 @@
         warpSkyfile.uri,
         warpSkyfile.path_base,
-        0 as template,
+        1 as template,
         rawExp.camera
     FROM diffRun
@@ -85 +85 @@
         stackSumSkyfile.uri,
         stackSumSkyfile.path_base,
-        1 as template,
+        0 as template,
         rawExp.camera
     FROM diffRun
@@ -92 +92 @@
     JOIN stackSumSkyfile
         ON  diffInputSkyfile.stack1 = stackSumSkyfile.stack_id
+    JOIN stackInputSkyfile
+        ON diffInputSkyfile.stack1 = stackInputSkyfile.stack_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 rawExp
-        USING(exp_id)
+        ON chipRun.exp_id = rawExp.exp_id
     WHERE
         diffRun.state = 'new'
@@ -114 +124 @@
     JOIN stackSumSkyfile
         ON  diffInputSkyfile.stack2 = stackSumSkyfile.stack_id
+    JOIN stackInputSkyfile
+        ON diffInputSkyfile.stack2 = stackInputSkyfile.stack_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 rawExp
-        USING(exp_id)
+        ON chipRun.exp_id = rawExp.exp_id
     WHERE
         diffRun.state = 'new'