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

Timestamp:

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

Author:

tdeboer

Message:

updated ippMonitor queries

File:

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

trunk/ippMonitor/def/subsetPlotDiffImage.d

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