Changeset 30366

Timestamp:

Jan 25, 2011, 2:35:54 PM (15 years ago)

Author:

Serge CHASTEL

Message:

Fixing DS in mops status

File:

• trunk/ippMonitor/def/mopsStatus.d (modified) (1 diff)

trunk/ippMonitor/def/mopsStatus.d

@@ -1 @@
-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 (diffInput.diff_id IS NOT NULL AND stage_id=diffInput.diff_id) OR (diffTemplateRun.diff_id IS NOT NULL AND stage_id=diffTemplateRun.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(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 ((diffInput.diff_id IS NOT NULL AND stage_id=diffInput.diff_id) OR (diffTemplateRun.diff_id IS NOT NULL AND stage_id=diffTemplateRun.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