- &r = 1
- trigger rate
- &r = 2
- rate after cleaning
- &r = 3
- rate after quality cuts
- &r = 4
- rate after background cuts
- &r = 5
- background rate (fOnTimeAfterCuts)
- &r = 6
- excess rate
- &r = 7
- 27 second events
- &r = 8
- threshold 500
- &r = 9
- threshold 750
- &r = 10
- threshold 1000
- &r = 11
- threshold 1250
- &r = 12
- threshod 2500
- &r = 13
- threshold 5000
- &r = 14
- threshold 10000
- &r = 15
- Average of calculated EffOnTime and FTM OnTime
- &r = 16
- Zenith angle corrected R750
- &r = 17
- Event rate after background cuts (Total caclulated ontime)
- &r = 18
- Average of FTM effective on time
- &r = 19
- Sum of FTM OnTime divided by sum of FTM Elapsed time
- &r = 20
- Rate after cleaning corrected for 27sec events run-wise corrected for zenith angle and threshold
- &r = 21
- Physics trigger rate
- &r = 22
- Physics trigger rate corrected for 27sec events
- &r = 23
- Rate after cleaning corrected for 27sec events
- &r = 24
- Rate after background cuts runwise corrected for zenith angle and threshold
- &r = 25
- Rate after quallity cuts runwise corrected for zenith angle and threshold
- &r = 31
- corrected excess rate
- &r = 32
- flux [CU]
- &r = 33
- flux [10^-11/cm2/s]
- &r = 42
- Plot average of &y=... (profile histogram with &y as weights)
- &r = 43
- Plot sum of &y=... (histogram with &y as weights)
- &r = 44
- Plot user defined variable &y=...
- &r = 45
- Plot a histogram (counts) [&y=... can be used to specify what is counted != NULL, if omitted COUNT(*)]
- &r = 46
- Plot a histogram (log10(counts)) [&y=... can be used to specify what is counted != NULL, if omitted COUNT(*)]
- &g = 1
- Binning in moon periods
- &g = 2
- Nightly binning
- &g = 3
- Yearly binning
- &g = 4
- Season binning (lower culmination to lower culmination)
- &g = 5
- Run wise display (might be slow!)
- &g = 6
- Binning in fZenithDistanceMean [default bin-width: 5]
- &g = 7
- Binning in ThresholdMinSet [default bin-width: 50]
- &g = 42
- Use &x=... for x-axis binning [default bin-width: 1]
- &b=...
- Restrict data range (begin) [eg. &b=2011-10-01]
- &e=...
- Restrict data range (end) [eg. &e=2011-10-01]
- Show the plot only [&print]
- &s=...
- Restrict to given source id [eg. &s=5]
- &t=...
- Choose table with analysis results (CutsLC, ISDC, LP:default) [eg. &t=CutsLC]
- &cut=...
- Additional where statement to be added with AND [eg. &cut=fZenithDistance<35]
- &min=...
- y-axis minimum [eg. &min=0]
- &max=...
- y-axis maximum [eg. &max=0]
- &no-errors
- suppress error bars [eg. &no-errors]
- &no-hist
- do not show histogram as bars [eg. &no-hist]
- &x=...
- A x-axis binned in ... [forces &g=42, eg. &x=fZenithDistance]
- &w=...
- Bin width for &g=6/7/42 [eg. &w=2]
- &y=...
- x-axis variable, to be used with &r=42/43/44[/45] [eg. &y=fOnTime]
- &avg=...
- short for &y=... [forces &r=42, eg. &y=fOnTime]
- &sum=...
- short for &y=... [forces &r=43, eg. &y=fOnTime]
- &hist=...
- short for &x=... [forces &r=45, eg. &y=fOnTime]
- &good=...
- some predefined data quality selection: 1 (standard datacheck with R750), 2 (zd<45), 3 (TH<550), 4 (Dust<10), values can be combined [eg. &good=14]

Database = factdata

SELECTfSourceKEYASk, fSourceNameASname, fRightAscensionASraFROMSourceWHEREfSourceTypeKey=1ORDERBYk

SELECT(fPeriod)ASx, (SUM(fNumExcEvts)*3600/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn))ASy, (SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)/60)ASontime, (EXCERR(SUM(fNumSigEvts),SUM(fNumBgEvts))/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)*3600)ASe, (LIMA(SUM(fNumSigEvts),SUM(fNumBgEvts)))ASs, (MIN(fRunStart))asstart, (MAX(fRunStop))asstop, (MIN(fZenithDistanceMin))aszdmin, (MAX(fZenithDistanceMax))aszdmax, (MIN(fAzimuthMin))asazmin, (MAX(fAzimuthMax))asazmax, (MIN(fThresholdMinSet))asthmin, (MAX(fThresholdMInSet))asthmaxFROMRunInfo LEFT JOIN AnalysisResultsRunLPUSING(fNight,fRunID)WHEREfRunTypeKey=1ANDNOTISNULL(fNumExcEvts)ANDNOTISNULL(fEffectiveOn)GROUPBYxHAVING(ontime>60)Roundtrip query time:1417.09 ms