Changeset 20973 for trunk/ippTools/share/magicdstool_completed_runs.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_completed_runs.sql (modified) (1 diff)

trunk/ippTools/share/magicdstool_completed_runs.sql

@@ -65 +65 @@
     JOIN magicRun USING (magic_id)
     JOIN magicInputSkyfile USING(magic_id)
-    -- Do we really need to join back to diffInputSkyfile here?
-    JOIN diffRun USING(diff_id)
-    JOIN diffSkyfile USING(diff_id)
-    JOIN diffInputSkyfile USING(diff_id)
+    JOIN diffSkyfile
+        ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
+        AND magicInputSkyfile.node = diffSkyfile.skycell_id
     LEFT JOIN magicDSFile
         ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
-        AND magicDSFile.component = diffInputSkyfile.skycell_id
+        AND magicDSFile.component = diffSkyfile.skycell_id
     WHERE
         magicDSRun.state = 'run'
         AND magicDSRun.stage = 'diff'
-        AND diffRun.state = 'full'
         AND diffSkyfile.fault = 0
     GROUP BY