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

Timestamp:

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

Author:

tdeboer

Message:

updated ippMonitor queries

File:

• trunk/ippMonitor/def/simplePlotFullForceImage.d (modified) (2 diffs)

trunk/ippMonitor/def/simplePlotFullForceImage.d

@@ -1 +1 @@
 # TABLE fullForceRun, fullForceResult, skycalRun, stackRun, skycell 
-TABLE fullForceRun, skycalRun, stackRun, skycell 
+TABLE fullForceRun JOIN skycalRun USING (skycal_id) JOIN stackRun USING (stack_id) JOIN skycell USING (skycell_id) 
 TITLE New sky plot - fullForce
 FILE  simplePlotFullForceImage.php
@@ -6 +6 @@
 
 # WHERE fullForceResult.ff_id  = fullForceRun.ff_id
-WHERE fullForceRun.skycal_id = skycalRun.skycal_id
-WHERE skycalRun.stack_id     = stackRun.stack_id
 WHERE stackRun.tess_id       = skycell.tess_id
-WHERE stackRun.skycell_id    = skycell.skycell_id
 WHERE fullForceRun.state != 'new'