Changeset 20973 for trunk/ippTools/share/magicdstool_getrunids.sql

Timestamp:

Dec 13, 2008, 10:17:34 AM (17 years ago)

Author:

bills

Message:

Rework the diff stage to process the skycells from an exposure in a single
diffRun

File:

• trunk/ippTools/share/magicdstool_getrunids.sql (modified) (1 diff)

trunk/ippTools/share/magicdstool_getrunids.sql

@@ -8 +8 @@
 FROM magicRun 
 JOIN magicInputSkyfile USING(magic_id)
-JOIN diffInputSkyfile USING(diff_id)
-JOIN warpRun USING(warp_id)
+JOIN diffSkyfile 
+    ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
+    AND magicInputSkyfile.node = diffSkyfile.skycell_id
+JOIN diffInputSkyfile
+    ON diffInputSkyfile.diff_id = diffSkyfile.diff_id
+    AND diffInputSkyfile.skycell_id = diffSkyfile.skycell_id
+JOIN warpRun
+    ON diffInputSkyfile.warp1 = warp_id
 JOIN fakeRun USING(fake_id)
 JOIN camRun USING(cam_id)
 JOIN chipRun USING(chip_id)
-WHERE template  = 0
-AND magic_id = %ld
+WHERE magic_id = %ld