Index: trunk/ippMonitor/def/simplePlotFullForceImage.d
===================================================================
--- trunk/ippMonitor/def/simplePlotFullForceImage.d	(revision 38220)
+++ trunk/ippMonitor/def/simplePlotFullForceImage.d	(revision 40882)
@@ -1,4 +1,4 @@
 # 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,8 +6,5 @@
 
 # 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'