Changes between Version 2 and Version 3 of PS1_IPP_Czarlog_20171002

Timestamp:

Oct 5, 2017, 4:40:20 PM (9 years ago)

Author:

watersc1

Comment:

--

PS1_IPP_Czarlog_20171002

@@ -16 +16 @@
 mysql -hscidbm -uippuser -p gpc1 -B -e " select expall.exp_name,expall.comment,expall.dateobs from ( select exp_name,comment,dateobs from rawExp where dateobs like '`date -u  "+%Y-%m-%d"`%' and obs_mode like '%SS%') expall left join ( select exp_name from diffRun join diffInputSkyfile using (diff_id) join publishRun join warpRun join fakeRun using (fake_id) join camRun using (cam_id) join camProcessedExp using (cam_id) join chipRun using (chip_id) join rawExp using (exp_id) where ( warp1=warp_id or warp2=warp_id ) and diffRun.reduction like 'SWEETSPOT' and stack2 is NULL and diffRun.data_group like '%SS.`date -u "+%Y%m%d"`' and diffRun.diff_id=stage_id group by exp_name ) exppub on expall.exp_name=exppub.exp_name where exppub.exp_name is NULL ; "
 }}}
+ * 16:40 CZW: Setting ippb15 to up in nebulous to test shuffle script.  I plan to put it back to repair before leaving today.
 === Friday : YYYY.MM.DD ===