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

Timestamp:

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

Author:

tdeboer

Message:

updated ippMonitor queries

File:

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

trunk/ippMonitor/def/simplePlotDiffImage.d

@@ -1 @@
-TABLE diffRun, diffSkyfile, skycell 
+TABLE diffRun JOIN diffSkyfile USING (diff_id) JOIN skycell USING (skycell_id) 
 TITLE New sky plot - diff
 FILE  simplePlotDiffImage.php
@@ -5 +5 @@
 
 WHERE diffRun.state != 'new' 
-WHERE diffRun.diff_id = diffSkyfile.diff_id
-WHERE diffSkyfile.skycell_id = skycell.skycell_id
 WHERE diffRun.tess_id = skycell.tess_id