Changeset 40974 for branches/ccl_branches/ipp-20190806/ippMonitor/def/maskStats.d

Timestamp:

Oct 27, 2019, 9:47:12 PM (7 years ago)

Author:

cclin33

Message:

sync from trunk with r40973

Location:

branches/ccl_branches/ipp-20190806/ippMonitor

Files:

• . (modified) (1 prop)
• def/maskStats.d (modified) (1 diff)

branches/ccl_branches/ipp-20190806/ippMonitor/def/maskStats.d

@@ -1 @@
-TABLE rawExp, chipRun, camRun, fakeRun, warpRun
+TABLE rawExp JOIN chipRun USING (exp_id) JOIN camRun USING (chip_id) JOIN fakeRun USING (cam_id) JOIN warpRun USING (fake_id)
 TITLE Mask Stats
 FILE  maskStats.php
 MENU  ipp.czar.dat
 
-WHERE rawExp.exp_id = chipRun.exp_id
-WHERE chipRun.chip_id = camRun.chip_id
-WHERE camRun.cam_id = fakeRun.cam_id
-WHERE fakeRun.fake_id = warpRun.fake_id
+RESTRICT_COUNT WHERE rawExp.dateobs >= CURDATE()
+UNRESTRICTED WHERE rawExp.dateobs >= CURDATE()
 
 OP   OP1  $ra * 57.295783