TABLE fullForceInput JOIN warpRun USING (warp_id) JOIN fullForceRun USING (ff_id) JOIN fullForceResult USING (ff_id)
TITLE Full Force Failed 
FILE  failedFullforce.php
MENU  ipp.ffs.dat

ARGS  ARG1 fullForceRun.ff_id=$fullForceRun.ff_id
ARGS  ARG1 basename=$fullForceResult.path_base

WHERE fullForceResult.fault != 0
#        field                       size     format             name           show     link to         extras
FIELD   fullForceRun.ff_id,             5,        %d,           FF ID
FIELD   fullForceRun.label,             7,        %s,           Label
FIELD   fullForceRun.state,             7,        %s,           State,     value,  failedFullforce.php, ARG1
FIELD   warpRun.tess_id,                5,        %s,           Tess ID
FIELD   warpRun.label AS warpRunLabel,  5,        %s,           warp Label
FIELD   fullForceRun.data_group,        7,        %s,           data grp
FIELD   fullForceRun.dist_group,        7,        %s,           dist grp
FIELD   fullForceResult.fault,          7,        %d,           fault
FIELD   fullForceResult.quality,        7,        %d,           quality
FIELD   fullForceResult.path_base,      7,        %s,           path_base, none

MODE summary
GROUP fullForceRun.ff_id

TAIL PHP insert_log ('LOG.EXP');

