Changes between Version 25 and Version 26 of PS1_IPP_Czarlog_20190510

Timestamp:

May 14, 2019, 5:25:29 PM (7 years ago)

Author:

tdeboer

Comment:

--

PS1_IPP_Czarlog_20190510

@@ -830 +830 @@
 }}}
 
-We can find their chip_id and warp_id, using:
+ We can find their chip_id and warp_id, using:
 {{{
 mysql -hscidbm -uippuser -pippuser gpc1 -B -e ' SELECT rawExp.exp_name,rawExp.exp_id,chipRun.chip_id,chipRun.state,chipRun.label,warpRun.warp_id,warpRun.state,warpRun.label,warpRun.data_group FROM  warpSkyfile, warpRun, fakeRun, camRun, chipRun, rawExp WHERE  warpSkyfile.warp_id = warpRun.warp_id AND warpRun.fake_id = fakeRun.fake_id AND fakeRun.cam_id = camRun.cam_id AND camRun.chip_id = chipRun.chip_id AND chipRun.exp_id = rawExp.exp_id AND  chipRun.chip_id in (1131144,1131146,1131208,1131210,1130544,1130549,1130551,1130546,1130556,1130560,1131230,1200205,1131246,1131251,1130562,1130564,1130568,1130570,1131257,1131260,1200216,1130573,1131276,1131280,1130575,1130578,1131297,1131303,1131318,1131321,1130587,1130590,1131340,1130596,1130598,1130600,1583717,1583733,1756192,1756719,1795556,1795572,1795588,1795603,1813787,1813804,1813821,1813838,1936305,1936310,1936321,1936326,1936337,1936342,1936353,1936358,2055192,2055202,2055212,2055222,2088153,2088169,2088185,2088201) group by chip_id;'