# MySQLCC - [g0admin@wmg0] Query Window
# Connection: g0admin@wmg0
# Host: wmg0
# Saved: 2003-06-26 13:23:17
# 
# Query:
# SELECT DISTINCT
# r.run_number AS run,
# 
# 
# pol.slow_helicity_plate AS IHWP,
# b1.value AS a_q,
# b1.error AS e_aq,
# b2.value AS d_x,
# b2.error AS e_dx,
# b3.value AS d_y,
# b3.error AS e_dy,
# b4.value AS q,
# b4.error AS e_q
# 
# 
# 
# 
# FROM
# good_for_prod AS r,
# analysis AS a1,
# analysis AS a2,
# measurement AS m1,
# measurement AS m2,
# detectors AS d,
# particles AS p,
# polarized_source AS pol,
# beam AS b1, monitors AS mo1,
# beam AS b2, monitors AS mo2,
# beam AS b3, monitors AS mo3,
# beam AS b4, monitors AS mo4
# WHERE
# r.run_id = a1.run_id AND 
# a1.run_id = a2.run_id AND
# a1.analysis_id = m1.analysis_id AND
# a2.analysis_id = m2.analysis_id AND
# d.detector_id = m1.detector_id AND
# m2.detector_id = m1.detector_id AND 
# p.timebin_id = m1.timebin_id AND
# m2.timebin_id = m1.timebin_id AND
# pol.run_id = r.run_id AND
# b1.analysis_id = m1.analysis_id AND
# b2.analysis_id = b1.analysis_id AND
# b3.analysis_id = b2.analysis_id AND
# b4.analysis_id = b3.analysis_id AND
# b1.monitor_id = mo1.monitor_id AND
# b2.monitor_id = mo2.monitor_id AND
# b3.monitor_id = mo3.monitor_id AND
# b4.monitor_id = mo4.monitor_id AND
# mo1.quantity = 'q_targ' AND
# b1.measurement_type_id = 'aq' AND
# mo2.quantity = 'x_targ' AND
# b2.measurement_type_id = 'dp' AND
# mo3.quantity = 'y_targ' AND
# b3.measurement_type_id = 'dp' AND
# mo4.quantity = 'q_targ' AND 
# b4.measurement_type_id = 'yq' AND
# ABS(b1.value) < '10' AND
# ABS(b2.value) < 0.050 AND
# ABS(b3.value) < 0.050 AND
# b4.value >= 1166.67 AND
# d.detector < 15 AND
# 
# 
# p.name = 'background' AND
# a1.flags = 'r_slopes' AND
# a2.flags = 'c_slopes' AND
# m1.measurement_type_id = 'a' AND
# m2.measurement_type_id = 'a' AND
# 
# pol.slow_helicity_plate IS NOT NULL
# 
# 
# ORDER BY run_number
# 
'run','IHWP','a_q','e_aq','d_x','e_dx','d_y','e_dy','q','e_q'
'15747','in','5.88046','6.05328','-0.0331586','0.0396926','-0.0247505','0.0282803','1362.09','0.0847146'
'15801','out','7.81669','4.17692','0.0135991','0.0381929','0.0215071','0.0308201','1365.95','0.023302'
'15802','out','5.69484','13.3753','-0.0305069','0.02031','-0.0170152','0.0175776','1365.21','0.103496'
'15809','out','-4.78505','8.46285','-0.0282526','0.0271664','0.0079047','0.0176125','1358.88','0.1289'
'15811','out','-0.592856','2.48012','0.00191459','0.0231224','-0.00871227','0.0185012','1365.43','0.127062'
'15812','out','0.701386','2.71063','-0.0400108','0.0221331','0.0125133','0.0192398','1361.97','0.0815704'
'15827','out','-1.15121','2.83115','0.00833636','0.0227643','0.0305165','0.0208451','1362.22','0.0898753'
'15836','out','2.01793','7.66295','-0.00813486','0.0186404','-0.0259287','0.0165652','1361.04','0.111627'
'15837','out','-0.85089','3.82212','-0.00885697','0.029147','-0.025624','0.0261299','1366.2','0.110342'
'15930','in','-9.84191','2.18387','0.0498002','0.0207972','-0.0092227','0.0168027','1330.09','0.0296135'
'15941','in','-4.34543','5.87226','-0.0130388','0.0389743','0.0314601','0.0415703','1303.29','1.57974'
'16005','in','1.79441','8.10845','0.0155602','0.0213901','-0.0112685','0.0179922','1330.34','0.0641716'
'16006','in','-0.326679','5.01986','0.0139947','0.0264642','-0.0419684','0.0222516','1329.24','0.103784'
'16071','out','2.8072','7.76593','-0.00506049','0.0388562','-0.0231958','0.0320997','1227.31','0.0464856'
'16073','out','0.427996','3.25289','-0.0460156','0.0163196','0.00152024','0.01469','1188.25','0.208401'
'16074','out','-1.01535','3.43157','-0.0268957','0.0179384','-0.012163','0.0164961','1186.34','0.247115'
'16079','out','0.234597','3.35062','-0.0394462','0.0181819','-0.00223605','0.0168067','1191.53','0.169657'
'16093','in','-7.6924','4.06236','0.00558234','0.0194544','0.0178474','0.0195887','1197.42','0.152181'
'16094','in','1.92778','3.72696','0.00902563','0.0234104','-0.00968533','0.0233322','1199.47','0.183007'
'16096','in','-3.9304','7.81021','0.028899','0.0206595','-0.0213107','0.0207636','1194.1','0.200327'
'16099','in','4.61203','5.41571','0.0463072','0.0196741','-0.0332526','0.0183475','1230.48','0.215786'
'16100','in','-1.42306','7.96986','-0.0117371','0.023508','-0.00788308','0.0197832','1278.86','0.58357'
'16106','in','7.62022','8.36715','0.00449781','0.0194173','-0.0290709','0.0178272','1196.54','0.157514'
'16107','in','1.70821','5.392','0.0148863','0.0189668','-0.0143728','0.0180812','1197.69','0.107291'
'16110','in','-2.38973','8.63374','0.0108806','0.0170628','-0.0209877','0.016562','1191.51','0.172528'
'16111','in','-9.6786','6.91597','0.0375261','0.0467372','0.00726204','0.0428333','1204.42','0.0374399'
'16115','in','-3.40219','3.99623','0.0322076','0.0185278','-0.00865154','0.0178657','1195.44','0.176332'
'16120','in','6.21072','5.16212','0.0383607','0.0203308','0.00221316','0.0202582','1188.29','0.258798'
'16125','in','6.56857','14.8881','0.0286405','0.0216905','0.00813947','0.0196676','1196.14','0.148982'
'16126','in','-0.657371','4.96817','0.0250998','0.0210475','0.0106829','0.0232975','1192.22','0.187453'
'16127','in','-3.52356','4.14983','-0.0229933','0.0197239','-0.000927678','0.0190985','1198.43','0.130358'
'16135','in','2.03542','13.0109','0.0194058','0.0204858','0.0227879','0.0187187','1194.27','0.191909'
'16136','in','6.7654','17.29','0.0419492','0.0218146','-0.0253884','0.0195564','1187.52','0.245765'