Index: /branches/pap_magic/ippTools/share/magictool_toprocess_inputs.sql
===================================================================
--- /branches/pap_magic/ippTools/share/magictool_toprocess_inputs.sql	(revision 24155)
+++ /branches/pap_magic/ippTools/share/magictool_toprocess_inputs.sql	(revision 24156)
@@ -11,7 +11,5 @@
 JOIN magicRun USING(magic_id)
 JOIN rawExp USING(exp_id)
-LEFT JOIN magicNodeResult
-    ON magicTree.magic_id = magicNodeResult.magic_id
-    AND magicTree.node = magicNodeResult.node
+LEFT JOIN magicNodeResult USING(magic_id, node)
 WHERE
     magicRun.state = 'new'
Index: /branches/pap_magic/ippTools/share/magictool_toprocess_tree.sql
===================================================================
--- /branches/pap_magic/ippTools/share/magictool_toprocess_tree.sql	(revision 24155)
+++ /branches/pap_magic/ippTools/share/magictool_toprocess_tree.sql	(revision 24156)
@@ -7,11 +7,9 @@
     -- note that the type stays a 64 bit int
     magicNodeResult.magic_id IS TRUE AS done,
-    magicNodeResult.fault IS TRUE AS bad,
+    magicNodeResult.fault IS TRUE AS bad
 FROM magicTree
 JOIN magicRun USING(magic_id)
 JOIN rawExp USING(exp_id)
-LEFT JOIN magicNodeResult
-    ON magicTree.magic_id = magicNodeResult.magic_id
-    AND magicTree.node = magicNodeResult.node
+LEFT JOIN magicNodeResult USING(magic_id, node)
 WHERE
     magicRun.state = 'new'
Index: /branches/pap_magic/ippTools/src/magictool.c
===================================================================
--- /branches/pap_magic/ippTools/src/magictool.c	(revision 24155)
+++ /branches/pap_magic/ippTools/src/magictool.c	(revision 24156)
@@ -798,5 +798,5 @@
 
     psMetadata *where = psMetadataAlloc();
-    PXOPT_COPY_S64(config->args, where, "-magic_id", "magic_id", "==");
+    PXOPT_COPY_S64(config->args, where, "-magic_id", "magicRun.magic_id", "==");
     pxAddLabelSearchArgs (config, where, "-label", "magicRun.label", "==");
 
@@ -854,5 +854,5 @@
     if (limit) {
         if (psArrayLength(output) >= limit) {
-            // we've found enough (not that limit was applied to the query so '> limit' won't happen)
+            // we've found enough (note that limit was applied to the query so '> limit' won't happen)
             // negative simple so the default is true
             if (!ippdbPrintMetadatas(stdout, output, "magicMe", !simple)) {