Changes between Version 40 and Version 41 of PS1_IPP_Czarlog_20190510

Timestamp:

May 17, 2019, 10:37:12 AM (7 years ago)

Author:

tdeboer

Comment:

--

PS1_IPP_Czarlog_20190510

@@ -1387 +1387 @@
 mysql -hscidbm -uX -pX gpc1 -B -e 'SELECT chip_id,data_group,label FROM chipRun WHERE state like "update" and label like "update.LAP.PV3";'
 }}}
-Get more info:
+ Get more info:
 {{{
 mysql -hippdb08 -uX -pX gpc1 -e "SELECT count(*) as cnt,chipRun.chip_id,chipRun.state as chip_state,chipRun.data_group as chip_datgrp,chipRun.label as chip_label,camRun.data_group as cam_datgrp,warpRun.warp_id,warpRun.state as wrp_state,warpRun.label as wrp_label,warpRun.data_group as wrp_datgrp,chipProcessedImfile.data_state as chip_datstate,warpSkyfile.data_state as wrp_datstate FROM warpRun join warpSkyfile using (warp_id) JOIN fakeRun using (fake_id) JOIN camRun using (cam_id) JOIN chipRun  using (chip_id) JOIN chipProcessedImfile using (chip_id) WHERE chipRun.label like 'update.LAP.PV3' AND chipRun.state = 'update' group by chipRun.chip_id,chipRun.state,warpRun.state,chipProcessedImfile.data_state,warpSkyfile.data_state" > LAP.PV3_datastate_new