# this file is based on the detRunSummary.d file: it uses the same tables restricted to the 
# master detrend runs which have been accepted

TABLE detStackedImfile
TITLE Master Detrend Imfiles
FILE  masterDetrendImfiles.php
MENU  ipp.detrend.dat

#     field      width name          show         link to            extras
FIELD det_id,    7,    det_id
FIELD iteration, 5,    iter
FIELD uri,       5,    uri

# this file illustrates a simple inner join to generate the output table
# assuming no other dynamic restrictions are added, this generates the following query:
# SELECT detRunSummary.det_id,detRunSummary.iteration,detRunSummary.iteration,detRun.det_type,detRunSummary.bg,detRunSummary.bg_stdev \
# FROM detRunSummary, detRun \
# WHERE detRunSummary.accept = 1 AND detRun.position = detRunSummary.det_id AND detRun.iteration = detRunSummary.iteration \
# LIMIT 20
