Changeset 40882 for trunk/ippMonitor/def/maskStats.d

Timestamp:

Sep 3, 2019, 4:04:13 PM (7 years ago)

Author:

tdeboer

Message:

updated ippMonitor queries

File:

• trunk/ippMonitor/def/maskStats.d (modified) (1 diff)

trunk/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