Changeset 20964 for branches/bills_081204/ippTools/share/magicdstool_getrunids.sql

Timestamp:

Dec 11, 2008, 5:22:00 PM (17 years ago)

Author:

bills

Message:

changes to adapt the magic to the re-worked difference stage

File:

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

branches/bills_081204/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