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

Timestamp:

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

Author:

tdeboer

Message:

updated ippMonitor queries

File:

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

trunk/ippMonitor/def/simplePlotStackImage.d

@@ -1 @@
-TABLE stackRun, stackSumSkyfile, skycell 
+TABLE stackRun JOIN stackSumSkyfile USING (stack_id) JOIN skycell USING (skycell_id) 
 TITLE New sky plot - stack
 FILE  simplePlotStackImage.php
@@ -5 +5 @@
 
 WHERE stackRun.state != 'new' 
-WHERE stackRun.stack_id = stackSumSkyfile.stack_id
-WHERE stackRun.skycell_id = skycell.skycell_id
 WHERE stackRun.tess_id = skycell.tess_id