IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Sep 3, 2019, 4:04:13 PM (7 years ago)
Author:
tdeboer
Message:

updated ippMonitor queries

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippMonitor/def/histogramChipProcessedImfileFwhmMajorImage.d

    r28601 r40882  
    1 TABLE camRun, chipRun, rawExp, camProcessedExp, chipProcessedImfile
     1TABLE camRun JOIN chipRun USING (chip_id) JOIN rawExp USING (exp_id) JOIN camProcessedExp USING (cam_id) JOIN chipProcessedImfile USING (chip_id)
    22TITLE Histogram fwhm major (chipProcessedImfile)
    33FILE  histogramChipProcessedImfileFwhmMajorImage.php
    … …  
    55
    66WHERE camRun.state = 'full'
    7 WHERE chipProcessedImfile.exp_id = rawExp.exp_id
    8 WHERE chipRun.exp_id = rawExp.exp_id
    9 WHERE camRun.chip_id = chipRun.chip_id
    10 WHERE camProcessedExp.cam_id = camRun.cam_id
    117WHERE camProcessedExp.fault = 0
    128
Note: See TracChangeset for help on using the changeset viewer.