Changes between Version 49 and Version 50 of DatabaseBasedAnalysis


Ignore:
Timestamp:
08/05/18 13:24:46 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis

    v49 v50  
    7373}}}
    7474
    75 The result (in mysql) is
     75The result using {{{mysql}}} is
    7676{{{
    7777+----------+-------------+-------+-------+---------+---------+
    … …  
    8585So we have 435 data runs from Crab with a total effective observation time of 32.5 hours in a zenith angle range between 6° and 68° and a bad weather factor between 0.01 (really bad) to 1.1 (extremely good).
    8686
    87 Taking only good data by adding "{{{AND fR750Cor/fR750Ref>0.9}}}" to the WHERE-clause gives us
     87Taking only good data by adding "{{{#!sql AND fR750Cor/fR750Ref>0.9}}}" to the WHERE-clause gives us
    8888{{{
    8989+----------+-------------+-------+-------+---------+---------+
    … …  
    9595}}}
    9696
    97 But we also want to restrict ourselves to "good" zenith angles (zenith angles at which there is no significnat efficiency loss). So we add "{{{AND fZenithDistanceMax<35}}}" to the WHERE-clause which yields
     97But we also want to restrict ourselves to "good" zenith angles (zenith angles at which there is no significnat efficiency loss). So we add "{{{#!sql AND fZenithDistanceMax<35}}}" to the WHERE-clause which yields
    9898{{{
    9999+----------+-------------+-------+-------+---------+---------+