TABLE minidvodbRun LEFT JOIN minidvodbProcessed using(minidvodb_id) LEFT JOIN mergedvodbRun using(minidvodb_id) LEFT JOIN mergedvodbProcessed using(merge_id)
TITLE dvodb Status
FILE dvodbStatus.php
MENU ipp.dvodb.dat


#WHERE (minidvodbProcessed.fault > 0 or mergedvodbProcessed.fault > 0)

#UNRESTRICTED WHERE minidvodbRun.creation_date >= DATE_ADD(DATE (NOW()), INTERVAL -30 DAY) 

#     field                    width format  name          show         link to                   extras
FIELD minidvodbRun.minidvodb_id, 5,   %d,     minidvodb_id
FIELD minidvodbRun.minidvodb_name, 	       5,    %s,     minidvodb_name
FIELD minidvodbRun.state, 	       5,    %s,     minidvodb_state
FIELD minidvodbProcessed.fault,      5,    %d,	     minidvodb fault
FIELD mergedvodbRun.merge_id, 5,   %d,     merge_id
FIELD mergedvodbRun.mergedvodb, 	       5,    %s,     mergedvodb
FIELD mergedvodbRun.state, 	       5,    %s,     mergedvodb_state
FIELD mergedvodbProcessed.fault,      5,    %d,	     mergedvodb fault



#MODE summary
#GROUP BY minidvodbRun.minidvodb_id
#GROUP rawExp.exp_id
