Index: trunk/ippMonitor/def/mopsStatus.d
===================================================================
--- trunk/ippMonitor/def/mopsStatus.d	(revision 30360)
+++ trunk/ippMonitor/def/mopsStatus.d	(revision 30361)
@@ -1,3 +1,3 @@
-TABLE rawExp LEFT JOIN chipRun using(exp_id) LEFT JOIN camRun using(chip_id) LEFT JOIN fakeRun using(cam_id) LEFT JOIN warpRun using(fake_id) LEFT JOIN diffInputSkyfile AS diffInput ON diffInput.warp1 = warp_id LEFT JOIN diffRun AS diffInputRun ON diffInput.diff_id = diffInputRun.diff_id LEFT JOIN diffInputSkyfile AS diffTemplate ON diffTemplate.warp2 = warp_id LEFT JOIN diffRun AS diffTemplateRun ON diffTemplate.diff_id = diffTemplateRun.diff_id LEFT JOIN publishRun ON stage_id=diffInput.diff_id AND (client_id=1 OR client_id=5) LEFT JOIN magicDSRun ON magicDSRun.magic_ds_id=camRun.magicked
+TABLE rawExp LEFT JOIN chipRun using(exp_id) LEFT JOIN camRun using(chip_id) LEFT JOIN fakeRun using(camRun.cam_id) LEFT JOIN warpRun using(fake_id) LEFT JOIN diffInputSkyfile AS diffInput ON diffInput.warp1 = warp_id LEFT JOIN diffRun AS diffInputRun ON diffInput.diff_id = diffInputRun.diff_id LEFT JOIN diffInputSkyfile AS diffTemplate ON diffTemplate.warp2 = warp_id LEFT JOIN diffRun AS diffTemplateRun ON diffTemplate.diff_id = diffTemplateRun.diff_id LEFT JOIN publishRun ON stage_id=diffInput.diff_id AND (client_id=1 OR client_id=5) LEFT JOIN magicDSRun ON magicDSRun.magic_ds_id=camRun.magicked
 TITLE MOPS Status
 FILE mopsStatus.php
@@ -19,5 +19,5 @@
 FIELD chipRun.data_group,      5,    %s,     Data grp
 FIELD chip_id, 		       5,    %d,     Chip ID (Stage 1)
-FIELD cam_id, 		       5,    %d,     Cam ID (Stage 2)
+FIELD camRun.cam_id, 		       5,    %d,     Cam ID (Stage 2)
 FIELD fake_id, 		       5,    %d,     Fake ID (Stage 3)
 FIELD warp_id, 		       5,    %d,     Warp ID (Stage 4)