Changes between Version 6 and Version 7 of DatabaseBasedAnalysis/Benchmarking


Ignore:
Timestamp:
09/02/18 14:43:45 (7 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseBasedAnalysis/Benchmarking

    v6 v7  
    11{{{#!sql
    22SELECT
    3    Events.*
     3   Images.*
    44FROM RunInfo
    5 LEFT JOIN Events   USING (FileId)
     5LEFT JOIN Images   USING (FileId)
    66LEFT JOIN Position USING (FileId, EvtNumber)
    77WHERE
     
    9393{{{#!sql
    9494SELECT
    95    Events.*,
     95   Images.*,
    9696   @DX      := MeanX-X/1.02,
    9797   @DY      := MeanY-Y/1.02,
     
    111111   @ThetaSq := (@Disp*@Disp + @Dist*@Dist - 2*@Disp*@Dist*SQRT(1-@LX*@LX)) AS ThetaSq
    112112FROM RunInfo
    113 LEFT JOIN Events   USING (FileId)
     113LEFT JOIN Images   USING (FileId)
    114114LEFT JOIN Position USING (FileId, EvtNumber)
    115115WHERE
     
    203203{{{#!sql
    204204SELECT
    205    Events.*,
     205   Images.*,
    206206   Angle,
    207207   weight,
     
    225225   @ThetaSq := (@Disp*@Disp + @Dist*@Dist - 2*@Disp*@Dist*SQRT(1-@LX*@LX)) AS ThetaSq
    226226FROM RunInfo
    227 LEFT JOIN Events   USING (FileId)
     227LEFT JOIN Images   USING (FileId)
    228228LEFT JOIN Position USING (FileId, EvtNumber)
    229229CROSS JOIN Wobble
     
    318318{{{#!sql
    319319SELECT
    320    Events.*
     320   Images.*
    321321FROM
    322    Events
     322   Images
    323323WHERE
    324324   FileId IN ($LIST) --
     
    363363{{{#!sql
    364364SELECT
    365    Events.*
     365   Images.*
    366366FROM
    367    Events
     367   Images
    368368LEFT JOIN RunInfo  USING (FileId)
    369369WHERE
     
    417417{{{#!sql
    418418SELECT
    419    Events.*,
     419   Images.*,
    420420   Position.X,
    421421   Position.Y
    422422FROM
    423    Events
     423   Images
    424424LEFT JOIN RunInfo  USING (FileId)
    425425LEFT JOIN Position USING (FileId, EvtNumber)