Changeset 24151

Timestamp:

May 12, 2009, 5:49:06 PM (17 years ago)

Author:

Paul Price

Message:

diff_id is in magicRun rather than magicInputSkyfile.

File:

• branches/pap_magic/ippTools/share/magictool_inputskyfile.sql (modified) (1 diff)

branches/pap_magic/ippTools/share/magictool_inputskyfile.sql

@@ -6 +6 @@
 JOIN magicInputSkyfile USING(magic_id)
 JOIN diffSkyfile
-    ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
-    AND magicInputSkyfile.node = diffSkyfile.skycell_id
+    ON diffSkyfile.diff_id = magicRun.diff_id
+    AND diffSkyfile.skycell_id = magicInputSkyfile.node
 WHERE
     magicRun.state = 'new'