Changeset 15336 for trunk/ippTools/share/magictool_toprocess_inputs.sql

Timestamp:

Oct 19, 2007, 2:35:17 PM (19 years ago)

Author:

jhoblitt

Message:

cleanups

File:

• trunk/ippTools/share/magictool_toprocess_inputs.sql (modified) (2 diffs)

trunk/ippTools/share/magictool_toprocess_inputs.sql

@@ -10 +10 @@
 JOIN magicInputSkyfile
     USING(magic_id, node)
-LEFT JOIN diffSkyfile
+JOIN diffSkyfile
     using(diff_id)
 LEFT JOIN magicNodeResult
@@ -17 +17 @@
 WHERE
     magicRun.state = 'run'
+    AND magicNodeResult.magic_id IS NULL
+    AND magicNodeResult.node IS NULL