# MySQLCC - [g0admin@wmg0] Query Window
# Connection: g0admin@wmg0
# Host: wmg0
# Saved: 2003-06-25 11:32:45
# 
# Query:
# SELECT 
# d.make AS make,
# d.detector as det,
# pol.slow_helicity_plate AS IHWP,
# SUM(m1.value/m1.error/m1.error)/SUM(1/m1.error/m1.error) AS asym, 
# SQRT(1/SUM(1/m1.error/m1.error)) AS asym_err,
# SUM(m2.value/m2.error/m2.error)/SUM(1/m2.error/m2.error) AS asymcorr,
# SQRT(1/SUM(1/m2.error/m2.error)) AS asymcorr_err
# 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 = 'proton' 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
# GROUP BY make, 
# detector, 
# slow_helicity_plate
# 
'make','det','IHWP','asym','asym_err','asymcorr','asymcorr_err'
'fr','1','in','5.5858694829639','2.851665','5.9553100107358','2.861251'
'fr','1','out','-2.5152516243445','3.663815','-2.2367967627446','3.664477'
'fr','2','in','4.1034340759071','2.582823','4.5341275481901','2.591802'
'fr','2','out','-3.6924954022524','3.321544','-3.422340144432','3.322207'
'fr','3','in','2.149117233696','2.581464','2.2539261895633','2.590209'
'fr','3','out','-6.8290222008198','3.323476','-6.5451994690683','3.323836'
'fr','4','in','9.6837797824247','2.749079','9.9919828756442','2.758434'
'fr','4','out','-3.7851041178869','3.527855','-3.4622489567909','3.528484'
'fr','5','in','0.29997979301097','2.677778','0.58744129901558','2.686926'
'fr','5','out','-3.9366711510524','3.435638','-3.6417997039561','3.436453'
'fr','6','in','2.9052666781624','2.649275','3.4259469944679','2.658309'
'fr','6','out','-10.035900028771','3.405229','-9.7317543751058','3.405939'
'fr','7','in','5.8624709921809','2.666273','5.8306588978512','2.675556'
'fr','7','out','-7.7641095171805','3.349498','-7.4638149445554','3.349840'
'fr','8','in','6.7388823793479','2.881111','7.144818814769','2.890622'
'fr','8','out','-7.6759518232429','3.662796','-7.3620716082652','3.663271'
'fr','9','in','6.2909639317482','2.781978','6.2120739214705','2.791452'
'fr','9','out','-6.8173380859888','3.579107','-6.5162097654245','3.579627'
'fr','10','in','6.9923123874011','2.854067','7.0632467227536','2.863419'
'fr','10','out','-12.992754070192','3.671611','-12.687019542307','3.672163'
'fr','11','in','10.395566446074','2.862883','10.403665675295','2.872474'
'fr','11','out','-4.0312417173547','3.686515','-3.7572913812956','3.687034'
'fr','12','in','4.945651335037','3.193865','4.945656340906','3.204342'
'fr','12','out','-10.37032198085','4.108267','-10.109450774898','4.108818'
'fr','13','in','7.9073392214555','3.507221','7.7384158751287','3.518890'
'fr','13','out','-5.7278775016792','4.508702','-5.4519180284586','4.509334'
'fr','14','in','7.9837458277479','3.555159','7.2420472984503','3.570128'
'fr','14','out','-2.8536385586235','4.538924','-2.6217330675993','4.540557'
'na','1','in','6.9472056601972','2.777532','7.0487738043387','2.787343'
'na','1','out','-8.8882216399876','3.638837','-8.4450773890759','3.626890'
'na','2','in','5.238002232238','2.509221','5.38330460589','2.519345'
'na','2','out','0.14922293886888','3.220510','0.37779539015775','3.221178'
'na','3','in','6.4424469418412','2.551147','6.8998889643273','2.575422'
'na','3','out','-1.0730562048411','3.242643','-0.84416098369256','3.244315'
'na','4','in','9.7175694292501','2.673294','9.7660997718942','2.685282'
'na','4','out','2.0327614760269','3.433192','2.3199174749934','3.433905'
'na','5','in','5.8154014831986','2.608852','5.8770858849641','2.621156'
'na','5','out','-3.0663927839187','3.342831','-2.7934163125442','3.343604'
'na','6','in','4.7688194837351','2.596322','4.7822869163911','2.606342'
'na','6','out','-0.55366676153481','3.323073','-0.28837754596566','3.323827'
'na','7','in','5.564990739546','2.624610','5.2884530007897','2.638829'
'na','7','out','-6.5093696414857','3.322283','-6.2379322608392','3.323539'
'na','8','in','9.6864242353763','2.892227','9.0928158724549','2.904967'
'na','8','out','-3.4922337406576','3.650739','-3.2088419179318','3.651546'
'na','9','in','3.6119576141019','2.745743','3.686675232999','2.757416'
'na','9','out','-6.5620208735401','3.526816','-6.3293336760116','3.527140'
'na','10','in','6.8819926615627','2.836726','6.9415348684252','2.846454'
'na','10','out','-10.592905972393','3.649141','-10.360879324663','3.649283'
'na','11','in','7.7535752727971','2.874146','7.5063650322219','2.886017'
'na','11','out','-5.896226354846','3.681028','-5.6771428275144','3.681538'
'na','12','in','9.2483738196858','3.205786','9.5840612706784','3.217515'
'na','12','out','-9.6709620405997','4.140346','-9.4341874904559','4.140864'
'na','13','in','1.9260200725362','3.562581','2.4798608873368','3.574073'
'na','13','out','-1.4764803029032','4.588486','-1.2187468025971','4.589020'
'na','14','in','8.150438289045','3.638181','8.2022451696374','3.653169'
'na','14','out','1.6448768325132','4.707650','1.8652897183002','4.708292'