TABLE magicRun, magicTree, magicNodeResult
TITLE Magic Failed Nodes
FILE  magicFailedNodes.php
MENU  ipp.stack.dat

WHERE magicRun.magic_id        = magicTree.magic_id
WHERE magicTree.magic_id       = magicNodeResult.magic_id
WHERE magicTree.node           = magicNodeResult.node
WHERE magicNodeResult.fault   != 0

#        field                   size  format  name           show     link to         extras
FIELD    magicRun.magic_id,	 5,   %d,     Magic ID
FIELD    magicRun.exp_id,	 5,   %d,     Exp ID
FIELD    magicRun.diff_id,	 5,   %d,     Diff ID
FIELD    magicRun.label, 	 5,   %s,     Label
FIELD    magicRun.data_group, 	 5,   %s,     data grp
FIELD    magicRun.inverse,	 5,   %d,     Inverse
FIELD    magicRun.state,	 5,   %s,     State
FIELD    magicTree.node,	 5,   %s,     Node
FIELD    magicTree.dep,	 	 5,   %s,     Parent
FIELD    magicNodeResult.fault,	 5,   %d,     Fault
