TABLE rawExp LEFT JOIN chipRun using(exp_id) LEFT JOIN camRun using(chip_id) LEFT JOIN fakeRun using(cam_id) LEFT JOIN warpRun using(fake_id) LEFT JOIN diffInputSkyfile AS diffInput ON diffInput.warp1 = warp_id LEFT JOIN diffRun AS diffInputRun ON diffInput.diff_id = diffInputRun.diff_id LEFT JOIN diffInputSkyfile AS diffTemplate ON diffTemplate.warp2 = warp_id LEFT JOIN diffRun AS diffTemplateRun ON diffTemplate.diff_id = diffTemplateRun.diff_id LEFT JOIN distRun ON stage = 'camera' AND distRun.stage_id = cam_id 
TITLE Exposures Status
FILE exposureStatus.php
MENU ipp.czar.dat

WHERE object != 'ENGINEERING'

UNRESTRICTED AND dateobs >= CURDATE()

#     field                    width format  name          show         link to                   extras
FIELD DISTINCT rawExp.exp_id, 1,    %s,    'Dont use for filtering'
FIELD dateobs, 15,    %T,     Date obs
FIELD rawExp.exp_id, 5, %d,      Exp ID
FIELD exp_name, 5,    %s,     Exp Name
FIELD chipRun.data_group, 5,   %s,     Data grp
FIELD chip_id, 5,    %d,     Chip ID
FIELD chipRun.state, 5,    %s,     Chip State
FIELD cam_id, 5,    %d,     Cam ID
FIELD camRun.state, 5,    %s,     Cam ID
FIELD camRun.magicked, 5,    %s,     Cam Magicked
#FIELD publishRun.pub_id, 5,    %d,     Pub ID
FIELD distRun.dist_id, 5,    %d,     Dist ID
FIELD fake_id, 5,    %d,     Fake ID
FIELD warp_id, 5,    %d,     Warp ID
FIELD warpRun.state, 5,    %s,     Warp State
FIELD diffInput.diff_id, 5,    %d,     Diff ID
FIELD diffInputRun.state, 5,    %s,     Diff State
FIELD diffTemplate.diff_id, 5,    %d,     Diff Templ ID
FIELD diffTemplateRun.state, 5,    %s,     Diff Templ State
FIELD filter, 5,    %s,     Filter
FIELD object, 25,    %s,     Object
FIELD comment, 50,    %s,     Comment
