# Connection: spayde@hallcl7
# Host: hallcl7
# Saved: 2003-05-08 10:18:04
# 
# Connection: spayde@hallcl7
# Host: hallcl7
# Saved: 2003-05-02 10:17:45
# 
SELECT detector, 
SUM(value/error/error)/SUM(1/error/error) AS ave_value, 
SQRT(1/SUM(1/error/error)) AS ave_error
FROM `run` AS r, `analysis` AS a, `measurement` AS m, 
`detectors` AS d, `particles` AS p
WHERE r.run_id = a.run_id 
AND a.analysis_id = m.analysis_id 
AND d.detector_id = m.detector_id 
AND p.timebin_id = m.timebin_id
AND measurement_type_id = 'a' 
AND run_number > 15406
AND name = 'proton'
AND detector < 15
GROUP BY detector
ORDER BY detector