Changeset 40974 for branches/ccl_branches/ipp-20190806/ippMonitor/def/subsetPlotDiffImage.d

Timestamp:

Oct 27, 2019, 9:47:12 PM (7 years ago)

Author:

cclin33

Message:

sync from trunk with r40973

Location:

branches/ccl_branches/ipp-20190806/ippMonitor

Files:

• . (modified) (1 prop)
• def/subsetPlotDiffImage.d (modified) (2 diffs)

branches/ccl_branches/ipp-20190806/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