Index: trunk/ippMonitor/def/mopsStatus.d
===================================================================
--- trunk/ippMonitor/def/mopsStatus.d	(revision 29405)
+++ trunk/ippMonitor/def/mopsStatus.d	(revision 29405)
@@ -0,0 +1,39 @@
+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 
+#LEFT JOIN publishRun ON publishRun.stage_id=diffInput.diff_id diffInputRun.diff_id 
+TITLE MOPS Status
+FILE mopsStatus.php
+MENU ipp.imfiles.dat
+
+WHERE object != 'ENGINEERING'
+WHERE chipRun.data_group like 'OSS.%'
+
+UNRESTRICTED AND dateobs >= CURDATE()
+
+# OP  OP1   ($ddiff_id > 0 ? $ddiff_id : $tdiff_id)
+OP  OP1   $ddiffId.":".$tdiffId
+OP  OP2   "[".$diffInput.diff_id."]:[".$tdiff_id."]"
+
+#     field                    width format  name          show         link to                   extras
+FIELD dateobs, 		       15,   %T,     Date Obs
+FIELD exp_name, 	       5,    %s,     Exp Name
+FIELD rawExp.exp_id, 	       5,    %d,     Exp ID
+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 fake_id, 		       5,    %d,     Fake ID (Stage 3)
+FIELD warp_id, 		       5,    %d,     Warp ID (Stage 4)
+FIELD diffInput.diff_id AS ddiff_id,       5,    %d,     ddiff_id
+FIELD diffTemplate.diff_id AS tdiff_id,    5,    %d,     tdiff_id
+# FIELD *,		       5,    %s,     Diff ID (Stage 5),		op=OP1
+# FIELD *,		       5,    %s,     Diff ID (Stage 5),		op=OP2
+FIELD camRun.magicked, 	       5,    %d,     Cam Magicked (Stage 6)
+FIELD publishRun.pub_id,       5,    %d,     Pub ID (Stage 7)
+FIELD filter, 		       5,    %s,     Filter
+FIELD object, 		       15,    %s,     Object
+FIELD comment, 		       40,    %s,     Comment
+
+FIELD diffInput.diff_id AS ddiffId,       5,    %s,     ddiffId,	none
+FIELD diffTemplate.diff_id AS tdiffId,    5,    %s,     tdiffId, 	none
+
+MODE  summary
+GROUP exp_name