Database Explorer

SQL Error:

Table 'factdata.AnalysisResultsRunAnalysisResultsRunISDC' doesn't exist

SELECT
    (fPeriod) AS x,
    (SUM(fNumExcEvts)*3600/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)) AS y,
    (SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)/60) AS ontime,
    (EXCERR(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)*3600) AS e,
    (LIMA(SUM(fNumSigEvts), SUM(fNumBgEvts))) AS s,
    (MIN(fRunStart)) as start,
    (MAX(fRunStop)) as stop,
    (MIN(fZenithDistanceMin)) as zdmin,
    (MAX(fZenithDistanceMax)) as zdmax,
    (MIN(fAzimuthMin)) as azmin,
    (MAX(fAzimuthMax)) as azmax,
    (MIN(fThresholdMinSet)) as thmin,
    (MAX(fThresholdMInSet)) as thmax
FROM RunInfo
LEFT JOIN AnalysisResultsRunAnalysisResultsRunISDC USING(fNight,fRunID)
WHERE
    fRunTypeKey=1 
     
    AND NOT ISNULL(fNumExcEvts) AND NOT ISNULL(fEffectiveOn)
    
    
GROUP BY x
HAVING
    (ontime>60)

&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]
&print: 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

SELECT
   fSourceKEY AS k,
   fSourceName AS name,
   fRightAscension AS ra
FROM Source
WHERE fSourceTypeKey=1
ORDER BY k


SELECT
    (fPeriod) AS x,
    (SUM(fNumExcEvts)*3600/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)) AS y,
    (SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)/60) AS ontime,
    (EXCERR(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)*3600) AS e,
    (LIMA(SUM(fNumSigEvts), SUM(fNumBgEvts))) AS s,
    (MIN(fRunStart)) as start,
    (MAX(fRunStop)) as stop,
    (MIN(fZenithDistanceMin)) as zdmin,
    (MAX(fZenithDistanceMax)) as zdmax,
    (MIN(fAzimuthMin)) as azmin,
    (MAX(fAzimuthMax)) as azmax,
    (MIN(fThresholdMinSet)) as thmin,
    (MAX(fThresholdMInSet)) as thmax
FROM RunInfo
LEFT JOIN AnalysisResultsRunAnalysisResultsRunISDC USING(fNight,fRunID)
WHERE
    fRunTypeKey=1 
     
    AND NOT ISNULL(fNumExcEvts) AND NOT ISNULL(fEffectiveOn)
    
    
GROUP BY x
HAVING
    (ontime>60)
    

Roundtrip query time: 18.91 ms

X:
Y:
Cut:
Hav: