TABLE minidvodbRun, minidvodbProcessed 
TITLE Processed minidvodbs
FILE  minidvodbProcessed.php
MENU  ipp.dvodb.dat

# the following WHERE clauses are added to all queries joined by AND

WHERE minidvodbRun.minidvodb_id = minidvodbProcessed.minidvodb_id

#     field                   size  format  name         show    link to                  extras
FIELD distinct(minidvodbRun.minidvodb_id),        5, %d,     Minidvodb ID

FIELD minidvodbRun.minidvodb_name,          5, %s,     minidvodb_name
FIELD minidvodbRun.minidvodb_group,       5, %s,     minidvodb_group
FIELD minidvodbProcessed.merge_order,        5, %d,     Merge Order
FIELD minidvodbProcessed.dtime_resort,        5, %d,     resort time
FIELD minidvodbProcessed.dtime_relphot,        5, %d,     relphot time
FIELD minidvodbProcessed.dtime_merge,        5, %d,     dvomerge time
FIELD minidvodbProcessed.mergedvodb_path,          25, %s,     mergedvodb_path
FIELD state,          5, %s,    State
FIELD minidvodbProcessed.fault,        5, %d,     Fault
FIELD epoch,        5, %T,     epoch

